Importing user lists

Post Reply
danielberger
Posts: 3
Joined: Thu Aug 06, 2020 7:58 pm
Full Name: Daniel Berger
Organization: Bluffton University

Importing user lists

Post 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
Attachments
WebMOusers.csv
This is a UTF-8 CSV file that should work, according to the Help file instructions.
(322 Bytes) Downloaded 20 times

schmidt
Posts: 26
Joined: Sat May 30, 2020 3:00 pm
Full Name: JR Schmidt
Organization: WebMO, LLC

Re: Importing user lists

Post by schmidt »

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

danielberger
Posts: 3
Joined: Thu Aug 06, 2020 7:58 pm
Full Name: Daniel Berger
Organization: Bluffton University

Re: Importing user lists

Post by danielberger »

My version is 19.

schmidt
Posts: 26
Joined: Sat May 30, 2020 3:00 pm
Full Name: JR Schmidt
Organization: WebMO, LLC

Re: Importing user lists

Post 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.

danielberger
Posts: 3
Joined: Thu Aug 06, 2020 7:58 pm
Full Name: Daniel Berger
Organization: Bluffton University

Re: Importing user lists

Post by danielberger »

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

polik
Posts: 12
Joined: Fri May 29, 2020 6:20 pm
Full Name: Will Polik
Organization: WebMO LLC

Re: Importing user lists

Post 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!

Post Reply