Hi Drupal Community,
I am trying to migrate the content from one website into another. When I import my CSV (in UNIX UTF-8) it converts " into ? on the import preview. I also get a 'square' in the place of where every new line (hard and soft returns) is supposed to start.

My original file was an XLS, created on a Macintosh using MS Excel. I then opened it in Text Wrangler to convert it to UNIX UTF-8.

Does anyone know what I am doing wrong? The original XLS has markup for HTML.

I appreciate anyone looking into this!

m

Comments

tanoshimi’s picture

tanoshimi commented

Are both your PHP language environment and MySQL (or whatever DB you use) collation also set to UTF-8?

Memeshift’s picture

Memeshift commented

I figured it out. While the exports were correct in format - the thing that solved it was going through in a plain text editor and changing those to straight, regular quotes - that fixed it. TinyMCE (along with my Input Format settings) changed them back to smart quotes after I imported them though - nice:)

Robrecht Jacques’s picture

Robrecht Jacques commented
Status: Active » Fixed

Version prior to 5.x-1.6 used fgetcsv PHP function to parse the CSV files. This function is not UTF8 safe and created a lot of problems with UTF8 characters. The latest version doesn't use fgetcsv anymore and shouldn't have this issue. If, after testing the latest version, you think this is still an issue, reopen it.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.