This information is about file preparation for importing details of students studying in your organisation.
Click here if you want to import files for students or groups who will be taking a placement test.
In your file, the column headings, and the order of them, MUST be exactly as follows:
Student ID |
Class name |
Last name |
First name |
|
User name |
Password |
Date of birth |
First language |
Gender |
Column headings |
Notes |
|
1 |
Student ID |
Mandatory – must be entered in each row in your file.
|
2 |
Class name |
Optional – you do not need to include this information.
As part of the import process you will be able to choose to:
|
3 |
Last name |
Mandatory – must be entered in each row in your file. |
4 |
First name |
Mandatory – must be entered in each row in your file. |
5 |
|
Mandatory – must be entered in each row in your file.
|
6 |
User name |
Optional - It is usually the first letter of the first name + last name.
|
7 |
Password |
Optional - You can enter your own student passwords here, or leave this column blank and ask the system to generate them automatically. Password recognition is case-sensitive, but passwords can be repeated.
|
8 |
Date of birth |
Optional - Enter as date/month/year, e.g. 30/12/01 (= 30th December2001)
|
9 |
First language |
Optional - e.g. French, Spanish.
|
10 |
Gender |
Optional - Enter M (male) or F (female). Note If you do not want to include gender, leave cells blank. DO NOT delete the column heading or the column. |
11 |
(Organisation defined field) |
Additional, optional columns. If you want to record any extra information, you can set this up in the OLMS. First define/name up to 4 extra registration fields in Define organisation fields via Manage organisation settings. Any extra fields you create and set will automatically display in the template which you can use to prepare your data. |