CSV Impor does not accept accents

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: ,

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • 08/09/2016 at 5:50 am #385849
    Julien Pham
    Guest

    Hi,

    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.

    Any solution?

    Thanks

    08/09/2016 at 6:01 am #385850
    Julien Pham
    Guest

    Resolved. We need to convert the CSV file to UTF8.
    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…

    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!

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)

You cannot reply to this support topic. Please open your own support topic.