Page 1 of 1

Importing user lists

Posted: Thu Aug 06, 2020 8:14 pm
by 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

Re: Importing user lists

Posted: Thu Aug 06, 2020 8:19 pm
by schmidt
What WebMO version are you using? This appears to work fine when I import into WebMO 20.

Re: Importing user lists

Posted: Thu Aug 06, 2020 8:20 pm
by danielberger
My version is 19.

Re: Importing user lists

Posted: Thu Aug 06, 2020 8:23 pm
by 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.

Re: Importing user lists

Posted: Thu Aug 06, 2020 8:27 pm
by danielberger
I was using Excel 365 under Windows 10. But the "paste into a text file" worked fine. Thanks!

Re: Importing user lists

Posted: Thu Aug 06, 2020 9:33 pm
by 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!

Re: Importing user lists

Posted: Mon Aug 14, 2023 2:44 pm
by 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

Re: Importing user lists

Posted: Sun Sep 24, 2023 8:46 pm
by gotwals
Still no luck. I've tried numerous formats. Still getting the "no username group password" error.