Studily: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Cna (talk | contribs)
Khm (talk | contribs)
 
(8 intermediate revisions by 2 users not shown)
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 />


===Requirements===
[[GetTimetable]] - This needs to be executed before export data is available<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 15: 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====
*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time


Overlapping Timetable blocks shown in Studily
====How do I activate the Studily timetable module?====


*Due to above mentioned presentation of Teams timetable blocks, there might be overlapping blocks in case teams are planned at the same time <br />
*Studi.ly timetable block sync requires the '''Studily''' module in your UMS License (please contact salg@inlogic.dk)


How do I activate the Studily timetable module?  
==== 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


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


====== Update all existing timetable blocks from today -> forward ======
UPDATE
    Studily_TimeTableBlocks
SET
    NeedToBeUpdated = 'True'
FROM
    Studily_TimeTableBlocks
    Join SkemaBrikker on SkemaBrikker.SkemaBegivenhed_ID = Studily_TimeTableBlocks.SkemaBegivenhed_ID AND SkemaBrikker.SkemaBrikkerAdminServers_ID = Studily_TimeTableBlocks.SkemaBrikkerAdminServers_ID
WHERE
    convert (date, SkemaBrikker.Dato, 105) > GETDATE()
<br />
<br />

Latest revision as of 12:52, 8 November 2022

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


Requirements

GetTimetable - This needs to be executed before export data is available

UMS Configurator settings


Description

  • Insert a name or description for the setting

Tenant settings

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

Studily FAQ


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.
  • Your personal calendar only contains your own timetable blocks
  • Therefore users may have differences in Calendar view of Studily and their personal calendar.

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

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)

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


Update all existing timetable blocks from today -> forward
UPDATE 
    Studily_TimeTableBlocks
SET 
    NeedToBeUpdated = 'True'
FROM 
    Studily_TimeTableBlocks
    Join SkemaBrikker on SkemaBrikker.SkemaBegivenhed_ID = Studily_TimeTableBlocks.SkemaBegivenhed_ID AND SkemaBrikker.SkemaBrikkerAdminServers_ID = Studily_TimeTableBlocks.SkemaBrikkerAdminServers_ID
WHERE 
    convert (date, SkemaBrikker.Dato, 105) > GETDATE()