GetTimetable/SEQTA: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
No edit summary
Kia (talk | contribs)
Line 1: Line 1:
==Prerequisites==
The semester start date has to be week 1 (day number 1 to 5) in the timetable. Extraction will not work correctly if this is not the case.
==Setup==
==Setup==
[[File:GetTimeTable SEQTA.jpg|none|thumb|783x783px]]
[[File:GetTimeTable SEQTA.jpg|none|thumb|783x783px]]
Line 22: Line 19:
====Password====
====Password====
SQL Password to access database.
SQL Password to access database.
===Increase identifier===
This is only used in UMS when there is 2 or more administrative systems of the same type extracted into the same UMS database/installation.
This must match the one under the data source for templates.
===[[GetTimetable/Export_settings|Export settings]]===
===[[GetTimetable/Export_settings|Export settings]]===



Revision as of 10:27, 16 February 2019

Setup

Format and content

Description

Name of the setting.

SQL Server

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.

Increase identifier

This is only used in UMS when there is 2 or more administrative systems of the same type extracted into the same UMS database/installation.

This must match the one under the data source for templates.

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