PowerSchool Extract Tool: How do I start/stop the Attendance file as part of the nightly export?

Follow

Brandyna Bishop

December 20, 2016 17:14

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.

0

• 

  Brandyna Bishop December 20, 2016 17:15 (Edited January 26, 2017 17:19)

  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.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.

  ##@@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.sql 

  Right click file, select EDIT
  Put double-hash marks (##) in front of this line in that file and then save the file.
  @@attendance.sql

  It would then look like this...
  ##@@attendance.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 attendance.txt -nopreservetime -nopermissions
  
  It would then look like this...
  #put attendance.txt -nopreservetime -nopermissions

  Complete.  The attendance files will no longer be extracted as part of the nightly export process between PowerSchool and Illuminate.

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.