Sloopy: Yearly Update
Each year, during the summer break, Sloopy Installers should stop the automated task that runs the Sloopy imports and delete any files from the Sloopy data folder. These steps will help prevent the import of old schedules when the new school year starts.
You also must take a few minutes to update your Sloopy setup. This update may be completed at any time after the end of the school year, but must be completed before the start of the next school year. Without a proper update, there will be no teachers, students, or courses in the School Loop system.
Note: It is critical that you update Sloopy and your scripts to make sure we receive data for the new school year. Failure to update could result in an import with last year's data.
If you’ve been running on the same Sloopy setup for more than a year, we recommend that you contact School Loop to ask for the most updated version of Sloopy.
Update directions are listed below by SIS type. If you do not see your SIS listed, you are most likely using our Tab Delimited version of Sloopy. Please contact School Loop support should you have any questions. Log into your account and click the red Help Link in the upper right corner to access our support ticket system.
Updates By SIS
All Student Information Systems
The primary concern in updating Sloopy for a new school year is to ensure that the database for the current school year is the source of the data imports. If you are uncertain about how to update Sloopy for your SIS, please contact School Loop for support.
If you have not yet updated to the newest Sloopy scripts for Aeries Access and SQL (April 2010), please contact School Loop at least two weeks before the start of the new school year. These new scripts are easier to implement, modify, and maintain. Additionally, they support data exports for attendance and our Call Alert feature.
For those that have updated to the new scripts, change the value for /SchoolYear: in the Sloopy.bat file. This parameter is part of the lines that trigger the VB script. There will be one line for each school, so be sure to change the value for all schools.
If you choose to remain on the old Aeries setup for Sloopy, see the directions at the bottom of this page.
Be sure to set the Active School Year in Infinite Campus to the new year at least two days before we roll the schools in your district. Data is extracted from Infinite Campus based on the Active School Year. Failure to update the school year in Infinite Campus could cause last year's data to be imported into School Loop.
Instructions from Infinite Campus: Log in to Infinite Campus and go to System Administration. In the Calendars folder click School Year. Select the new year you want to make active, check the Active box, then click Save. Contact Infinite Campus for more details on changing the active year.
PowerSchool VB Script
If you have not yet updated to the newest Sloopy scripts for PowerSchool (Summer 2012), please contact School Loop at least two weeks before the start of the new school year. These new scripts are easier to implement, modify, and maintain.
Edit the Sloopy.bat file located in the Sloopy\PowerSchool folder. Change the values for "starting TermID=", "ending TermID=" and "YearID="to the correct values for the current year. For example, if last year's values were 2200, 2202, and 22 then the correct values for the 2013-2014 school year would be: Starting TermID=2300 and ending TermID=2302 and set YearID=23 (Typically 2302 is the ending term for semesters and 2303 is the ending term for trimesters.)
PowerSchool Reporting Engine
In the SchoolloopStudentSectionsExportSQL.rpt, change the termid values for the current year. For the 2013-2014 school year the line should be: WHERE (cc.termid = 2300 OR cc.termid = 2301).
In the SchoolloopSectionsExportSQL.rpt, change the termid values for the current year. For the 2013-2014 school year the line should be: WHERE (sec.termid = 2300 OR sec.termid = 2301)
Edit the Sloopy.bat file located in the Sloopy\SchoolMax folder. Change the year in the following line: set curSchoolYear=2013.
Change data.school_year value in the config file for each school.
All Other SISs
Modify the script you created as necessary to ensure that you will export data from the database for the current school year.
Old Aeries Sloopy - prior to April 2010
If you choose to remain on the old Aeries setup for Sloopy, here are your update instructions:
In the aeries_config.txt file for each school, change the value in database.url= to the new school year's database name.
If running as a Windows scheduled task, the properties line needs to read
(change XX to the current school year and drop the ..., of course). If running "live," the script asks for a school year. Be sure to use the correct value.