ContactGroup Data Extractor

ContactGroup Data Exporter is used for exporting Schools MIS data to be used with the ContactGroup cloud platform.

Currently Data Exporter is used for the following services;

  • CallParents
  • LookedAfterCall
  • Reggie

 

Setting up the Data Exporter User

  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
    CallParents

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

    Reggie

    • Administration Assistant
    • TPSuperUser

    LookedAfterCall

    • Administration Assistant
    • TPSuperUser.
  4. Logon to SIMS using the new ContactGroup user and temporary password.  Change the temporary password with the schools Specific password generated from upgrades.scomis.org/passwords (use the Groupcall Xporter password generator)

(Old permissions)

  • Class Teacher
  • School Administrator
  • Thirdparty Reporting
  • Thirdparty Super User

 

 

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. An Internet browser will now launch and you will need to fill in the fields of a contact at the school – Name, Position, Authorisation Code – and accept t&c’s. Once submitted, you will then be asked to click OK again on the DE Config application.
  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:http://proxy.swgfl.org.uk:8080/
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: 1.0.2.9d
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 .