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 roster_id template for every location. For example, if a Rosters 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 uuidgen command-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.