Import fails with special symbol/character

I have been able to import a hierarchical tree of US states and counties from a single CSV file. Especially the batch API (with the progressbar) makes it possible to import large files without script timeouts.

So I will need to know what error message you're getting and preferable what CSV file you're trying to import.

I need the exact file, and the error message you're getting. Otherwise I can't help you.

coupet, I would like to investigate the problem so that it won't happen again to somebody else. Can you give me the exact CSV file you used (so not the Excel file) and the exact error message you got?

I think if you add a line

setlocale(LC_ALL, 'en_US.UTF-8');

before the line

while ($line = fgetcsv($handle, 4096, $delimiter)) {
}

it will work. At least that's what worked for my file with multibyte strings. I guess you can add an option to the csv import form for setting this value.

Thanks nnn,

This has worked for me as well.

Be sure your file is encoded in UTF-8

Using gVim:

:setlocal fenc=utf-8

Alright, I'll try to make it work with any encoding.

The batch API crashed as a result from the Windows-encoded lines. Fixed by base64-encoding the lines before passing them to the batch operations array.

Fixed in the latest development version.

Thanks!