View source for Custom SQL Commands

Custom SQL Commands are a feature for executing customized SQL at specific moments in various background jobs. This moment depends on the job you attach the SQL command to.

This feature is found here: Configurator -> Settings -> Custom SQL Commands
[[File:Custom SQL commands.jpg|none|thumb|556x556px]]
If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.

==Jobs==
The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents require no license)

==[[GetStudents]]==
Always use the table '''ImportFromDB''' instead of the Students table when doing these SQL commands.
[[File:Custom SQL commands GetStudents.jpg|none|thumb|725x725px]]

====Description====
Enter a name.

====Priority====
This control in which order commands should run.

====SQL command====
Enter the SQL command UMS will run.

You can create a Store Procedure and run that instead use the command "'''Exec''' '''<Stored Procedure Name>'''"

===Add users to groups===
This option allows you to create new groups in UMS. These groups will be handled like any other group coming from the administrative system.
[[File:Custom SQL commands GetStudents Add users to groups.jpg|none|thumb|725x725px]]

====SQL Command====
Only write the part that comes after the SQL Where sentence and not the whole SQL sentence.

====GetStudents====
All fields under this setting are text fields.

[[GetTimetable]]

[[Moodle]]

[[Moodle#Cohort|Moodle Cohort]]

[[Canvas]]

[[G Suite#Drive|Google Apps Drive Sync]]

[[G Suite#Site|Google Apps Sites Sync]]

[[Fronter Integration|Fronter]]

[[ELEARNINGFORCE SharePoint LMS|ELEARNINGFORCE]]

[[Export User Info to Admin systems]]

[[Office 365|Office 365 SharePoint Sync]]

[[OneNote Class Notebook]]

[[SLI]]