Studily - Revision history

Khm: /* Update all existing timetable blocks from today -> forward */

2022-11-08T12:52:56Z

Update all existing timetable blocks from today -> forward

← Older revision		Revision as of 12:52, 8 November 2022
Line 66:		Line 66:
	FROM		FROM
	Studily_TimeTableBlocks		Studily_TimeTableBlocks
	Join SkemaBrikker on SkemaBrikker.SkemaBegivenhed_ID = Studily_TimeTableBlocks.SkemaBegivenhed_ID		Join SkemaBrikker on SkemaBrikker.SkemaBegivenhed_ID = Studily_TimeTableBlocks.SkemaBegivenhed_ID AND SkemaBrikker.SkemaBrikkerAdminServers_ID = Studily_TimeTableBlocks.SkemaBrikkerAdminServers_ID
	WHERE		WHERE
	convert (date, ~~skemabrikker~~.Dato, 105) > GETDATE()		convert (date, SkemaBrikker.Dato, 105) > GETDATE()
	<br />		<br />

Khm: /* Studily FAQ */

2022-11-08T12:50:56Z

Studily FAQ

@@ Line 57: / Line 57: @@
   Where skemabrikker.Dato = '31-08-2022' -- Date
   And SkemaBrikker_Teachers.Initialer = '' -- Teachers initials
 <br />

Khm at 07:51, 26 August 2022

2022-08-26T07:51:43Z

← Older revision		Revision as of 07:51, 26 August 2022
Line 11:		Line 11:
	Description		Description

	* Insert a name or description for the setting		*Insert a name or description for the setting

	Tenant settings		Tenant settings

	* Select the tenant settings available from [[Office365 Tenant]]		*Select the tenant settings available from [[Office365 Tenant]]

	ClientID		ClientID

	* Insert ClientID requested from Inlogic		*Insert ClientID requested from Inlogic

	ClientSecret		ClientSecret

	* Insert ClientSecret requested from Inlogic		*Insert ClientSecret requested from Inlogic

	Environment		Environment

	* Choose the environment your Studily is running on (default production)		*Choose the environment your Studily is running on (default production)

	SQL Sentence		SQL Sentence

	* insert parameters for filtering purposes<br />		*insert parameters for filtering purposes<br />

	==Studily FAQ==		==Studily FAQ==
Line 44:		Line 44:
	====Overlapping Timetable blocks shown in Studily====		====Overlapping Timetable blocks shown in Studily====

	*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time ~~<br />~~		*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time

	====How do I activate the Studily timetable module?====		====How do I activate the Studily timetable module?====

	*Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)		*Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)

			==== See timetable blocks for a specific day on a specific teacher sent to studily ====
			Select * from Studily_TimeTableBlocks
			Join SkemaBrikker on SkemaBrikker.SkemaBegivenhed_ID = Studily_TimeTableBlocks.SkemaBegivenhed_ID and SkemaBrikker.SkemaBrikkerAdminServers_ID = Studily_TimeTableBlocks.SkemaBrikkerAdminServers_ID
			Join SkemaBrikker_Teachers on Studily_TimeTableBlocks.SkemaBegivenhed_ID = SkemaBrikker_Teachers.SkemaBegivenhed_ID AND SkemaBrikker_Teachers.SkemaBrikkerAdminServers_ID = Studily_TimeTableBlocks.SkemaBrikkerAdminServers_ID
			Left Join SkemaBrikker_Rooms on Studily_TimeTableBlocks.SkemaBegivenhed_ID = SkemaBrikker_Rooms.SkemaBegivenhed_ID AND SkemaBrikker_Rooms.SkemaBrikkerAdminServers_ID = Studily_TimeTableBlocks.SkemaBrikkerAdminServers_ID
			Where skemabrikker.Dato = '31-08-2022' -- Date
			And SkemaBrikker_Teachers.Initialer = '' -- Teachers initials




	<br />		<br />

Cna: /* UMS Configurator settings */

2022-08-24T09:17:43Z

UMS Configurator settings

