GetTimetable/EduMate: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 12: | Line 12: | ||
====SQL Server==== | ====SQL Server==== | ||
DNS or IP address of the Microsoft SQL server where the Synergetic database is stored. | DNS or IP address of the Microsoft SQL server where the Synergetic database is stored. | ||
====Port number==== | |||
====Database | The port number of the SQL server. | ||
====Database==== | |||
EduMate database name. | |||
====Username==== | ====Username==== | ||
| Line 21: | Line 22: | ||
====Password==== | ====Password==== | ||
SQL Password to access database. | SQL Password to access database. | ||
===[[GetStudents/Export Settings|Export settings]]=== | ===[[GetStudents/Export Settings|Export settings]]=== | ||
===Add year to groupname=== | ===Add year to groupname=== | ||
When UMS extracts classes from EduMate it will add "''' | 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. | This must match the one under the data source for templates. | ||
===Add semester to groupname=== | ===Add semester to groupname=== | ||
When UMS extracts classes from Synergetic it will add "''' | 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. | This must match the one under the data source for templates. | ||
==FAQ== | ==FAQ== | ||
Revision as of 09:43, 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.