We’ve implemented an export utility that helps schools prepare student, staff, and class data for Apple School Manager. This utility uploads data in a zipped file using SFTP. The Apple School Manager Export Utility benefits school administrators by decreasing the amount of time they spend on manual data entry, allowing them to focus on administrative tasks.
What Is Apple School Manager?
“Apple School Manager is a service that lets you buy content, configure automatic device enrollment in a school’s mobile device management (MDM) solution, and create accounts for students and staff. Apple School Manager is accessible on the web and is designed for technology managers, IT administrators, staff, and instructors.”
Apple Support
Why Are Schools Using It?
Apple School Manager allows schools to easily:
- Assign devices to an MDM solution
- Purchase apps & learning materials
- Create accounts for staff, instructors, and students
What Are the Benefits of the ASM Export Utility?
Through the ASM Export Utility in AdminPlus, schools can prepare and upload student, staff, and class data to ASM, which then uses this data to create the necessary accounts and data tables for use within ASM.
The export utility creates a zip file of your school's data to upload it to ASM. This zip file contains the following files:
Zip File Contents
| Export Information | Associated File |
|---|---|
| School Level Information | locations.csv |
| Student Information | students.csv |
| Staff Information | staff.csv |
| Section Information | classes.csv |
| Course Information | courses.csv |
| Student Roster Information | rosters.csv |
Each export generates a log file that you can access using the View Log button in Tools > Custom > Apple ASM Export.
How Do I Set It Up?
Before you begin setup, ensure that you have at least the following versions of the required software:
Software Requirements
| Program | Version |
|---|---|
| AdminPlus | 6.1.10.01 |
| ASM Export Utility | 1.5.0 |
Once you've verified that your software meets the version requirements, do the following:
Obtain the SFTP credentials from the ASM Setup Assistant.
ASM Setup Assistant SFTP Credentials
In AdminPlus, click Tools > Custom > Apple ASM Export.
The Apple ASM Export dialog box opens.
In the Apple ASM Export dialog box, configure the tabs as outlined below:
General Specifications Tab Configuration
# Specification Setting 1. Enable ASM Export? Yes 2. SFTP Server URL? Enter URL from ASM Setup Assistant 3. Port? 22 (default port for FTP/SFTP) 4. Folder Name? Leave this box blank 5. Login Name? Enter Username from ASM Setup Assistant 6. Password? Enter Password from ASM Setup Assistant 7. Export Start Time? (Used for auto-export. Not available for Rediker cloud schools.) 8. Export Time Interval? (Used for auto-export. Not available for Rediker cloud schools.) 9. Include Header Line in Export files? Yes A. Encoding Format? UTF-8 Student Information Tab Configuration
# Specification Setting 1. Include Active/Inactive Students? Options are: Active Only, Inactive Only, Both Active & Inactive 2. Start Grade? 3. End Grade? 4. Student Email ID? Must be mapped to a database field. Field values can be blank. 5. User Name? Must be mapped to a database field. Field values can be blank. 6. Password? Must be mapped to a database field. Field values can be blank. Teacher Information Tab Configuration
# Specification Setting 1. Include Active/Inactive Teachers? Options are: Active Only, Inactive Only, Both Active & Inactive 2. Teacher Email ID? Must be mapped to a database field. Field values can be blank. 3. User Name? Must be mapped to a database field. Field values can be blank. Course Section Information Tab Configuration
# Specification Setting 1. Include Active/Inactive Courses? Options are: Active Only, Inactive Only, Both Active & Inactive Courses.csv contains course descriptions, not course names.
When the tabs are configured, click Send Data Now.