Template information for importing records into Apple School Manager
Apple provides six templates to use when adding data to your location:
Students: contains student account info.
Staff: contains staff account info, such as instructors.
Courses: defines courses.
Classes: contains course, teacher (staff) info.
Rosters: contains class, student and location info.
Locations: contains location info.
When preparing a template, the following criteria must be met:
If you edit the templates, replace the example data with your own. Do not change the contents of the header row in each file. Do not create duplicate columns in any file.
In every template, each row must represent a unique value. For example, within the students.csv file, each row must be a unique student. Certain values for that student can be empty. Literal values — for instance, a line break or quotation mark within a name — must be escaped with a backslash (\). Here is an example: \". Any identifiers entered must be alphanumeric and can include a hyphen (-).
If your value contains a space ( ) or a comma (,), use straight quotation marks (") around it. If your value does not have any of these special characters, do not use quotation marks. If you do not use quotes where they are needed, or you use curly quotes, you will get errors in the upload process.
The values in your files must be separated with commas (,) or semicolons (;), regardless of how you created the file. Do not use spaces or tabs between a comma or semicolon and the next value. Each file must be encoded as UTF-8. To represent end of line, use the UNIX newline encoding \n.
For the students.csv and staff.csv files, person_id must be unique for all locations.
The names of the CSV files should match the original filename exactly.
All files must be compressed into one zipped (.zip) archive file to be uploaded.
No file may be placed within a folder in the zipped archive file.
All foreign-key references to other CSV files must be defined in the referenced file.
Character limits in CSV templates
Some fields in the CSV templates have limits on the number of characters allowed.
Students, Staff, Classes, Rosters
Students, Staff, Courses, Classes, Locations