GetTimetable/Synergetic

Prerequisites

You have to set make an entry in CalendarEvents

https://wiki.synergetic.net.au/display/SYNMAIN/Timetable+Maintenance+-+Calendar+Events+tab

Setup

Description

Name of the setting.

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

1. Date = 04-02-19
2. Start time = 08:40
3. End time = 09:43
4. Classcode = PKMQ
5. FileYear = 2019
6. 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 *
From ImportFromDB_TimeTable_Synergetic
Where
Skemabegivenhed_ID = '04-02-19_08:40_09:43_PKMQ_2019_1'