Rosters template for Apple School Manager
Use the Rosters template to import a class roster. Within an institution, every roster_id value must be unique for every row in every Rosters template for every location. For example, if a Rosters template has 600 Students, it contains 600 rows of unique roster_id values, each student’s person_id and their associated class_id.
It must also contain the class_id value of each course and contain at least one student_id value. Additional students are added by row. For example, 10 students would mean 10 rows — one for each student.
To avoid entering potential duplicate roster_id values, use the following functions to generate random values:
In Numbers, use the =RAND function in each cell.
In Microsoft Excel, use the =RAND() function in each cell.
Use Terminal and a shell script with the
The number used to uniquely identify this roster in your SIS or other database.
The class_id of a class.
also known as person_id
The person_id of the student who takes the class, specified by class_id value.