There are 2 main aspects to updating Spider. The first is the copying of files to the web application’s folder structure. The second is to execute a series of SQL Scripts against the database Spider is using. Both of these processes is automatically done by the installer. The current Spider must be downloaded using the PCSchool_Downloader application. We strongly recommend this is done at least once a month to ensure your software is current.
Once the new Spider file is downloaded, extract the file and run the executable file contained. The initial “Important Information” advises users of any requirements that are necessary.
By default, the installer will assume that the SQL Server is on the same computer as Spider. In most cases the installer will be able to run the scripts even if the SQL Server is on another server. If this is not the case, remove the tick from “Run SQL Scripts.” During the update process, a copy of the previous files are copied to a “Spider Backup” folder on the root of the IIS server.
- Before you can proceed, ALWAYS read the "Important Information" before selecting the acknowledgement. One read and accepted, check the box to proceed.
CHOOSE YOUR OPTIONS
- Always choose this as a starting point. Files MUST be installed before the scripts are run. In almost all cases, the scripts can be run from the same location. in some rare instances due to server configurations these need to be split however this is uncommon and the affected school generally know who they are.
- This is checked in most all cases unless your IIS server on on a different server to the SQL server and the necessary ports are not open. This is rare.
- Only take this option if you have an alternate method of recovering the current Spider files.
- This option is available to schools to allow multiple Spiders to be updated without re-running the installer each time. After the first install it will prompt you to choose the next Spider or exit the installer.
- This option is used is the SQL scripts do not run without explicitly calling the default port. Take this option only if required.
The very first time installer is run, it locates the root of the “Default Website.” From here, you need to browse to the “Spider” folder (the name of this folder will vary from school to school). In some instances, Spider may be installed elsewhere. In some cases, this path may have been hidden so a mapped drive will need to be created in order for the installer to locate it. The mapped drive will need to be set one level behind the Spider folder in order for “Backup” folder to be created. A check is done to see if the installer files are newer than the current Spider. If your Spider version is newer, it will not allow the install to continue. If the installer is same version or newer, you can continue with the update. The first part of the update process backs up the current “Spider” into a folder called “Spider Backup” at the same level as your Spider is installed. The archive file is called Spider[version] Date_Time and can be used for recovery purposes. Once this is successfully completed, you may be prompted to “Overwrite” files. Answer “Yes to All” to this prompt.
When this process completes, all of the application files have been updated. Templates are not overwritten although they may be updated at times. If this is the case, the original is renamed to allow content to be copied to the new version. A copy of the original web.config is made (web.bak) in the root folder. If you unselected “Run SQL Scripts”, the installer will end here. In order for Spider to operate, however, it is critical that the matching SQL scripts run. IMPORTANT: If SQL Server is on another computer, copy both the installer and the newly created web.config file to it. The installer needs the new web.config to extract the current version as well as match the correct database to the newly updated Spider. When running the installer on the SQL Server, unselect “Copy Files” as this has already been done.
For most installs, the scripts will be run using the default web browser once the files are copied. It is important to keep the browser open until this completes.
IMPORTANT: You MUST contact PCSchool if you encounter any errors during the script running process. You will see the Spider's login page after a successful install.
If you see the above screen, the install has been successful. Press the green button to return to the Login Page.The Spider version shows on the bottom right of the login screen. or by right-clicking on the banner bar once logged in.
STEP 3 – Login to test
Once logged in, check the following 3 controls; Student Information (ensure students information displays correctly), Absence Entry (check a roll can be generated) and Result Entry (Check to see if the screen loads without error). You may not be using all of these controls and some may have been renamed. If this is the case, just test the ones the staff regularly use. If there are any issues, please contact PCSchool immediately.