Follow the format below to fill out your three roster files.
Users.csv
| user_id | The unique ID of the user in the SIS |
| first_name | User’s first name |
| last_name | User’s last name |
| User’s email | |
| role | admin | teacher | student |
| source (optional) | canvas | schoology | leave blank if no SSO |
| source_id (optional) | User’s Canvas or Schoology ID. Required if source given. |
Sections.csv
| section_id | The unique ID of the section in the SIS |
| section_name | Section name |
SectionMappings.csv
| user_id | ID of the user you want to assign to this section |
| section_id | ID of the section |
NOTE 1: All students and teachers must be assigned to at least one section and may be assigned to more than one section.
NOTE 2: Admins by default already have access to all sections. Therefore, admins should not be assigned to specific sections and can be excluded from Section_Mapping.csv.
Examples of Completed Files
Users.csv
| user_id | first_name | last_name | role | source | source_id | |
| 9403620121 | Bobby | Blue | bobby.blue@school.com | admin | ||
| 3056833443 | Penny | Pink | penny.pink@school.com | teacher | ||
| 9784388740 | Sarah | Silver | sarah.silver@school.com | teacher | ||
| 5427757952 | Greg | Grey | greg.grey@school.com | student | schoology | 217896 |
| 4667720471 | Robert | Red | robert.red@school.com | student | schoology | 198356 |
| 3243547846 | Gary | Green | gary.green@school.com | student | schoology | 690863 |
| 8982881654 | Pam | Purple | pam.purple@school.com | student | schoology | 041661 |
Sections.csv
| section_id | section_name |
| SEC001 | Summer School 2023 - Algebra I Credit Recovery |
| SEC002 | Summer School 2023 - Biology Credit Recovery |
| SEC003 | Summer School 2023 - Geometry Credit Recovery |
Section_Mapping.csv
| user_id | section_id |
| 3056833443 | SEC001 |
| 3056833443 | SEC002 |
| 3056833443 | SEC003 |
| 9784388740 | SEC003 |
| 5427757952 | SEC003 |
| 5427757952 | SEC001 |
| 5427757952 | SEC002 |
| 4667720471 | SEC001 |
| 3243547846 | SEC002 |
| 8982881654 | SEC002 |
| 8982881654 | SEC003 |
Need additional help?
If you encounter any issues or have questions regarding this process, please reach out to us at implementation@subject.com.