GetTimetable/EduMate: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
← Older editNewer 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
Line 28: Line 28:


===Add year to groupname===
===Add year to groupname===
When UMS extracts classes from Synergetic it will add "'''_FileYear'''" to the end of the groupname.
When UMS extracts classes from EduMate it will add "'''_FileYear'''" 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.
Line 38: Line 38:


==FAQ==
==FAQ==
UMS uses this for SQL extraction
select *
From vStudentTimetableFullAll
JOIN FileSemesters ON (FileSemesters.FileYear = vStudentTimetableFullAll.FileYear) And (FileSemesters.FileSemester = vStudentTimetableFullAll.FileSemester)
LEFT JOIN pvCommunity ON vStudentTimetableFullAll.StaffID = pvCommunity.ID
Where
StudentID = 15731
And ClassCode = '08Sci3'
order by ClassCode
===The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.ImportFromDB_SkemaBrikker===
This could be the result of someone scheduling the same class with '''PeriodNumberSeq = 1''' and '''PeriodNumberSeq <> 1'''
It will give an error that ends with something like this.
The duplicate key value is ('''04-02-19_08:40_09:43_PKMQ_2019_1''', 1)
This can help find the problematic timetable block. Decipher it like this
#Date = 04-02-19
#Start time = 08:40
#End time = 09:43
#Classcode = PKMQ
#FileYear = 2019
#ActualSemester = 1
The date is calculated based on 2 weeks schedule. This means the date is not too useful.
You can look in UMS using this SQL to find the '''Day number'''
Select *<br>From ImportFromDB_TimeTable_Synergetic<br>Where<br>Skemabegivenhed_ID = '<nowiki/>'''04-02-19_08:40_09:43_PKMQ_2019_1''''

Revision as of 09:40, 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.

Database name

Synergetic 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 "_FileYear" 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 "_ActualSemester" to the end of the groupname. This comes after FileYear if it is selected.

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

FAQ

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