Search Release Notes and Blogs

Apple School Manager (ASM) Export Utility

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.”

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

Note: 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:

  1. Obtain the SFTP credentials from the ASM Setup Assistant.

    ASM Setup Assistant SFTP Credentials

    ASM Setup Assistant
    SFTP Credentials
  2. In AdminPlus, click Tools > Custom > Apple ASM Export.

    The Apple ASM Export dialog box opens.

  3. In the Apple ASM Export dialog box, configure the tabs as outlined below:

    General Specifications Tab Configuration

    General Specifications Tab
    # 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

    Student Information Tab
    # 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

    Teacher Information Tab
    # 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

    Course Section Information Tab
    # Specification Setting
    1. Include Active/Inactive Courses? Options are: Active Only, Inactive Only, Both Active & Inactive

    Note: Courses.csv contains course descriptions, not course names.

  4. When the tabs are configured, click Send Data Now.