Moodle in English: Invalid CSV file format - number of columns is not constant!

Hello,

I am using version 1.9.

got error when upload user:
Invalid CSV file format - number of columns is not constant!

The CSV File is below:

username password firstname lastname email lang idnumber maildisplay course1 group1 type1
richard ricahrd12 Richard Bef Aco S.Pd user@email.com en 0 1 course1 GehF 1
albet albert34 Albet Kui "Bula, S.Pd" user4@email.com en 0 1 course1 GehF 1

Regards,
Wildan

Mittelwert: -

Re: Invalid CSV file format - number of columns is not constant!

von Kristy Rhea - Freitag, 30. Mai 2008, 07:59

I had the same thing happen to me. It's the "," you have in the lastname field for Bula, S.PD. When uploading as a csv file it recognizes the comma and thinks it is a new field. If you need to keep the commas in, change you separator to ; in Control panel, regional and language settings, regional tab, click settings, and change you list separator. (in windows) , re save your document, upload to moodle, on the upload users page make sure to change the drop down box to ; and upload your users.

By changing this setting in our control panel it will change you list separator for every file. You may run into issues when doing a bulk course creation with csv file if you dont use a comma, but you can always go back into control panel and change if needed.

Mittelwert:Useful (3)

Re: Invalid CSV file format - number of columns is not constant!

von Richard Pinner - Donnerstag, 31. Juli 2008, 23:12

Thanks so much for that - very useful and fixed my problem right away.

Mittelwert: -

Re: Invalid CSV file format - number of columns is not constant!

von Adma Lim - Montag, 6. Juli 2009, 17:27

hi, beside the above mentioned char, any other know char that would probably generate the same error message?

Char like:
'
,

Mittelwert: -

Re: Invalid CSV file format - number of columns is not constant!

von Dave Cuttriss - Dienstag, 25. August 2009, 17:18

Also many thanks from me. Saved me a lot of drama with an 1800 entry CSV

Dave

Mittelwert: -

Re: Invalid CSV file format - number of columns is not constant!

von Melanie Scott - Montag, 9. November 2009, 21:46

Besides that, sometimes a spreadsheet might start with 50 rows but you delete the data from them...then it show up as having empty rows that leave rows and rows of ,,,,,,,. Instead of deleting the data, you have to delete the whole row.

If you don't, you can open the CSV as a notepad item and delete them. This also makes it easy to see where the problem lies.

I've taken to checking the CSV in notepad before uploading just as a time saver.

Mittelwert:Useful (2)