Importing Programs

Your Customer Success Manager (CSM) would love to partner with you to make sure that you are setup for success. Before you dive into the import process, Unlocking the Power of Illuminate will walk you through some important questions to help you navigate your next steps.

Following the Illuminate ISI Data Spec, prepare a tab-delimited file specifically named programs.txt and upload it to the SFTP server. You can download the spec here.

Important Things to Note

• A unique program record is determined by the following four fields together: Import Student ID, Program ID, Program Start Date, and Site ID.
• While Site ID is not a required field for import, it is required for our ISI California clients, as it is a requirement for CALPADS reporting.
• Did you know that you can exit students from program records with an import? As long as the four fields defined above in a programs.txt file you are importing match a student’s program record in Illuminate, adding a value for Program End Date will close out that record
• If any of the four fields (Import Student ID, Program ID, Program Start Date, and Site ID) for a student program record in Illuminate do not match a record in your import file that you are trying to end, that will result in a duplicate record getting created in Illuminate.
• The required fields are the absolute minimum requirements. However, the more data that you provide, the more comprehensive your data in Illuminate will be. Why not include all available data?

1. First things first, assign yourself, or the person managing the programs import, the appropriate permissions listed above.
2. Review the codes in the Student Programs code table in code management (Admin Gear > Code Management). The values you need to include in column 7 should match the code keys in this code table.

You can either import your programs.txt file once or add it to your nightly automation.

For a one-time import of your programs.txt file, follow our step-by-step guide.

To add the file to your nightly automation, follow our step-by-step guide.