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

Comments

1 comment

  • Avatar
    Brandyna Bishop (Edited )

    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.