Before 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.
School (.txt or .csv)
This file identifies all the schools
Column Name | Type | Description |
---|---|---|
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 |
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
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.
Column Name | Type | Description |
---|---|---|
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. |
CurrentGrade | Int |
The grade the student is in. Note: Use "0" for kindergarten. |
CurrentSchoolCode | char(15) | The SchoolCode of the student's current school. |
PreRegSchoolCode | char(75) | The SchoolCode that the student will be attending next year. If blank, we assume CurrentSchoolCode. |
DateOfBirth | Date |
Format Note: Ensure the format is entered correctly. Do not spell out the date. |
OPTIONAL COLUMNS | ||
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. | |
PersonalStudentEmail | char(100) | Student's personal email address. |
Example:
10005252|Erin|Smith|F|2005-01-12|8|JOHNS|LINC