Rosters template for Apple School Manager
Use the Rosters template to import a class roster. Within an organisation, 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
uuidgencommand-line tool.
Value | Definition | Example | Required/Unique |
|---|---|---|---|
roster_id | The number used to uniquely identify this roster in your SIS or other database. | BE8FF4CC-5BE2-47C6-9C42-6CDADB9072F8 | Yes/Yes |
class_id | The class_id of a class. | F9BF05A9-E40B-4CAD-9B4A-2E0C09EDCCC4 | Yes/No |
student_id also known as person_id | The person_id of the student who takes the class specified by class_id value. | AE4A6BB3-8D97-446A-BAA9-EDEA567453D3 | Yes/No |