PowerSchool Extract Tool: How do I start/stop the Behavior file as part of the nightly export?
I. Starting the Behavior file as part of the nightly extract:
To start the extract tool pulling the attendance 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
Remove the double-hash marks (##) in front of the lines in the file as shown below and then save the file.
(1) ##@@behavior.sql
The updated lines would then look like this...
@@behavior.sql
Note (1) ... this file may or may not be present already... if not just add it to the list.
2). c:\ps_illuminateed_exporter\psexports\ieload.sh
Right click file, select EDIT
If present, remove the single-hash marks (#) in front of the lines in that file as shown below and then save the file.
(1) #put behavior.txt -nopreservetime -nopermissions
The updated lines would then look like this...
put behavior.txt -nopreservetime -nopermissions
Note (1) ... this file may or may not be present already... if not just add it to the list.
Complete. The behavior files will now be extracted as part of the nightly export process between PowerSchool and Illuminate.
II. Stopping the Behavior file as part of the nightly extract:
To stop the extract tool from pulling the behavior 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.
@@behavior.sql
It would then look like this...
##@@behavior.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 behavior.txt -nopreservetime -nopermissions
It would then look like this...
#put behavior.txt -nopreservetime -nopermissions
Complete. The behavior files will no longer be extracted as part of the nightly export process between PowerSchool and Illuminate.
-
Official comment
Note: Please submit a ticket to request the behavior.sql file from the Illuminate data team. Behavior can be implemented in a few different ways in PowerSchool. Also note, the courtesy behavior.sql will most likely need to be adjusted / updated to correctly extract behavior data from your PowerSchool environment.
Comment actions
Please sign in to leave a comment.
Comments
1 comment