CSV Import

  • I am having a problem with the CSV import. All of the headers are absolutely correct. The error only occurs when I try to import Chinese characters. I have a field named “chinese” and the data for it is Chinese characters. I have tried to save the file as a normal CSV but when I do that the Chinese characters get turned to question marks like this ???.

    The only way to have the Chinese characters go into the CSV file is to save as UTF-8. But, when I try to import the file it gives me the error of:

    Incorrect column name found in CSV:

    Cannot import data. Make sure all field names are correct in the CSV header.

    I have checked, rechecked and even downloaded a CSV template and I know for a fact the headers are correct.

    I am able to import a normal CSV file with the Chinese characters set to ??? but can’t import the UTF-8 with the Chinese characters.

Viewing 1 replies (of 1 total)
  • Plugin Author xnau webdesign

    (@xnau)

    I think I just answered this in an email, so I’ll duplicate that answer here.

    The CSV absolutely must be UTF-8 and we have to get it working with a file using that encoding. Step one is to make sure the file really is UTF-8 encoded and definitely not with the BOM.

    To make certain the Chinese characters in the header do match the name of the field ( I know you’ve done this already…but it’s unlikely the plugin is wrong about it not matching ) you may need to go directly to the database using phpMyAdmin and paste the Chinese characters in to the “name” column of the field definition. (this is in the wp_participants_database_fields table) If you paste the same string of characters into your CSV as well, you should be able to get a 100% match.

    Take care when you copy the characters, don’t do it from a web page or word processor document without pasting them into a plain text editor first to make sure there are no hidden characters in the paste.

    I know this works, I just tested it. I used Chinese characters generated by Google Translate, no problems with them matching on import.

Viewing 1 replies (of 1 total)
  • The topic ‘CSV Import’ is closed to new replies.