ISI Extract for Office 365's Username Generation

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

An extract that attempts to generate unique usernames along with general student demographic information.

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

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.

• Usernames (usernames.txt))

Usernames (usernames.txt)

• Tab-delimited .txt file
• General student demographic data and a username field which attempts to generate a unique username
• By default, the "Username" field will generate usernames using the first name initial, full last name, and last four digits of local student ID. It will append the domain at the end. For example: John Smith #123456789 with domain @test-school.org will have a username "[email protected]".