GetTimetable/Scyllabus: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
No edit summary
Kia (talk | contribs)
engineering, inHouse, Administrators
2,475 edits
No edit summary
 
(5 intermediate revisions by the same user not shown)
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
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==
==Setup==
[[File:GetTimeTable Scyllabus.jpg|none|thumb|783x783px]]
[[File:GetTimetable Scyllabus.jpg|none|thumb|689x689px]]


===[[GetTimetable/Format and content|Format and content]]===
===[[GetTimetable/Format and content|Format and content]]===
Line 7: Line 48:
Name of the setting.
Name of the setting.


====SQL Server====
===[[GetTimetable/Absence_settings|Absence settings]]===
DNS or IP address of the Microsoft SQL server where the Synergetic database is stored.
====Port number====
The port number of the SQL server.
====Database====
EduMate database name.


====Username====
SQL Username to access database.
====Password====
SQL Password to access database.
===[[GetTimetable/Export_settings|Export settings]]===
===[[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==
==FAQ==

Latest revision as of 09:49, 14 February 2020

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.

Absence settings

Export settings

FAQ

Retrieved from "http://wiki.inlogic.dk/index.php?title=GetTimetable/Scyllabus&oldid=3387"