uploading users

[kmcounsell]

I have tried to upload a csv file with user names in one cell and passwords in another. I receive the following error message.
INSERT INTO sitewidepermissions (userid,usertype,adduser,edituser,makelevelzerouser,addplugin,installtemplate,edittemplate,removetemplate,deleted) VALUES (103,'user',,,,,,,,0)

MDB2 Error: syntax error

Problem Executing statement

[mhughes2k]

It appears that you may have a blank line in the your CSV file.

If you just check that your cursor doesn't move past the last character of the last line it should work.

I'll check the code that validates each line of the CSV, and add some extra validation if necessary to the Community Edition of SIMPLE.

[kmcounsell]

Tried that. Made sure there were no gaps at the top or bottom of list. No headings either, just student names, user id and password. Also put the cursor inside the last line. Still no good. Here is the error message.
INSERT INTO sitewidepermissions (userid,usertype,adduser,edituser,makelevelzerouser,addplugin,installtemplate,edittemplate,removetemplate,deleted) VALUES (109,'user',,,,,,,,0)

MDB2 Error: syntax error

Problem Executing statement

[mhughes2k]

Can you upload the CSV file?