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 in the district.
|SchoolCode||char(15)||Unique to district.|
|Name||char(250)||Full school name.|
|SchoolType||Int|| 1 for secondary or high school
2 for elementary or middle school
3 for other
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 grades K-12. It must include the CurrentSchoolCode and PreRegSchoolCode.
The student CurrentSchoolCode and PreRegSchoolCode will be the same in many cases. However, when a student is transitioning from Grade 8 to Grade 9, or if they're transferring schools, the CurrentSchoolCode indicates the student's elementary, middle (or sources) school, and PreRegSchoolCode indicates the high school location the student will attend next year.
|StudentID||char(15)||Unique for the district (not just unique to the school). If this is not unique for the district, please inform your Onboarding Manager.|
|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 yyyy-mm-dd. Student's birth date.|
|CurrentGrade||Int||The grade the student is in.|
|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.|
|StateProvNumber||char(20)||The student's unique state or province ID.|
|char(100)||Student's email address.|
|Password||char(10)||Suggested password for the student.|
|SSOStudentToken||Speak to your Onboarding Manager about SSO Options and configuration.|