GetTimetable/Scyllabus: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 47: | Line 47: | ||
===Description=== | ===Description=== | ||
Name of the setting. | Name of the setting. | ||
=== Connection === | |||
====SQL Server==== | ====SQL Server==== | ||
Revision as of 10:57, 16 February 2019
Prerequisites
There must be views created in Scyllabus for UMS to extract data.
These views are:
- rdowner.UMS_ACTTIMETABLE
- InternalID
- parentinternalid
- activityhostkey
- scheduledstart
- scheduledend
- rdowner.UMS_ACTSTAFF
- InternalID
- parentinternalid
- activityhostkey
- staffhostkey
- staffname
- rdowner.UMS_ACTLOCATION
- InternalID
- parentinternalid
- activityhostkey
- locationhostkey
- locationdescription
- locationname
- rdowner.UMS_ACTSTUDENTSET
- InternalID
- parentinternalid
- activityhostkey
- studentsethostkey
- studentsetname
- studentsetdescription
- rdowner.UMS_ACTMODULE
- InternalID
- parentinternalid
- activityhostkey
- modulehostkey
- modulename
- moduledescription
The students will be attached to timetable blocks based on information extracted from the GetStudents job. This is done by looking at the activityhostkey from Scyllabus and the activity in the Students table. The students will be attached if they match.
Setup
Format and content
Description
Name of the setting.
Connection
SQL Server
DNS or IP address of the Microsoft SQL server where the Synergetic database is stored.
Database
Scyllabus database name.
Username
SQL Username to access database.
Password
SQL Password to access database.