Students template for Apple School Manager
Use the Students template to import student accounts. The person_id value must be unique for all locations. See Password policy scenarios.
You can also assign more than one location to a student by adding more location columns to the Students template. You can add up to 998 more location columns; named location_id_2, location_id_3 and so on, up to location_id_999. For each student, you can optionally enter another location_id in each of these columns. This must match a location_id in the Locations template. If this entry does not match, the upload process fails. For more information, see the Locations template page.
Note: If federated authentication is enabled, an email address is required. Additionally, if the specified email address uses a federated domain, that email address must be unique. If the email address is in a federated domain, the user account will also be federated. See Introduction to federated authentication.
Value | Definition | Example | Required/Unique |
|---|---|---|---|
person_id also known as student_id | The number used to uniquely identify this person in your SIS or other database. Use the same person_id value to refer to this person in CSV rosters and classes. | AE4A6BB3-8D97-446A-BAA9-EDEA567453D3 | Yes/Yes |
person_number | A badge number or ID number that identifies this person in your organisation. Unlike person_id, person_number is not used to refer to this person in CSV rosters and classes. | 49 | No/No |
first_name | The person’s first, or given, name. | Amy | Yes/No |
middle_name | The person’s middle name. | M | No/No |
last_name | The person’s last, or family, name. | Frost | Yes/No |
grade_level | The academic year level associated with this person. | 9 | No/No |
email_address | The person’s email address. | af@townshipschools.org.uk | No/No |
sis_username | The username for this person in your SIS or other school database. | amfrost | No/No |
password_policy | The password policy this person should use to sign in to their account. There are three options: “8” (Standard policy; this is the default), “6” (six-digit policy), and “4” (four-digit policy). This value overrides the Location password policy and any password policy previously set. If password_policy is left blank in the CSV file, the default password policy for the students at the location can be set as follows:
| 8 | No/No |
location_id | The location ID of the school or department this person belongs to. | 7BF83DE0-9D69-4662-A1E9-DAAD468DEF09 | Yes/No |