Hello everybody,

I was trying to import a CSV file (my users). I use utf8 format. (Do I have to write utf8 or utf-8?). But for a lot of my rows, I receive a error of importation with the mistaken row. (is it possible to have more info like the first and the second col to find the lines more easily?)

Can you help me to understand where I have made a mistake.

Text fields:         It's text so I don't think that I could have an error here.
Yesno fields:     Define in my CSV by "YES", "No" or nothing.
date fields:         The format used is: 31/12/2007

I would like to insert 62 new fields for 300 trainees, is it to much?

Structure of my csv:
separator: ;
text "
format: utf8

tkx for your help

Anakal

please cut and paste the first 3 rows of your CSV
Claudio

I have find one mistake. Some CR was hidden in my excel file.

I retry and I let you know.

Anakal

Snif snif, still the same. So I attach an example of my csv file.

Importation said that error begin at row 19:

Error row	Error type
19	Error in importing user

Anakal

Your file have several errors, lot of columns are not in the right place. I noted that for exaple, in line 20 (but also in line 2)  the column "location" contains the value "month(s)" and several of this errors. You can see what I mean opening with excel and other programs.
Regards
CLaudio

I think that you have let the "," and ";" as separator . I don't have this error with:

Format: utf8
separator: ; (only)
text: "

And it will be better.

I have find a big, a huge mistake: few user_id was empty!!!! I know I was stupid.

But any case I have another bug:

Error row	Error type
111	Org import err storecustomfields

Mean?   Please help.

Anakal

PS: I give you a new csv.
pps; That's strange, cose all my users are in the database!

It seams that the system encouter a problem with the 'custom field' assigned to the user at the line 111 of the csv

Ciao
Fabio