← Older revision		Revision as of 09:17, 24 August 2022
Line 4:		Line 4:

	===Requirements===		===Requirements===
	[[GetTimetable]] - This needs to be executed before export data is available		[[GetTimetable]] - This needs to be executed before export data is available<br />
	<br />
	===UMS Configurator settings===		===UMS Configurator settings===
	?<br />		[[File:Studily settings.png\|none\|thumb\|664x664px]]


			Description

			* Insert a name or description for the setting

			Tenant settings

			* Select the tenant settings available from [[Office365 Tenant]]

			ClientID

			* Insert ClientID requested from Inlogic

			ClientSecret

			* Insert ClientSecret requested from Inlogic

			Environment

			* Choose the environment your Studily is running on (default production)

			SQL Sentence

			* insert parameters for filtering purposes<br />

	==Studily FAQ==		==Studily FAQ==
	<br />		<br />

	==== Why does Studily calender view contain more timetable blocks than personal calendar? ====		====Why does Studily calender view contain more timetable blocks than personal calendar?====

	*Studily will per default show all timetable blocks for the ALL Teams you are a member or owner of.		*Studily will per default show all timetable blocks for the ALL Teams you are a member or owner of.
Line 18:		Line 42:
	*Therefore users may have differences in Calendar view of Studily and their personal calendar.		*Therefore users may have differences in Calendar view of Studily and their personal calendar.

	==== Overlapping Timetable blocks shown in Studily ====		====Overlapping Timetable blocks shown in Studily====

	*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />		*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />

	==== How do I activate the Studily timetable module? ====		====How do I activate the Studily timetable module?====

	*Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)		*Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)

	<br />		<br />

Cna: /* Studily FAQ */

2022-08-24T09:00:08Z

Studily FAQ

← Older revision		Revision as of 09:00, 24 August 2022
Line 12:		Line 12:
	<br />		<br />

	Why does Studily calender view contain more timetable blocks than personal calendar?		==== Why does Studily calender view contain more timetable blocks than personal calendar? ====

	*Studily will per default show all timetable blocks for the ALL Teams you are a member or owner of.		*Studily will per default show all timetable blocks for the ALL Teams you are a member or owner of.
Line 18:		Line 18:
	*Therefore users may have differences in Calendar view of Studily and their personal calendar.		*Therefore users may have differences in Calendar view of Studily and their personal calendar.

			==== Overlapping Timetable blocks shown in Studily ====
	Overlapping Timetable blocks shown in Studily

	*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />		*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />

			==== How do I activate the Studily timetable module? ====
	How do I activate the Studily timetable module?

	*Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)		*Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)

	<br />		<br />

Cna: /* The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams. */

2022-08-24T08:59:18Z

The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams.

← Older revision		Revision as of 08:59, 24 August 2022
Line 1:		Line 1:
	~~===~~The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams.~~===~~		'''<big>The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams.</big>'''

	<br />		<br />

Cna: /* The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams. */

2022-08-24T08:58:43Z

The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams.

← Older revision		Revision as of 08:58, 24 August 2022
Line 1:		Line 1:
	=== The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams. ===		===The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams.===
	<br />		<br />

	==== Requirements ====		===Requirements===
	[[GetTimetable]] - This needs to be executed before export data is available		[[GetTimetable]] - This needs to be executed before export data is available
	<br />		<br />

Cna: /* UMS Configurator settings */

2022-08-24T08:58:02Z

UMS Configurator settings

← Older revision		Revision as of 08:58, 24 August 2022
Line 1:		Line 1:
	The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams.		=== The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams. ===
			<br />

			==== Requirements ====
			[[GetTimetable]] - This needs to be executed before export data is available
	<br />		<br />

	===UMS Configurator settings===		===UMS Configurator settings===
	?<br />		?<br />

Cna: /* Studily FAQ */

2022-08-24T08:54:29Z

Studily FAQ

← Older revision		Revision as of 08:54, 24 August 2022
Line 19:		Line 19:

	*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />		*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />


	How do I activate the Studily timetable module?		How do I activate the Studily timetable module?

Cna: /* Studily FAQ */

2022-08-24T08:53:16Z

Studily FAQ

← Older revision		Revision as of 08:53, 24 August 2022
Line 11:		Line 11:
	Why does Studily calender view contain more timetable blocks than personal calendar?		Why does Studily calender view contain more timetable blocks than personal calendar?

	* Studily will per default show all timetable blocks for the ALL Teams you are a member or owner of.		*Studily will per default show all timetable blocks for the ALL Teams you are a member or owner of.
	* Your personal calendar only contains your own timetable blocks		*Your personal calendar only contains your own timetable blocks
	* Therefore users may have differences in Calendar view of Studily and their personal calendar.		*Therefore users may have differences in Calendar view of Studily and their personal calendar.


	Overlapping Timetable blocks shown in Studily		Overlapping Timetable blocks shown in Studily

	* Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />		*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />

	How do I activate the Studily timetable ~~syncronization~~?		How do I activate the Studily timetable module?

	* Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)		*Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)

	<br />		<br />