TimeEdit - Revision history

Cna@inlogic.dk at 09:07, 14 October 2025

2025-10-14T09:07:15Z

← Older revision		Revision as of 09:07, 14 October 2025
Line 5:		Line 5:
	*UMS		*UMS
	*TimeEdit account		*TimeEdit account
			TimeEdit module is relevant for uploading users and groups to TimeEdit system. These entities (users, groups, classes, courses) can then be used to create timetable blocks, which can be collected into UMS by GetSkemabrikker.

			Note that UMS will attempt to delete entities, but if blocked from deletion, UMS will deactivate entity in TimeEdit instead.

			(Reason for block could be active timetableblocks / reservations on the entity)

			The deactivated entities must be deleted manually by customer. If entities are not to be visible in TimeEdit overview, a filter can be made in TimeEdit to exclude them from view.

	==Create TimeEdit settings on templates==		==Create TimeEdit settings on templates==

Kia: /* Create TimeEdit settings on templates */

2022-08-29T07:30:10Z

Create TimeEdit settings on templates

← Older revision		Revision as of 07:30, 29 August 2022
Line 21:		Line 21:
	Upload employee groups from UMS to TimeEdit.		Upload employee groups from UMS to TimeEdit.

	=== Keep classes alive ===		=== Use Activity ID ===
			When this is disabled UMS will use the activity field instead of Activity ID. Make sure the field you choose is unique if you have more than 1 administrative system.

			===Keep classes alive===
	This controls how many days classes are kept in TimeEdit after they have ended.		This controls how many days classes are kept in TimeEdit after they have ended.

Line 32:		Line 35:
	Enable this to add students to the courses being uploaded.		Enable this to add students to the courses being uploaded.

	=== Keep courses alive ===		===Keep courses alive===
	This controls how many days courses are kept in TimeEdit after they have ended.		This controls how many days courses are kept in TimeEdit after they have ended.

Kia: /* Create TimeEdit settings on templates */

2022-07-05T10:53:45Z

Create TimeEdit settings on templates

← Older revision		Revision as of 10:53, 5 July 2022
Line 11:		Line 11:
	Upload of courses fails if no courses are imported on GetStudents. Verify this with SQL		Upload of courses fails if no courses are imported on GetStudents. Verify this with SQL
	{\| class="wikitable"		{\| class="wikitable"
	\|Select Distinct Skolefag From Students		\|Select Distinct Aktivitet, Skolefag From Students
	\|}		\|}
	<br />[[File:TimeEdit Settings.jpg\|none\|thumb\|849x849px]]		<br />[[File:TimeEdit Settings.jpg\|none\|thumb\|849x849px]]
Line 17:		Line 17:
	===Description===		===Description===
	Enter a name for this setting.		Enter a name for this setting.

			===Upload groups===
			Upload employee groups from UMS to TimeEdit.

			=== Keep classes alive ===
			This controls how many days classes are kept in TimeEdit after they have ended.

	===Upload courses===		===Upload courses===
Line 26:		Line 32:
	Enable this to add students to the courses being uploaded.		Enable this to add students to the courses being uploaded.

	===~~Upload groups~~===		=== Keep courses alive ===
	~~Upload employee groups from UMS to~~ TimeEdit.		This controls how many days courses are kept in TimeEdit after they have ended.

	===TimeEdit Server connection===		===TimeEdit Server connection===

Kia: /* Create TimeEdit settings on templates */

2022-03-04T13:40:10Z

Create TimeEdit settings on templates

← Older revision		Revision as of 13:40, 4 March 2022
Line 11:		Line 11:
	Upload of courses fails if no courses are imported on GetStudents. Verify this with SQL		Upload of courses fails if no courses are imported on GetStudents. Verify this with SQL
	{\| class="wikitable"		{\| class="wikitable"
	\|~~select distinct~~ Skolefag ~~from ImportFromDB~~		\|Select Distinct Skolefag From Students
	\|}		\|}
	<br />[[File:TimeEdit Settings.jpg\|none\|thumb\|849x849px]]		<br />[[File:TimeEdit Settings.jpg\|none\|thumb\|849x849px]]

Kia: /* URL (Endpoint) */

2022-03-04T13:39:00Z

URL (Endpoint)

← Older revision		Revision as of 13:39, 4 March 2022
Line 25:		Line 25:
	===Upload course memberships===		===Upload course memberships===
	Enable this to add students to the courses being uploaded.		Enable this to add students to the courses being uploaded.

			===Upload groups===
			Upload employee groups from UMS to TimeEdit.

	===TimeEdit Server connection===		===TimeEdit Server connection===
