Reply To: CSV Impor does not accept accents

08/09/2016 at 10:54 am #385878
Steven Zahm
Keymaster

@ Julien

re: If I have accentuated letters in a field, the CSV import does not import the line. Or if the accentuated letter is in the category field, it just drops the category.

I have not experienced this in testing. Usually the result is the character is import as a diamond with a question mark in it. Could I get a sample of your file?

re: Resolved. We need to convert the CSV file to UTF8.

Yes, for extended characters such as accented character the CSV does need UTF8 encoded.

http://connections-pro.com/documentation/csv-import/#Extended_characters_are_not_being_imported

re: Though when we export from excel, excel does not enclose fields in double or single quotes, I hope there will not be any issue with that…

Nope, that is Excel being “helpful”. It’ll format the file based on the local settings in Windows. Great for exporting and then importing into Excel, not so great because it does not really follow the “standard” for CSV file.

I recommend using either Google Spreadsheet or LibreOffice Calc. Here is a link to more tips for importing CSV files. The page has quite a bit of info, I’ll be worth your time to read.

Hope that helps!