Rosters template for Apple School Manager
Use the Rosters template to import a class roster. Within an organization, every roster_id value must be unique—for every row in every roster_id template for every location. For example, if a Roster template has 600 students, that’s 600 rows of unique roster_id values, each student’s person_id, and the student’s 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 prevent possible 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.