GetTimetable/Scyllabus - Revision history

Kia at 09:49, 14 February 2020

2020-02-14T09:49:57Z

← Older revision		Revision as of 09:49, 14 February 2020
Line 47:		Line 47:
	===Description===		===Description===
	Name of the setting.		Name of the setting.

			===[[GetTimetable/Absence_settings\|Absence settings]]===

	===[[GetTimetable/Export_settings\|Export settings]]===		===[[GetTimetable/Export_settings\|Export settings]]===

	==FAQ==		==FAQ==

Kia at 09:44, 14 February 2020

2020-02-14T09:44:37Z

← Older revision		Revision as of 09:44, 14 February 2020
Line 41:		Line 41:

	==Setup==		==Setup==
	[[File:~~GetTimeTable~~ Scyllabus.jpg\|none\|thumb\|~~783x783px~~]]		[[File:GetTimetable Scyllabus.jpg\|none\|thumb\|689x689px]]

	===[[GetTimetable/Format and content\|Format and content]]===		===[[GetTimetable/Format and content\|Format and content]]===
Line 47:		Line 47:
	===Description===		===Description===
	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.~~
	~~====Database====~~
	~~Scyllabus database name.~~

	~~====Username====~~
	~~SQL Username to access database.~~

	~~====Password====~~
	~~SQL Password to access database.~~
	===[[GetTimetable/Export_settings\|Export settings]]===		===[[GetTimetable/Export_settings\|Export settings]]===

	==FAQ==		==FAQ==

Kia: /* Setup */

2019-02-16T10:57:16Z

Setup

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

			=== Connection ===

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

Kia at 10:38, 16 February 2019

2019-02-16T10:38:57Z

← Older revision		Revision as of 10:38, 16 February 2019
Line 1:		Line 1:
	== Prerequisites ==		==Prerequisites==
	There must be views created in Scyllabus for UMS to extract data.		There must be views created in Scyllabus for UMS to extract data.

	These views are:		These views are:

	* rdowner.UMS_ACTTIMETABLE		*rdowner.UMS_ACTTIMETABLE
	** InternalID		**InternalID
	** parentinternalid		**parentinternalid
	** activityhostkey		**activityhostkey
	** scheduledstart		**scheduledstart
	** scheduledend		**scheduledend
	* rdowner.UMS_ACTSTAFF		*rdowner.UMS_ACTSTAFF
	** InternalID		**InternalID
	** parentinternalid		**parentinternalid
	** activityhostkey		**activityhostkey
	** staffhostkey		**staffhostkey
	** staffname		**staffname
	* rdowner.UMS_ACTLOCATION		*rdowner.UMS_ACTLOCATION
	** InternalID		**InternalID
	** parentinternalid		**parentinternalid
	** activityhostkey		**activityhostkey
	** locationhostkey		**locationhostkey
	** locationdescription		**locationdescription
	** locationname		**locationname
	* rdowner.UMS_ACTSTUDENTSET		*rdowner.UMS_ACTSTUDENTSET
	** InternalID		**InternalID
	** parentinternalid		**parentinternalid
	** activityhostkey		**activityhostkey
	** studentsethostkey		**studentsethostkey
	** studentsetname		**studentsetname
	** studentsetdescription		**studentsetdescription
	* rdowner.UMS_ACTMODULE		*rdowner.UMS_ACTMODULE
	** InternalID		**InternalID
	** parentinternalid		**parentinternalid
	** activityhostkey		**activityhostkey
	** modulehostkey		**modulehostkey
	** modulename		**modulename
	** moduledescription		**moduledescription

			The students will be attached to timetable blocks based on information extracted from the GetStudents job. This is done by looking at the activityhostkey from Scyllabus and the activity in the Students table. The students will be attached if they match.

	==Setup==		==Setup==

Kia: /* Export settings */

2019-02-16T10:36:38Z

Export settings

@@ Line 1: / Line 1: @@
 ==Setup==
 [[File:GetTimeTable Scyllabus.jpg|none|thumb|783x783px]]
@@ Line 18: / Line 57: @@
 SQL Password to access database.
 ===[[GetTimetable/Export_settings|Export settings]]===
 ==FAQ==

Kia at 10:30, 16 February 2019

2019-02-16T10:30:00Z

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

	====Username====		====Username====

Kia at 10:29, 16 February 2019

2019-02-16T10:29:21Z

← Older revision		Revision as of 10:29, 16 February 2019
Line 1:		Line 1:
			==Setup==
	[[File:GetTimeTable Scyllabus.jpg\|none\|thumb\|783x783px]]		[[File:GetTimeTable Scyllabus.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==

Kia: Created page with "783x783px"

2019-02-16T09:35:33Z

Created page with "none|thumb|783x783px"

New page

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