SDMSDM Documentation
Reference

ASM Format

Apple School Manager CSV format

ASM Format

Apple School Manager requires specific CSV files in a ZIP archive.

Required Files

FileContents
locations.csvOrganizations
students.csvStudent users
staff.csvTeachers and staff
courses.csvCourse definitions
classes.csvClasses with instructors
rosters.csvStudent enrollments

locations.csv

ColumnDescription
location_idUnique identifier
location_nameDisplay name

students.csv

ColumnDescription
person_idUnique identifier
first_nameGiven name
last_nameFamily name
email_addressEmail
sis_usernameUsername
password_policy4, 6, or 8
location_idSchool reference
gradeGrade level

staff.csv

ColumnDescription
person_idUnique identifier
first_nameGiven name
last_nameFamily name
email_addressEmail
sis_usernameUsername
location_idSchool reference

classes.csv

ColumnDescription
class_idUnique identifier
class_numberClass code
course_idCourse reference
instructor_idPrimary instructor
instructor_id_2-15Additional instructors
location_idSchool reference

rosters.csv

ColumnDescription
roster_idUnique identifier
class_idClass reference
student_idStudent reference

On this page