GetTimetable/Scyllabus: Difference between revisions

Revision as of 10:36, 16 February 2019

There must be views created in Scyllabus for UMS to extract data.

These views are:

Name of the setting.

DNS or IP address of the Microsoft SQL server where the Synergetic database is stored.

@@ Line 1: / Line 1: @@
+== 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
 ==Setup==
 [[File:GetTimeTable Scyllabus.jpg|none|thumb|783x783px]]
@@ Line 18: / Line 57: @@
 SQL Password to access database.
 ===[[GetTimetable/Export_settings|Export settings]]===
-===Add year to groupname===
-When UMS extracts classes from EduMate it will add "'''_ACADEMIC_YEAR'''" to the end of the groupname.
-This must match the one under the data source for templates.
-===Add semester to groupname===
-When UMS extracts classes from Synergetic it will add "'''_Term'''" to the end of the groupname. This comes after '''ACADEMIC_YEAR''' if it is selected.
-This must match the one under the data source for templates.
 ==FAQ==