PowerSchool Extract Tool: How do I start/stop the Student Portal Accounts file as part of the nightly export?
I. Starting the Student Portal Accounts file as part of the nightly extract:
To start the extract tool pulling the student portal accounts 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.
##@@student_portal_accounts.sql
The updated lines would then look like this...
@@student_portal_accounts.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 student_portal_accounts.txt -nopreservetime -nopermissions
The updated lines would then look like this...
put student_portal_accounts.txt -nopreservetime -nopermissions
Complete. The student_portal_accounts.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 student_portal_accounts.txt file is on the sftp server so we can verify the layout.
II. Stopping the Student Portal Accounts file as part of the nightly extract:
To stop the extract tool from pulling the student portal accounts 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.
@@student_portal_accounts.sql
It would then look like this...
##@@student_portal_accounts.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 student_portal_accounts.txt -nopreservetime -nopermissions
It would then look like this...
#put student_portal_accounts.txt -nopreservetime -nopermissions
Complete. The student_portal_accounts.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
1 comment