Creating CSV files to import or update user information into Skore
Comma-separated values (or CSV) is a file format that stores tabular data as text files.
- Each column is separated by a comma and space;
- The line break separates the rows.
CSV files are used to import new users information in batches into Skore or to update existing users information just as easily. Here's how to create one:
1. Access our example file clicking here.
2. Make a copy going to File > Make a copy.
3. Access your copy and edit it following the instructions below:
Cell A1 | Email*: An e-mail is required to identify the user, send notifications and password recovery messages.
Cell B1 | Name*: Also required to identify the user.
Cell C1 | Username: Can be used as an alternative to logging in.
Cell D1 | Role: Determines access level for each user and can be set as admin, expert or student. When not specified, users are invited as students by default.
Cell E1 | Password: Setting a password, you skip the invitation email.
Cell F1 | Team(s): Teams set in this field will be automatically created on Skore. You can add as many teams as you want, separated by pipes ( | ).
Cell G1 | Leader(s) email: Here, you can configure a user as a leader and he'll be able to see the progress report from his followers. To do it, will only need to fill this column with the email from the leader on the follower row. If a follower has more than one leader you need to separate them with pipes ( | ).
*Email and name are required. All other fields are optional.
4. Save the file in.CSV format going to File > Download as... > Comma-separated values (.csv, current sheet).
Now your file is ready for upload at Skore. To do it, access the Invitations area on the Settings menu. At the end of the process, you'll receive an email with the registry of the alterations and possíble errors. If you got any error, access the error line, correct it and upload the file again.
If you need further assistance with this, please contact us at firstname.lastname@example.org.