skip to content
 

CamSIS Connect

What is CamSIS Connect?

CamSIS Connect is a software utility which is provided free of charge to Colleges and Departments. The utility is designed to maintain a copy of the CamSIS Outbound Interface (OBI) data in a local database within the College or Department.

The first time that CamSIS Connect runs, it will copy all information for the particular College and Department into the local database. Subsequently, the utility will download only the incremental changes.

Supporting Operating Systems

CamSIS Connect is written in Java, and is able to run on any Windows, Linux, Apple or Solaris operating system that supports Java.

For more details see http://java.com/en/download/manual.jsp or http://java.sun.com/javase/downloads/index.jsp

Supported databases

At present, CamSIS Connect has been developed and tested on SQL Server 2014, SQL Server Express 2014, Oracle9i, Oracle 12c, Oracle 11g and MySQL 5.7 databases.

However, the Connect utility has been written using the Hibernate persistence framework (http://www.hibernate.org) and therefore there is the potential to support the other database platforms detailed at http://www.hibernate.org/80.html.

If you have a requirement to use a database which is supported by Hibernate, but for which CamSIS Connect has yet to be tested please contact the CamSIS Helpdesk (camsishelp@admin.cam.ac.uk) with your request.

Requesting installation

The CamSIS project offers two methods of installation. If required, a member of the CamSIS project team can visit your College or Department to install CamSIS Connect.

Alternatively, the College or Department can opt to install the utility themselves by downloading the program from our servers and following the associated documentation.

Whichever option is chosen, you will need to follow the Pre-Installation instructions detailed below.

Pre-installation instructions
Downloading CamSIS Connect

Note: The download page is protected by Raven, and you will need to send a request to the CamSIS Helpdesk (camsishelp@admin.cam.ac.uk) to be added to the list of permitted users before you can access the page.

CamSIS Connect can be downloaded from http://www.admin.cam.ac.uk/offices/misd/services/web/download/

Installation instructions

If you are undertaking the installation of CamSIS Connect, or wish to refer to the installation instructions, they can be obtained from:

Installation instructions PDF

 

Using CamSIS Connect

On the command line, navigate to the directory where CSConnect is installed, then type one of the following commands:

  • csconnect setup ( This will create all the tables )
  • csconnect flush ( This will delete all existing data and reload )
  • csconnect immediate ( This loads changes since the last update )
  • csconnect prompts ( This loads all the prompt tables )
  • csconnect inbound ( This loads DORM addresses into PS_UC_CLG_INBND_RM ready for the Inbound Interface Program )

Extension Codes:

Immediate mode send emails. To turn this off you will need to modify the csconnect.bat file by adding -Q to the end. e.g. -Mimmediate –Q
Debug switch can be set for any mode to provide better error logging. Modify the csconnect.bat file by adding -D to the end e.g. -Mimmediate –D

Local Tables

CURRENT_STUDENTS – single row for all active students and academic details
CONTACT_DETAILS – single row for student phone and email details

Notes

MySQL users may see a warning message regarding SSL. This can be resolved by adding “?useSSL=false” to the end of your local url connection string within the parameter file.
e.g. jdbc:mysql://localhost:3306/csconnect?useSSL=false

Testing and related releases

CamSIS Connect is still being developed and tested. If you uncover any issues, or have suggestions for improvements, please sent these to the CamSIS Helpdesk: camsishelp@admin.cam.ac.uk.

Release history

Version Release Date Status Enhancements made / Issues resolved
1.18 28 March 2017 Current Added AS_CPP_P for academic structure mapping
1.17 2 January 2017 Previous Support for MYSQL version 5.7, Record UIEX – Field UC_EBLRESULT value altered, New Contact Details table
1.16 15 December 2016 Previous Altered table: PERS
1.15 September 2015 Previous Source of Fee alterations to FIN,STFE and MST_CD_P
1.14 March 2015 Previous Student Financial table changes
1.13 8th December 2014 Previous

Issues resolved: Attribute record altered in OBI

1.12 3rd July 2013 Previous

Record UIEX – fields UC_EBLRESULT and UC_EBLAMENED changed to 10 characters

Record UCDIS_P - field UC_DISTEXT value removed, field SAD_UC_DISTEXT added

Record RESCAT_P - field UC_RESCATTEXT_LONG added

1.11 20th Jan 2012 Previous

Field LINE_AMT on STFE table changed to Decimal

Fields UC_GCSE_SCORE, UC_POINTS_ADJUST, UC_AV_STDNT_SCORE, UC_AV_EXAM_SCORE on DSPR table changed to Decimal

Field OVERALL_RATING on AEVL table changed to Decimal

Field SCORE on STTC table changed to Decimal

Field UC_SCORE_PCT on UISB table changed to Decimal

Field ACCOUNT_BALANCE on table ACSF changed to Decimal

1.10 1st Nov 2011 Previous

Corrected table ACCOM_VW to resolve refresh errors

1.09 14th Jun 2011 Previous

Altered tables: STFE

New Table: ACSF, XREF

Altered Prompts: FEECD_P

New Prompts: ITTYPE_P, KEYWORD_P, SELGRP_P, WAIVER_P

1.08 15th Mar 2011 Previous

Altered tables: ACAD

New Table: CLIS, ICEP

New Prompts: ACMTYP_P, INSTRRL_P, INSTRTY_P

1.06 08th Dec 2010 Previous

Altered tables: UAPP, UICH, UIED, UIEM, UIQU, UIEX, UISB, UICI, UIRF, UIST

Altered prompt table SESN_P

New Current Students table

1.05 20th Sept 2010 Previous

New accommodation table

New student financials table

New inbound rooms feed table

Altered properties file to remove debugging information shown on screen

Altered UIRF table

1.04 16th Aug 2010 Previous

New accommodation table

New student financials table

New inbound rooms feed table

Altered properties file to remove debugging information shown on screen

1.03 16th Mar 2009 Previous

Additional fields UC_MATRIC_STRM, DEGREE, UC_FINACE_REQD, UC_ERLY_OFFER_STAT in ACAD table

Additional fields CITIZEN_COUNTRY, UC_SEC_CITZN_CNTRY, BIRTHPLACE, BITHCOUNTRY in PERS table

Additional table DEGREE_P

1.02 16th Mar 2009 Previous

Additional tables ATTR, ATGRP_P, ATTRIB_P

1.01 5 Nov 2009 Previous

Missing tables added to silent mode

Unique row issues for ENRACT_P and SAQOPT_P resolved

Additional columns added to PLAN_P

1.00 5 Jun 2009 Previous

Environment variable added to configuration file that determines the database from which the Connect utility obtains data

UISB table download issues resolved

New tables added for Institute of Continuing Education (CLMP and CLRS), together with additional columns for tables CLAS and CRCT

0.22   Archive  
How can I work with the CSASOBI environment that was created to enable testing for the new Academic Structure?

If you are a CamSIS Connect user and would like to take the updated PROG_P prompt table, you will need to run version 1.19 of Connect.

If you do not wish to take the updated PROG_P prompt table, then you may continue to use the existing version 1.18 of Connect. However, you will still need to update your parameters file to point to the new CSASOBI environment, by adding the line jdbc:oracle:thin:@ocm.admin.cam.ac.uk:1544/CSASOBI and commenting out the line pointing to CS_PROD. You will also need to ensure that your Local URL points to your test system and not your production system.

Whichever version of Connect you use, we recommend that you run the program in flush mode for the first time. This will give a clean set of converted data, and should avoid any conflicts with audit sequence numbers. 

Version 1.19 of Connect is available from the usual download page: http://www.admin.cam.ac.uk/offices/misd/services/web/download/

Instructions for installing and running Connect against CSASOBI can be found at: http://www.admin.cam.ac.uk/offices/misd/services/web/download/connect-1.19-readme.html .