English > Support

[SOLVED] How to overwrite date added when importing from Csv

(1/5) > >>

deazo:
 Hi again,
 I am creating a new database by CSV importing from an existing database.
 The date added that appear in the new entries are not the ones I can find in my CSV file, would you know how to make sure that date added field is taking the value found in the csv file?
 
 Also, I have been using the comma delimiter since the file I use is a csv, but there are commas in descriptions, actors, etc. so the import tool will take these as delimiters. Would you know how to get around that?
 I have changed the settings in XP to use the ";" instead of the comma, but I guess that's a bit far fetched no?
 Any better solution would help.

Thank you all.

rick.ca:
Use replace=";<->," in your export template (I believe it's in the default CSV template) and then set ";" as the delimiter in the import configuration.

If you still have a problem with the date, I can only guess it might be because the exported data includes the date and time, while the import plugin can only handle dates. If this is the case, you would have to use Excel to change the data to dates only, and then import using the Excel import plugin.

deazo:

 The problem with the dates occurs even when the dates did not have a time.
 It is basically pushed to the next field, so my File Path ends up being the old date added...

deazo:

 By the way, to export I am not using the csv export plugin because it does not export the movie ID, so i use the xml export.
 I then convert the xml into a csv file.
 I will try to include the string you gave me into the xml export.

rick.ca:
There is no "CSV export plugin." There's only the Plain text export plugin. Whatever is exported by it is determined by a user-configurable template. All you need to do is add the mid field to the list of fields exported. You may need/want to add other fields—the template provided is only an illustration. I don't know what problems you might be introducing by converting from XML to CSV. If there are no errors in your file, then I would assume the problem you're having with the date field is the result of the import plugin not being configured properly. The fields have to be mapped in exactly the same order as they occur in the CSV file (as determined by the specified delimiter).

If you still have problems, I would recommend importing the CSV file to Excel, saving it as an Excel file, and then using the Excel import plugin. That allows you to check and revise the data before importing, and the Excel import plugin seems less finicky than the CSV.

Navigation

[0] Message Index

[#] Next page