If you have not yet updated to the newest Sloopy scripts, please contact School Loop at least two weeks before the start of the new school year. The new scripts are easier to implement, modify, and maintain. Additionally, they support data exports for attendance and our Call Alert feature.
Aeries SQL - old Scripts prior to April 2010
- In the
aeries_config.txtfile for each school, change the value in
database.url=to the new school year's database name.
Aeries Access - old Scripts prior to April 2010
- If running as a Windows scheduled task, the properties line needs to read
- Change XX to the current school year and drop the “...”.
- If running "live," the script asks for a school year. Be sure to use the correct value.
PowerSchool Reporting Engines
SchoolloopStudentSectionsExportSQL.rpt, change the termid values for the current year.
For example, for the 2017-2018 school year the line should be:
WHERE (cc.termid = 2700 OR cc.termid = 2701).
SchoolloopSectionsExportSQL.rpt, change the termid values for the current year. For example, the 2017-2018 school year the line should be:
WHERE (sec.termid = 2700 OR
sec.termid = 2701)
The modified script values reflect in Aeries SQL, Aeries Access and the PowerSchool Reporting Engines, confirming that the yearly updates have been processed.