Importing user lists

[danielberger]

WebMO is not allowing me to import a user list. I have attached the file that doesn't work.

When I try using this list, WebMO returns an error message that I need "username" "group" and "password" columns. But I have those!

What's going on?

Dan Berger

[schmidt]

What WebMO version are you using? This appears to work fine when I import into WebMO 20.

[danielberger]

My version is 19.

[schmidt]

Was the CSV file made with a Mac? Mac Excel often saves CSV files with an (invisible) 1-byte byte order marker at the beginning. This is handled with WebMO 20. For earlier versions you may wish to try copy/pasting the file in a text editor to avoid this issue.

[danielberger]

I was using Excel 365 under Windows 10. But the "paste into a text file" worked fine. Thanks!

[polik]

CSV UTF-8 works in WebMO 20.

In WebMO 19 and earlier, CSV UTF-8 fails because of the character encoding. A work-around for earlier versions of WebMO is to save the Excel file as:
* Tab Delimited Text (.txt)
* Comma Separated Values (.csv)
which use standard ASCII encoding. Or copy-and-paste into a standard text editor and save that file, as you have done!