Sleuth Importer Installation Notes
Once we have created your school’s Sleuth database, it can be populated with your staff and students using the Sleuth Importer. The Sleuth Importer takes data from your Management Information System (MIS) system and loads it into Sleuth. It does an initial load on installation and then updates Sleuth automatically from then on (by default, daily at 0100).
The Sleuth Importer uses Groupcall Xporter, a third-party product, included in the price of the sleuth importer. If your school already uses the Groupcall Xporter then the process described below will update your current installation instead of installing a new one and you may not see all of the configuration steps listed below if they have already been filled in previously.
Below is a diagram showing the flow of data to Sleuth
To install the Sleuth Importer please follow the instructions below.
Preparing to Install the Sleuth Importer
Please check with your MIS support service that any relevant setup or forms have been completed for your MIS system to allow access by Groupcall’s Xporter product. We attempt to inform you of all steps necessary but the process can be subject to change.
We recommend that you install the Sleuth Importer on your MIS server but if this is not possible then it must be installed on a machine with the correct access to your MIS and is switched on at the time you have configured the import to happen. The type of access varies with each MIS system, for example SIMS requires the SIMS client tools installed but for other MIS systems where a direct connection to the database is used you will just need a tcp connection to the relevant port on the MIS server. The machine you choose to install it on will also require internet access via port 80 and 443 to sleuth.schoolsoftwarecompany.com, schoolsoftwarecompany.com and groupcall.com domains. This can be via a proxy server if you know the proxy server address, port and any usernames or passwords that are required.
Capita - Sims.Net
If you are installing the Sleuth Importer for the first time and you use SIMS as your MIS you will need a SIMS user created with the following groups assigned to them: Third Party Reporting, Personnel Officer and Administrator Assistant. We recommend that you create a new user called sleuth to keep it separate from members of staff.
Serco - Facility CMIS
You will need to specify the location of you CMIS .CDB file when you install Groupcall Xporter so please make sure you know where it is and we recommend you use the CMIS Sql Server user called STUD_ADMIN with the correct password. Note: It is possible to use a different Sql Server user but you will need to contact us for further setup information if you would like to do this.
RM Integris - G2/S2
You will need to fill in the G2 authorisation form, please fill in the supplier as Groupcall and the product as Xporter. Then in your G2 system create a new user with a username and password that is configured to allow access via webservices. Instructions here
Pearson Phoenix - E1
You DO NOT need to install the sleuth importer software.
You will need to contact your Pearson Phoenix support service (email@example.com) and ask them to setup a username and password to allow sleuth to access your E1 system. Once we have received your username and password we can setup the import process from our server directly without your school having to install anything. You can monitor the results of the imports in the mymessages section of the home page when you login into Sleuth Online.
Double First - Engage
The Xporter program connects to Engage via a TCP connection to the MS SQL server database directly. This only needs to be a readonly connection so you will need to make sure you have a MS SQL database user setup with the datareader permission for the Engage database.
To connect the Xporter program to Arbor you will need to know the Web service URL and have an API username and password from Arbor.
Installing the Sleuth Importer
If you do encounter a problem, in the first instance check the Sleuth Importer Notes page.
Maintaining the Sleuth Importer
It is imperative that responsibility for the Sleuth Importer’s successful operation is recognised in school. A frequent check should be added to the school’s standard IT/Network procedures in order that any changes to server software (e.g. the MIS) or hardware (e.g. the MIS server) do not result in the Sleuth Importer failing to run for any length of time. To assist with this check, every Sleuth Admin User receives notification every time they login about the most recent run of the Sleuth Importer (and also the last successful run) in MyMessages on their Sleuth Home page. Any failure to run daily or any error messages should be reported to the IT team to be investigated.
The online help in Sleuth or the Sleuth Importer Notes describe how to resolve any issues arising with the Sleuth Importer.