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!

[gotwals]

I'm getting the same error with files that I have been using forever. Copy/paste into a text editor is not helping. I've tried a variety of formats, and I'm on a Mac. Just upgraded to 23.0.016e

[gotwals]

Still no luck. I've tried numerous formats. Still getting the "no username group password" error.