[Administration] How to create a CSV file of student sessions for bulk upload

CSV files can be made by text editors or table-based editors that support the .csv file format. The end result should contain the following columns:

[name],[email address],[individual info],[open time],[external id],[skip requirements?]

You can skip columns by leaving them empty or omitting any column that you don’t need at the end of each row. The [name] and [email address] columns are mandatory, all the others are optional.

• The format for [open time] is ISO 8601, e.g. “2024-03-17T09:00:00+01:00” for 17 March 2024 at 9:00 CET.
• The format for [skip requirements?] is “true” or “false” (the default being false).
• The format for [individual info] is a string, which may contain simple HTML formatting options such as <br/> or <em> tags. The [individual info] is what the student will see above their exam instructions. This can be useful for providing private info, such as login details for the testing environment.

In a text editor:

simply add a student by typing

[name],[e-mail address]

or

[name],[email address],[individual info]

or

[name],[email address],,[open time],,[true|false]

Put each student on a separate row and save with the .csv extension. Do not add spaces after each comma.

In a spreadsheet such as Microsoft Excel:

Divide this information into columns, without header column:

name | e-mail | individual info

Again, one student on each row.

Saving instructions

Make sure to save csv files with UTF-8 encoding. Not doing so will likely result in non-Latin characters (including ones such as ö é ę ł) not being saved correctly.

The program you use for saving csv files will likely either prompt you for the encoding upon saving (as a new file), or show it in a bottom bar of the editor.