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.

The scenario is as follows:

Vocabulary: Car

Term1: Term2: Term3: Term4:
Year Make Model Type
2000 BMW 318 Sedan
2000 BMW 318 Coupe
2001 Ford Taurus Sedan

-Term1 (Year)
-Term2 (Make)
-Term3 (Model)
-Term4 (Type)

Darly

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

Hello naquah,

I think the problem was a square symbol inside the term name. I removed it and everything works now.

Thanks, Darly

Note: see attached file with term name.

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?

naquah, attached is the csv file. I renamed the file extension to txt to allow for upload. Unable to upload file with csv extension. The original file was created in microsoft excel and save as a csv file.

Seems Character Sets and Encodings issue.

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!

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