Overview
For SIS integrations with Edlio via SFTP, your data files must include specific types of information. The exact field names can be customized or remain the same as your internal fields. What matters most is that each column's data fulfills the intended purpose outlined below.
Template Files
To help you get started, we've included downloadable CSV templates. Download TemplateFiles.zip to review the recommended structure and data examples.
Template Files and Field Descriptions
Classes.csv
Field Name | Required | Notes / Description |
Classroom ID | Yes | Unique ID for each Classroom |
Classroom Name | Yes | Name of the Classroom |
Classroom Description | No | Description of the Classroom |
Organization ID | Yes | Organization, Building, or School ID |
Enrollments.csv
Field Name | Required | Notes / Description |
Classroom ID | Yes | Should match a valid Classroom ID |
Person ID | Yes | Should match the Unique ID for Teacher or Student, one per row |
Staff.csv
Field Name | Required | Notes / Description |
Unique ID | Yes | UUID/GUID, must be consistent across all organizations |
Employee ID | Yes | Unique Staff Identifier |
Role | Yes | |
Title | No | Staff Title |
Department | No | Department Name |
First Name | Yes |
|
Middle Name | No |
|
Last Name | Yes |
|
Yes | Must be globally unique between users | |
Phone 1 | No* | Primary Phone, required if you intend on using the Mass Communication system. |
Phone 2 | No | Secondary Phone |
Home Language | No | Only ISO 639-1 codes are accepted |
Organization ID | Yes | Organization, Building, or School ID |
Users.csv
Field Name | Required | Notes / Description |
Unique ID | Yes | UUID/GUID, must be consistent across all organizations |
Student ID | Yes | Unique Student Identifier |
Role | Yes | |
First Name | Yes |
|
Middle Name | No |
|
Last Name | Yes |
|
Yes | Must be globally unique between users | |
Phone 1 | No* | Primary Phone, required if you intend on using the Mass Communication system. |
Phone 2 | No | Secondary Phone |
Home Language | No | Only ISO 639-1 codes are accepted |
Grade | No | Student Grade |
Organization ID | Yes | Organization, Building, or School ID |
Relationship ID | Yes | For Students: Use the Parent Unique ID. For Parents/Guardians/Relatives: Use the Student Unique ID. |