If you want to edit the students details or add/remove them from groups in large numbers (bulk edit), then you can use the Export and Import options in the ‘Students’ tab of the Academy section.
Exporting students
You can export a specially-formatted spreadsheet i.e. a CSV file (comma-separated value), which will have the details of all students in your academy. This will help you with tasks like:
- Having a single file to view all your students details
- Editing your students details in bulk (change in username, email, lichess username, adding/removing from groups, etc.)
To export all your students in a CSV file, click the “Export” button, and the CSV file will be downloaded:
Bulk edit in CSV file
After the CSV file is downloaded, open it to edit your students details. The students will be sorted in the ascending order of their first name. Below is an example:
The different columns and their purpose are explained in the below table:
| Column | Description | Notes |
|---|---|---|
| uuid | Unique ID of the student account | Do NOT edit this |
| username | Username of the student account | It can be edited. It cannot be empty. |
| firstname | First name of the student | It can be edited. It cannot be empty. |
| lastname | Last name of the student. | It can be edited. It cannot be empty. |
| Email address of the student to send email notifications | It can be edited. It cannot be empty. | |
| lichess_id | lichess username of the student to sync the games played by them in that platform to Chesslang Database. | It can be edited. It can be empty. |
| chess_com_id | chess.com username of the student to sync the games played by them in that platform to Chesslang Database. | It can be edited. It can be empty. |
| groups | Groups that the student is part of | It can be edited. It can empty. |
In the below example, we are updating the last name for Ben, and adding Bose to the “Beginners” group.
After making all changes, save the CSV file (you can also save it as a new CSV file if you don’t wish to overwrite the exported CSV file).
Importing students
To import a CSV file to the platform, click on the “Import” button, and then choose the file to upload it.
a) Import Successful
When the CSV file has correct details as per the data requirements mentioned above, the import will be successful and you will see this message:
And you can see the changes we made to the CSV file are updated. That is, Ben’s last name is updated and Bose has been added to the “Beginners” group.
b) Import Failed (errors in CSV file)
When your CSV file has some errors such as an incorrect group name or empty username and/or uuid, you will see an error message.
Important note: When your imported CSV file has some errors, only those rows will remain unchanged. All the other changes will pass through and will be reflected in Academy –> Students.
In the below example, we are trying to add Carlos to a group “New Student Group” which does not exist.
And when we try to import this file, we will see the following error:
