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
email	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

Section_Mapping.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	email	role	source	source_id
9403620121	Bobby	Blue	[email protected]	admin
3056833443	Penny	Pink	[email protected]	teacher
9784388740	Sarah	Silver	[email protected]	teacher
5427757952	Greg	Grey	[email protected]	student	schoology	217896
4667720471	Robert	Red	[email protected]	student	schoology	198356
3243547846	Gary	Green	[email protected]	student	schoology	690863
8982881654	Pam	Purple	[email protected]	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 [email protected].