Request a Demo

Courtesy scripts are tools or scripts that Illuminate makes available to districts to help districts facilitate the data process. In most cases, these are not tools or scripts that the Illuminate team has put together. Rather, with the help and support of other districts or other SIS experts we've pulled together some resources to help districts get their data processes started.

We call them "courtesy scripts" because we want districts to realize that we're just trying to help out. In most cases, there's not much that the Illuminate team can do to support the scripts or tools. Ultimately, the queries or scripts need to be run on the district's systems. The Illuminate team doesn't necessarily even know how to install or configure these things. Hopefully these help get the data ball rolling. Hopefully the list below will help clarify what work might need to be done to get things running well. As always, if you are working through any data imports and have questions DEFINITELY contact us at 949-242-0343 or help@illuminateed.com.

Student information systems for which we have scripts:

Aeries

To support Aeries Illuminate has worked with an external contractor to create a tool that will connect to the Aeries database, generate the necessary data files, and transfer the files to Illuminate's SFTP server. The tool can be configured to include or exclude specific datasets. The work required on the district is to install it, configure it, and then use a tool like Windows scheduler to create an automated process to make sure that the tool runs and transfers data every night. Check the downloads page for details on downloading and configuring the Aeries Extract Tool.

Required work on district: The tool needs to be installed somewhere where it can connect to the database. The configuration file needs to be edited. Windows Scheduler (or some other scheduling tool) will need to be used to setup an automated extraction and transfer.

Supported datasets:

  • sites.txt
  • terms.txt
  • courses.txt
  • users.txt
  • studemo.txt
  • enrollment.txt
  • mastschd.txt
  • roster.txt
  • programs.txt
  • transcripts.txt
  • student_grades.txt
  • attendance.txt
  • contacts.txt
  • language.txt
  • specialed.txt
  • health_immunization_summary.txt
  • health_tb.txt
  • health_vaccinations.txt

 

eSchoolPLUS

District contributed scripts. Illuminate really has no idea how to install or configure these, but these should point you in the right direction. Click here to download.

Required work on district: Unknown. Illuminate has no insight into the processes required.

Supported datasets:

  • sites.txt
  • terms.txt
  • courses.txt
  • users.txt
  • studemo.txt
  • enrollment.txt
  • mastschd.txt
  • roster.txt
  • programs.txt
  • transcripts.txt

 

Infinite Campus

District contributed scripts. Illuminate really has no idea how to install or configure these, but these should point you in the right direction. Click here to download.

Required work on district: Unknown. Illuminate has no insight into the processes required.

Supported datasets:

  • sites.txt
  • terms.txt
  • courses.txt
  • users.txt
  • studemo.txt
  • enrollment.txt
  • mastschd.txt
  • roster.txt
  • programs.txt

 

PowerSchool

Illuminate has worked with key PowerSchool users to create an extract tool. For more info on this tool, visit the downloads page.

Required work on district: The tool needs to be installed somewhere where it can connect to the database. The configuration file needs to be edited. Windows Scheduler (or some other scheduling tool) will need to be used to setup an automated extraction and transfer.

Supported datasets:

  • sites.txt
  • terms.txt
  • courses.txt
  • users.txt
  • studemo.txt
  • enrollment.txt
  • mastschd.txt
  • roster.txt
  • programs.txt
  • transcripts.txt
  • attendance.txt
  • contacts.txt
  • language.txt
  • discipline.txt
  • specialed.txt
  • health.txt
  • health_cautions.txt
  • health_immunization_summary.txt
  • health_office_visits.txt
  • health_screening_bmi.txt
  • health_screening_dental.txt
  • health_screening_hearing.txt
  • health_screening_scoliosis.txt
  • health_screening_vision.txt
  • health_tb.txt
  • health_vaccinations.txt
  • transfers.txt

 

Skyward

District contributed scripts. Illuminate really has no idea how to install or configure these, but these should point you in the right direction. Click here to download.

Required work on district: Unknown. Illuminate has no insight into the processes required.

Supported datasets:

  • sites.txt
  • terms.txt
  • courses.txt
  • users.txt
  • studemo.txt
  • enrollment.txt
  • mastschd.txt
  • roster.txt

 

Synergy

District contributed scripts. Illuminate really has no idea how to install or configure these, but these should point you in the right direction. Click here to download.

Required work on district: Unknown. Illuminate has no insight into the processes required.

Supported datasets:

  • sites.txt
  • terms.txt
  • courses.txt
  • users.txt
  • studemo.txt
  • enrollment.txt
  • mastschd.txt
  • roster.txt

 

Zangle

We have been provided with the following scripts for Zangle by the vendor: Aequitas. Illuminate really has no idea how to install or configure these, but these should point you in the right direction. Click here to download.

Required work on district: Unknown. Illuminate has no insight into the processes required.

Supported datasets:

  • sites.txt
  • terms.txt
  • courses.txt
  • users.txt
  • studemo.txt
  • enrollment.txt
  • mastschd.txt
  • roster.txt
  • programs.txt
  • transcripts.txt

 

There are other SIS that we receive data from regularly but for which we have not yet been provided any scripts or queries to redistribute. If you have scripts for any of the systems below, send them our way!