NOTE: The PowerSchool Extract Tool requires a special setup for Windows 10. The extract tool works with Windows 7, Windows 10 and Windows Server 2008/2012
Current Version
Email help@illuminateed.com for the PowerSchool Extract Scripts.
Courtesy tool enables districts the ability to quickly extract required IlluminateEd datasets and then transfer them to the Illuminate SFTP server.
Summary
This system is used to extract PowerSchool data into multiple files that can be loaded into IlluminateEd. The export process is performed by several scripts that run with sqlplus on the computer that hosts the Oracle database for PowerSchool or VPN connection for Pearson-Hosting.
Installation
Most users install files on the PowerSchool Database Server but it is not required. Additionally, if clients are hosted via Pearson VPN, a Windows machine must be used. (Please note: Files are configured to the path of C:\\PS_IllumnaiteEd_Exporter).
Configuration
Edit the following files:
-
- C:\\PS_IlluminateEd_Exporter\IEexport.cmd
- C:\\PS_IlluminateEd_Exporter\IEexport.cmd_ALL (Line 1: replace “password” with your PSNavigator Password)
-
- C:\\PS_IlluminateEd_Exporter\psexports\ieload.sh
- C:\\PS_IlluminateEd_Exporter\psexports\INITIAL_SETUP\ieload.sh_ALL (Line 3: Replace “username” and “password” with your assigned Illuminate SFTP username and password)
-
-
C:\\PS_IlluminateEd_Exporter\
ie_export_script_ALL Line 6: DEFINE IE_YEAR_ID = 27 -
Specifies the PowerSchool Year (ie: 26= 2016-2017, 25 = 2015-2016, etc)Line 7: DEFINE IE_ACADEMIC_YEAR = '2017-2018'
-
Labels specific field to the current academic yearLine 8: DEFINE IE_FIRST_DAY = '30-JUN-2017'
-
Specifies the first day of school for the current academic yearLine 9: DEFINE: IE_LAST_DAY = '30-JUN-2018'
-
-
- Specifies the last day of school for the current academic year
Line 11: DEFINE IE_STUDENT_REFERENCE_ID = 's.Student_Number'
Line 12: DEFINE IE_STUDENT_STATE_REFERENCE_ID = 's.STATE_STUDENTNUMBER'
Line 13: DEFINE IE_STUDENT_USERNAME_REF_ID = 's.Student_Number'
Line 14: DEFINE IE_TEACHER_REFERENCE_ID = 't.teachernumber'
- Specifies the last day of school for the current academic year
Automation
The PowerSchool Extract Tool produces the required IlluminateEd dataset and allows the ability to send files to your assigned SFTP account. Once the tool is installed and the config file is setup properly, you are ready to automatically run the IEexport.cmd file with Windows Task Scheduler.