ISI Extracts for Haiku Learning

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 user file (users.csv), user grade level information (users_levels.csv), a roster file (rosters.csv), an organizations (organizations.csv), and class data (classes.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.

• Users (users.csv))
• User Levels (users_levels.csv))
• Organizations (organizations.csv))
• Rosters (rosters.csv))
• Classes (classes.csv))

Users (users.csv)

• Comma-separated .csv file
• UNIONS data between our user and student table to provide general demographic data.

User Levels (users_levels.csv)

• Comma-separated .csv file
• Student grade-level data.

Organizations (organizations.csv)

• Comma-separated .csv file
• Site data

Rosters (rosters.csv)

• Comma-separated .csv file
• Roster file linking classes to user records.

Classes (classes.csv)

• Comma-separated .csv file
• Class file with course, section, session and teacher information.
• This file does not pull secondary teachers or inactive teachers (teachers who have an end date before the current date). You can verify this information in the Edit Teachers tab in Live Sections.