ContactGroup Data Extractor for Call Parents, LookedAfterCall, Reggie

ContactGroup Data Exporter is used for exporting Schools MIS data to be used with the ContactGroup cloud platform, an alternative to Wonde or Groupcall Xporter.

Currently Data Exporter is used for the following services;

  • CallParents
  • LookedAfterCall
  • Reggie

Important – The school requesting the install needs to confirm a SIMS user is created as per below instructions and supply the authorisation code from Contact Group

Setting up the Data Exporter User (the school need to set up a user in SIMS as follows – no need for them to supply the password)

  1. Login to SIMS .net and access System Manager
  2. Check for the user “ContactGroup”, if the user exists check the permissions as below
  3. If the ContactGroup user doesn’t exist, create the user and give it the following permissions depending on the application they require –
    SIMS permissions required for CallParents

    • Administration Assistant
    • TPSuperUser
    • Admission Officer
    • Attendance Operator (for schools to contact certain groups such as Pre Admissions)

    SIMS permissions required for Reggie

    • Administration Assistant
    • TPSuperUser

    SIMS permissions required for LookedAfterCall

    • Administration Assistant
    • TPSuperUser

Server and Network Team to do the following –

  1. Logon to SIMS using the new ContactGroup user and temporary password.  Change the temporary password with the schools Specific password generated from (use the Groupcall Xporter password generator)

Adding a school to Data Extractor

  1. Remote Desktop to SIMSCPxporter.simsnet.local
  2. Launch DEConfig.exe from the Desktop Shortcut (or from the C:\Program Files (x86)\Contact Group\Data Extractor folder)
  3. In the Multi School Database Setup group, click the +
  4. Accept the message to Save the current details
  5. Enter the Authorization Code, SIMS .net credentials and select Option 2, then enter the SQL Server and Database details.
  6. Depending on the application, an Internet browser may launch and a form is required to be completed along with a data sharing agreement – Name, Position, Authorisation Code – and to accept t&c’s. If this is the case, email the school the link to the pdf agreement and ask them to confirm acceptance of this by way of reply. Then complete the form on their behalf – this will then complete the setup.
  7. Click OK.
  8. The Data Exporter services will restart

Check the “C:\Program Files (x86)\Contact Group\Data Extractor\logs” for any errors

After a few minutes, you can see the new school details in the log and the details of the application connecting to the SIMS database. The school ID is the first few digits of the authorisation code.

Example log entry –

2015-05-20 12:24:00.6810 INFO LookedAfterChildren Schedule Constructor
2015-05-20 12:24:00.6810 INFO ************************************************************************************
2015-05-20 12:24:00.6810 INFO Read Looked After Children data from CapitaSims for school:12345 (school ID)
2015-05-20 12:24:00.6810 INFO ************************************************************************************
2015-05-20 12:24:00.7122 DEBUG Purge any data from the databaseClearDataTables
2015-05-20 12:24:00.9150 INFO Sending monitor heartbeat for:4526
2015-05-20 12:24:00.9150 DEBUG Send Web Api Web Request
2015-05-20 12:24:00.9306 INFO Proxy address:
2015-05-20 12:24:00.9306 INFO Proxy Un:
2015-05-20 12:24:00.9306 INFO Proxy Pwd: *********
2015-05-20 12:24:03.7542 INFO Get SIMS server details
2015-05-20 12:24:03.8166 INFO Sims Server:simsdb11\SIMS2008 SIMS Database:ShortSchoolName Path to Sims .Net:
2015-05-20 12:24:03.8166 INFO CapitaSims constructor
2015-05-20 12:24:03.8322 DEBUG Open Process
2015-05-20 12:24:03.8322 DEBUG dataextractorsims.exe
2015-05-20 12:24:03.8322 DEBUG
2015-05-20 12:24:03.8322 DEBUG C:\Program Files (x86)\Contact Group\Data Extractor\dataextractorsims.exe
2015-05-20 12:24:04.4250 INFO Sims.Net extraction application startup
2015-05-20 12:24:04.4406 INFO DataExtractorSims, Version:
2015-05-20 12:24:04.4406 INFO Sims Params:2,simsdb11\SIMS2008,ShortSchoolName,12345,ContactGroup,*****,1,0,0
2015-05-20 12:24:04.4562 INFO ***********Attempt to login to Capita Sims******************************************
2015-05-20 12:24:04.4562 DEBUG Login to Sims method. Server:simsdb11\SIMS2008 Database:ShortSchoolName
2015-05-20 12:24:08.1378 DEBUG Logged into Sims OK:212
2015-05-20 12:24:08.1378 INFO ***********Finished Login to Capita Sims********************************************
2015-05-20 12:24:08.1378 INFO ***********Obtain Lookups from Capita Sims******************************************
2015-05-20 12:24:08.1846 INFO Get Title lookups from Capita Sims
2015-05-20 12:24:09.0270 DEBUG Read Title lookups and add to database
2015-05-20 12:24:09.0738 INFO Number of Title Lookups found: 18
2015-05-20 12:24:09.0738 INFO Get Contact Relationship To Pupil lookups from Capita Sims
2015-05-20 12:24:09.1986 DEBUG Read Contact Relationship To Pupil lookups and add to database5-20 12:24:47.0131 INFO ***********Finished Login to Capita Sims********************************************

Posted in 3rd Party Applications and tagged , , , , , , , .