Create an Extract using a Custom Report

Illuminate Education can generate an automated extract using a Custom Report using our scheduled extract tool. As long as meta-data is available for the interested data in our system, Illuminate Education can generate the extract files. If the meta-data is not available, verify you have access to the meta data. If it is not an issue of access, you can formally request the meta-data using our Aha Ideas page.

If you have an existing report, go to Reports > View Reports > select your report > skip to step 2.

If you do not have an existing report, you will need to first build a custom report.

You can reference our manual on Custom Reports and our manual for Custom Reports: Advanced for in-depth assistance. The following documents might be especially useful:

• Create a Custom Report
• Custom Report Quick Guide
• Add Columns or Data to a Custom Report
• Use Filters on a Custom Report
• Edit a Custom Report
• Manage Columns on a Custom Report
• Removing Duplicates from a Custom Report

Please note the following considerations for the Custom Report:

• The columns (from left to right) will match how the file is generate from left to right.
• The sorting will be matched (i.e. if you sort alphabetically, the extract will sort alphabetically).
• Headers will always be included.
• The headers name set in Manage Columns will determine the name and formate of the column headers.

Please take time to verify your data. We send data as is, meaning any duplicates or blank values will be sent as well. You will want to talk to your vendor regarding the behavior of the data import to see if this will cause issues.

If all looks well, click on the "Advanced" menu in Custom Reports and click on "Make Custom Extract." See the screenshot below for an example of this menu.

This will "save" the Custom Report as an extract for future use and redirect you to our job page, where we scheduled automated extract . To manually return to this page, go to the Admin Cog Wheel > Data Extracts. At the bottom of the page you will see a drop down with a list of your extracts. See screenshot below for an example of this dropdown.

Before continuing with this step, you will want to make sure you have the following information:

• The name of each extract that will be tied to a Custom Report. Please include your extension otherwise it will be omitted.
  • For example, if you have two extracts, one Custom Report for classes and another for students information, request the class file to be named "classes.csv" and the student file to be named "students.csv"
• The delimiter for the extract files. We currently support comma-separated or tab-delimited.
• SFTP Server information. We currently only support Secure File Transfer Protocol (SFTP). The server information needed includes:
  • Hostname
  • Port (if not 22)
  • Username
  • Password
  • Directory to pass files
• Scheduled time to create files (we support multiple times a day)

Return to the Data Extract page by navigating to Admin Cog > Data Extracts . Scroll down to the bottom of the page, click the "Extract" dropdown and select your Custom Report made Extract. Read more about using the Scheduled Extract tool here.

Note that on Step 4, it is highly recommended you send the file directly to the vendor via SFTP. If they do not have a server that supports SFTP, Illuminate may not be able to assist.

Verify the job pushes out your extract files as expected. If you see any formatting issues or unexpected problems with the file, please contact help@illuminateed.com.

Reach out to your vendor and follow up. If there are problems with the data, update your Custom Report. If there are problems with the file generation, contact us at help@illuminateed.com.

Please note if you ask us to speak with your vendor and/or explicitly provide data for your vendor, we will require your Director of Technology and your vendor to fill out a permission application.