Create Student Data Files

FYI: 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.

School (.txt or .csv)

This file identifies all the schools.

Column Name Type Description
SchoolCode char(15) URN
Name char(250) Full school name.

Example:

LINC|Lincoln Secondary School|1
JOHNS|Johns Middle School|2

Student (.txt or .csv)

This file identifies all enrolled students that will use Xello in years 7-13. It must include the CurrentSchoolCode.

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 Student's birth date. Format dd-mm-yyyy. 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.
PreRegSchoolCode char(75) The SchoolCode that the student will be attending next year. This can be comma delimited if registered at multiple schools. If blank, we assume CurrentSchoolCode.

Username char(100) UPN ID cannot be used as username. Email addresses or any username used by the school can be provided as their Xello username.
OPTIONAL COLUMNS
Email 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.
SSOStudentToken   Speak to your Onboarding Manager about SSO Options and configuration.

Example:

10005252|Erin|Smith|F|2005-01-12|8|JOHNS|LINC