Template information for importing records into Apple School Manager
Apple provides six templates to use when adding data to your location. They are:
Students: contains student account information.
Staff: contains staff account information, such as instructors.
Courses: defines courses.
Classes: contains course, instructor (staff) information.
Rosters: contains class, student and location information.
Locations: contains location information.
When you are preparing a template, you must observe the following conventions:
If you edit the templates, replace the example data with your own. Do not change the contents of the header row in any of the files. Do not create duplicate columns in any of the files.
In every template, each row must represent a unique value. For example, within the students.csv file, each row must represent 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