ISI Extracts for Apple School Manager

Table of Contents

• Summary
• Minimum requirements
• Other recommended specifications
• Rollover Filters
• Extract specifications

Summary

This is a courtesy extract that we can provide to your district. Please ask your Implementation Manager or a Product Specialist to install the Custom Report(s).

We can provide a classes file (classes.csv), a staff file (staff.csv), an instructor file (instructors.csv) and a student demographic file (students.csv).

Minimum requirements

The following minimum requires must be met before we begin. If you did not meet all the requirements, contact our help desk at [email protected] or call our help desk at (949)-242-0343 to get more information.

• District employee responsible for troubleshooting and forwarding issues to Illuminate help
• District employee with knowledge of Secure File Transfer Protocol (SFTP) and access to the Illuminate SFTP server where we drop our extract files
• District entered or uploaded English proficiency data
• District has published master-schedules for their sites
• This extract must be rolled over year-to-year. Please contact ISI Support during the summer to rollover this extract. Please see section "Rollover Filters" for more information.

Other recommended specifications

Missing the following recommendations may result in a number of blank fields and other inconveniences.

• Timeblock names must be set in Timeblock Management.
• Course Long names must be set in Schedule > Course Details.

Rollover Filters

When requesting this extract, you will need to provide the following information to implement it and for any subsequent years we rollover the extract for use.

• Academic Year: What academic year we pull for. We can only pull for a single academic school year.

Extract specifications

Below are the specifications for the files we provide. These file specifications have been created based on standard requirements from the vendor. If you would like to use this standard extract and your district has a custom setup that differs from what Illuminate provides, please work with the vendor to make adjustments to the import. If you believe our specifications are out of date, please be ready to provide the latest specifications from the vendor.

• Classes (classes.csv))
• Staff (staff.csv))
• Instructors (instructors.csv))
• Students (students.csv))

Classes (classes.csv)

• Comma-separated .csv file
• Includes general student demographic data and contact information
• Master-schedule must be published and live for target session.

Staff (staff.csv)

• Comma-separated .csv file
• Pulls users with a teacher or principal role.

Instructors (instructors.csv)

• Comma-separated .csv file
• Pulls all staff for session. Must have a user term role affiliation.

Students (students.csv)

• Comma-separated .csv file
• Pulls students demographic information for session.