PowerSchool Extract Tool: How do I start/stop the Attendance file as part of the nightly export?
Information on how to Start sending the Attendance files as part of the nightly export process or how to Stop the Attendance files from being sent as part of the nightly export process.
-
I. Starting the Attendance 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.sqlRight 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.
##@@attendance.sql
##@@attendance_find_codes.sql
##@@attendance_find_codes_summary.sql
The updated lines would then look like this...@@attendance.sql
@@attendance_find_codes.sql
@@attendance_find_codes_summary.sql
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.
#put attendance.txt -nopreservetime -nopermissions
#put attendance_find_codes.txt -nopreservetime -nopermissions
#put attendance_find_codes_summary.txt -nopreservetime -nopermissions
The updated lines would then look like this...put attendance.txt -nopreservetime -nopermissions
put attendance_find_codes.txt -nopreservetime -nopermissions
put attendance_find_codes_summary.txt -nopreservetime -nopermissions
Complete. The attendance files will now be extracted as part of the nightly export process between PowerSchool and Illuminate.
II. Stopping the Attendance file as part of the nightly extract:
To stop the extract tool from 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.sqlRight click file, select EDIT
Put double-hash marks (##) in front of this line in that file and then save the file.
@@attendance.sqlIt would then look like this...
##@@attendance.sql
2). c:\ps_illuminateed_exporter\psexports\ieload.shRight click file, select EDIT
Put a single-hash mark (#) in front of this line in that file and then save the file.
put attendance.txt -nopreservetime -nopermissions
It would then look like this...
#put attendance.txt -nopreservetime -nopermissionsComplete. The attendance files will no longer be extracted as part of the nightly export process between PowerSchool and Illuminate.
Please sign in to leave a comment.
Comments
1 comment