GetTimetable/SEQTA: Difference between revisions
Jump to navigation
Jump to search
Created page with "none|thumb|783x783px" |
No edit summary |
||
| 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== | |||
[[File:GetTimeTable SEQTA.jpg|none|thumb|783x783px]] | [[File:GetTimeTable SEQTA.jpg|none|thumb|783x783px]] | ||
===[[GetTimetable/Format and content|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. | |||
===[[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== | |||
Revision as of 10:26, 16 February 2019
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
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.
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.