4 minutesBefore you begin, for a reminder on the file structure notes and automating subsequent exports, check out Build Data Export Files.
Build the student data files by following the format indicated below.
We recommended uploading an updated student .csv file on a termly basis.
School (.csv)
This file identifies all the schools.
| Column Name | Type | Description |
|---|---|---|
| SchoolCode | char(15) | Unique to district. |
| Name | char(250) | Full school name. |
Example:
LINC|Lincoln Secondary School|1
JOHNS|Johns Middle School|2
Student (.csv)
This file identifies all enrolled students that will use Xello in
| Column Name | Type | Description |
|---|---|---|
| UPN ID | char(15) | The student's unique pupil number that identifies each pupil in the local-authority-maintained school system. |
| FirstName | char(100) | Student's first name. |
| LastName | char(100) | Student's last name. |
| Gender | char(1) | M = Male, F = Female, N = Not Specified. |
| DateOfBirth | Date |
Format Note: Ensure the format is entered correctly. Do not spell out the date. |
| CurrentYear | Int | The year the student is in. Note:Ensure the format is only the numerical value. Do not include the word "Year". |
| CurrentSchoolCode | char(15) | The SchoolCode of the student's current school. |
| Username | char(100) | UPN ID cannot be used as username. Email |
| OPTIONAL COLUMNS | ||
| char(100) | Student's email address. | |
| Password | char(10) | Suggested password for the student. |
| ULN ID | char(15) | A student's unique learner number is used alongside and to access the Personal Learning Record of anyone over the age of 13 involved in UK education or training. |
| PersonalStudentEmail | char(100) | Student's personal email address. |
Example:
10005252|Erin|Smith|F|01-12-2005|8|JOHNS|LINC
