PowerSchool Extract Tool: How do I start/stop the Roles file as part of the nightly export?
I. Starting the Roles file as part of the nightly extract:
To start the extract tool pulling the roles data, there are two files that will need to be modified. The instructions for modifying each file are provided below:
1). c:\ps_illuminateed_exporter\ie_export_script.sql
Right click file, select EDIT
Add a line at the end of the file after the @@users.sql and before the EXIT statement as shown below.
@@roles.txt
The updated lines would then look like this...
@@users.sql
@@roles.sql
EXIT
2). c:\ps_illuminateed_exporter\psexports\ieload.sh
Right click file, select EDIT
Add a line at the end of the file after the put system-info.txt -nopreservetime -nopermissions and before the # commenting out close and exit will stop the cmd window for troubleshooting (IlluminateED) as shown below.
put roles.txt -nopreservetime -nopermissions
The updated lines would then look like this...
put system-info.txt -nopreservetime -nopermissions
put roles.txt -nopreservetime -nopermissions
# commenting out close and exit will stop the cmd window for troubleshooting (IlluminateED)
Complete. The roles.txt file will now be extracted as part of the nightly export process between PowerSchool and Illuminate.
Please notify Illuminate via help@illuminateed.com when your roles.txt file is on the sftp server so we can verify the layout.
II. Stopping the Roles file as part of the nightly extract:
To stop the extract tool from pulling the roles data, there are two files that will need to be modified. The instructions for modifying each file are provided below:
1). c:\ps_illuminateed_exporter\ie_export_script.sql
Right click file, select EDIT
Put double-hash marks (##) in front of this line in that file and then save the file.
@@roles.sql
It would then look like this...
##@@roles.sql
2). c:\ps_illuminateed_exporter\psexports\ieload.sh
Right click file, select EDIT
Put a single-hash mark (#) in front of this line in that file and then save the file.
put roles.txt -nopreservetime -nopermissions
It would then look like this...
#put roles.txt -nopreservetime -nopermissions
Complete. The roles.txt file will no longer be extracted as part of the nightly export process between PowerSchool and Illuminate.
Please sign in to leave a comment.
Comments
0 comments