Line 83:		Line 86:
	(UserTypes_ID = 1)		(UserTypes_ID = 1)
	And (Aktivitet Is Not Null)		And (Aktivitet Is Not Null)
	And (Aktivitet <> '')''		And (Aktivitet <> <nowiki>''</nowiki>'')''
	===Courses===		===Courses===
	This relates to data found in this SQL statement		This relates to data found in this SQL statement
Line 91:		Line 94:
	(UserTypes_ID = 1)		(UserTypes_ID = 1)
	And (Aktivitet Is Not Null)		And (Aktivitet Is Not Null)
	And (Aktivitet <> '')''		And (Aktivitet <> <nowiki>''</nowiki>'')''
	And (Skolefag Is Not Null)		And (Skolefag Is Not Null)
	And (Skolefag <> '')''		And (Skolefag <> <nowiki>''</nowiki>'')''
			===Groups===
			This relates to data found in this SQL statement
			Select *
			From Students
			Where
			(UserTypes_ID = 0)
			And (AktivitetsID Is Not Null)
			And (AktivitetsID <> <nowiki>''</nowiki>'')''
	===Admin Activities===		===Admin Activities===
	This relates to data found in this SQL statement~~<br>~~		This relates to data found in this SQL statement
	Select * From AdminSystems_Activities		Select * From AdminSystems_Activities
	===Admin Courses===		===Admin Courses===
	This relates to data found in this SQL statement~~<br>~~		This relates to data found in this SQL statement
	Select *		Select *
	From AdminSystems_Activities		From AdminSystems_Activities

Kia: /* Create TimeEdit settings on templates */

2022-03-04T13:36:47Z

Create TimeEdit settings on templates

← Older revision		Revision as of 13:36, 4 March 2022
Line 13:		Line 13:
	\|select distinct Skolefag from ImportFromDB		\|select distinct Skolefag from ImportFromDB
	\|}		\|}
	<br />[[File:TimeEdit Settings.jpg\|none\|thumb\|~~728x728px~~]]		<br />[[File:TimeEdit Settings.jpg\|none\|thumb\|849x849px]]

	===Description===		===Description===

Kia: /* Parameters */

2021-06-28T10:31:00Z

Parameters

@@ Line 130: / Line 130: @@
 |Courses
 |Upload courses
 |}
 ==FAQ==

Kia: /* Parameters */

2021-06-28T10:29:52Z

Parameters

Show changes

Kia: /* Configure Modules > Timetable >Datasource */

2021-06-28T10:27:41Z

Configure Modules > Timetable >Datasource

Show changes

Kia: /* Use SQL to control data from UMS */

2021-06-17T09:15:07Z

Use SQL to control data from UMS

← Older revision		Revision as of 09:15, 17 June 2021
Line 43:		Line 43:
	====Password====		====Password====
	Password to access the Webservice URL.		Password to access the Webservice URL.

	~~===Use SQL to control data from UMS===~~
	~~This allows you to enter extra criteria on data extracted from the students table in UMS for each object type sent to TimeEdit~~

	===Employee mail domain===		===Employee mail domain===
Line 63:		Line 60:

	==Use SQL to control data from UMS==		==Use SQL to control data from UMS==
	This ~~gives~~ you ~~access~~ to ~~write SQL statements that control the~~ data extracted from UMS ~~and send~~ to TimeEdit		This allows you to enter extra criteria on data extracted from UMS for each object type sent to TimeEdit

	===Employees===		===Employees===
Line 86:		Line 83:
	(UserTypes_ID = 1)		(UserTypes_ID = 1)
	And (Aktivitet Is Not Null)		And (Aktivitet Is Not Null)
	And (Aktivitet <> '')		And (Aktivitet <> '')''
	===Courses===		===Courses===
	This relates to data found in this SQL statement		This relates to data found in this SQL statement
Line 94:		Line 91:
	(UserTypes_ID = 1)		(UserTypes_ID = 1)
	And (Aktivitet Is Not Null)		And (Aktivitet Is Not Null)
	And (Aktivitet <> '')		And (Aktivitet <> '')''
	And (Skolefag Is Not Null)		And (Skolefag Is Not Null)
	And (Skolefag <> '')		And (Skolefag <> '')''
	===Admin Activities===		===Admin Activities===
	This relates to data found in this SQL statement<br>		This relates to data found in this SQL statement<br>