Create Student Data Files
Build the student data files by following the format indicated below.
School (.txt or .csv)
This file identifies all the schools.
|Name||char(250)||Full school name.|
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.
|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.|
|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.|