Using CamSIS Connect

On the command line, navigate to the directory where Connect 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

A debug switch can be set when running in 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 parameters file, e.g.

jdbc:mysql://localhost:3306/csconnect?useSSL=false