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

I. Starting the Roles file as part of the nightly extract:

To start the extract tool pulling the roles 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

Add a line at the end of the file after the @@users.sql and before the EXIT statement as shown below.

@@roles.txt

The updated lines would then look like this...

@@users.sql
@@roles.sql

EXIT

2). c:\ps_illuminateed_exporter\psexports\ieload.sh

Right click file, select EDIT

Add a line at the end of the file after the put system-info.txt -nopreservetime -nopermissions and before the # commenting out close and exit will stop the cmd window for troubleshooting (IlluminateED) as shown below.

put roles.txt -nopreservetime -nopermissions

The updated lines would then look like this...

put system-info.txt -nopreservetime -nopermissions
put roles.txt -nopreservetime -nopermissions
# commenting out close and exit will stop the cmd window for troubleshooting (IlluminateED)

Complete. The roles.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 roles.txt file is on the sftp server so we can verify the layout.

II. Stopping the Roles file as part of the nightly extract:

To stop the extract tool from pulling the roles 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.
@@roles.sql

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

It would then look like this...
#put roles.txt -nopreservetime -nopermissions

Complete. The roles.txt file will no longer be extracted as part of the nightly export process between PowerSchool and Illuminate.