GetTimetable/EduMate - Revision history

Kia at 09:41, 14 April 2020

2020-04-14T09:41:09Z

← Older revision		Revision as of 09:41, 14 April 2020
Line 10:		Line 10:
	Name of the setting.		Name of the setting.

	~~=== Connection ===~~

	~~====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]]===		===[[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==~~

Kia at 10:44, 16 February 2019

2019-02-16T10:44:50Z

← Older revision		Revision as of 10:44, 16 February 2019
Line 9:		Line 9:
	===Description===		===Description===
	Name of the setting.		Name of the setting.

			=== Connection ===

	====SQL Server====		====SQL Server====

Kia: /* Export settings */

2019-02-16T09:47:53Z

Export settings

← Older revision		Revision as of 09:47, 16 February 2019
Line 22:		Line 22:
	====Password====		====Password====
	SQL Password to access database.		SQL Password to access database.
	===[[~~GetStudents~~/~~Export Settings~~\|Export settings]]===		===[[GetTimetable/Export_settings\|Export settings]]===

	===Add year to groupname===		===Add year to groupname===

Kia: /* SQL Server */

2019-02-16T09:43:10Z

SQL Server

← Older revision		Revision as of 09:43, 16 February 2019
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 ~~name~~====		The port number of the SQL server.
	~~Synergetic~~ database name.		====Database====
			EduMate database name.

	====Username====		====Username====
Line 21:		Line 22:
	====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.~~
	===[[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 "'''~~_FileYear~~'''" to the end of the 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.		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 "'''~~_ActualSemester~~'''" to the end of the groupname. This comes after '''~~FileYear~~''' if it is selected.		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==

Kia at 09:40, 16 February 2019

2019-02-16T09:40:55Z

@@ Line 28: / Line 28: @@
 ===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.
@@ Line 38: / Line 38: @@
 ==FAQ==

Kia at 09:38, 16 February 2019

2019-02-16T09:38:49Z

← Older revision		Revision as of 09:38, 16 February 2019
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 EduMate.jpg\|none\|thumb\|783x783px]]		[[File:GetTimeTable EduMate.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.

			====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.
			===[[GetStudents/Export Settings\|Export settings]]===

			===Add year to groupname===
			When UMS extracts classes from Synergetic 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==
			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''''

Kia: Created page with "783x783px"

2019-02-16T09:36:38Z

Created page with "none|thumb|783x783px"

New page

[[File:GetTimeTable EduMate.jpg|none|thumb|783x783px]]