MitIDErhverv: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Created page with "'''<big>The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams.</big>''' <br /> ===Requirements=== GetTimetable - This needs to be exec..."
 
Cna (talk | contribs)
 
(21 intermediate revisions by one other user not shown)
Line 1: Line 1:
'''<big>The Studi.ly syncronization module exports timetable blocks to the Studi.ly APP in Teams.</big>'''
==UMS Configurator settings==
[[File:MitID Erhverv Settings.jpg|none|frame]]


<br />
===Description===
Insert a name or description for the setting


===Requirements===
===Admin servers===
[[GetTimetable]] - This needs to be executed before export data is available<br />
Choose the admin server created here [[AdminServers/MitIDErhverv|MitID Erhverv]]
===UMS Configurator settings===
[[File:Studily settings.png|none|thumb|664x664px]]


===Maintain groups===
This will created/update and delete groups.


Description
It will also add users and remove them again.


*Insert a name or description for the setting
These groups can be used to add security to users based on group membership.


Tenant settings
=== Authenticators ===
Choose the authenticators to add to users.


*Select the tenant settings available from [[Office365 Tenant]]
'''WARNING : If "Kodeviser", "Chip" or "Kodeoplæser" is chosen, it will result in immediately ordering of the hardware upon user creation.'''


ClientID
'''The hardware costs money, so be careful to get approval from customer before enabling these choices.'''


*Insert ClientID requested from Inlogic
===SQL Sentence===
Insert parameters for filtering purposes


ClientSecret
You can test it by using this SQL command and appending your own SQL sentence.


*Insert ClientSecret requested from Inlogic
Select Distinct Students.SLI_ID, Students.Fornavne As GivenName, Students.Efternavn As SurName, Students.CPR As CivilRegistrationNumber
, Students.WorkMail
From Students
Where
(StudieNr Is Not Null)
And (UserTypes_ID = 0)
And (SLI_ID Is Not Null)
And (CPR Is Not Null)
And (BirthDay Is Not Null)
And (Fornavne Is Not Null)
And (Fornavne <> <nowiki>''</nowiki>'')
And (Efternavn Is Not Null)
And (Efternavn <> <nowiki>''</nowiki>'')
And (WorkMail Is Not Null)
And (WorkMail <> <nowiki>''</nowiki>'')
And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
'''<Your SQL Sentence>'''


Environment
=== Parameters ===
{| class="wikitable"
|+Users
!Parameter
!Description
|-
|UsersOnly
|Runs all the parameters in this table
|-
|CreateUsers
|Create users
|-
|UpdateUsers
|Update users. This will also add authenticators if they are missing from the users.
|-
|DeleteUsers
|Delete users
|}
{| class="wikitable"
|+Groups
!Parameter
!Description
|-
|GroupsOnly
|Runs all the parameters in this table
|-
|CreateGroups
|Create groups
|-
|UpdateGroups
|Update groups
|-
|DeleteGroups
|Delete groups
|-
|AddGroupMembers
|Add new members to groups
|-
|RemoveGroupMembers
|Remove members from groups if they are no longer member of the group in the source data
|}


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


SQL Sentence
=== Find existing users ===
 
The user must be active for UMS to find the user otherwise it will create a new user.
*insert parameters for filtering purposes<br />
 
==Studily FAQ==
<br />
 
====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
 
 
 
<br />

Latest revision as of 09:36, 18 October 2023

UMS Configurator settings

Description

Insert a name or description for the setting

Admin servers

Choose the admin server created here MitID Erhverv

Maintain groups

This will created/update and delete groups.

It will also add users and remove them again.

These groups can be used to add security to users based on group membership.

Authenticators

Choose the authenticators to add to users.

WARNING : If "Kodeviser", "Chip" or "Kodeoplæser" is chosen, it will result in immediately ordering of the hardware upon user creation.

The hardware costs money, so be careful to get approval from customer before enabling these choices.

SQL Sentence

Insert parameters for filtering purposes

You can test it by using this SQL command and appending your own SQL sentence.

Select Distinct Students.SLI_ID, Students.Fornavne As GivenName, Students.Efternavn As SurName, Students.CPR As CivilRegistrationNumber
, Students.WorkMail
From Students
Where
(StudieNr Is Not Null)
And (UserTypes_ID = 0)
And (SLI_ID Is Not Null)
And (CPR Is Not Null)
And (BirthDay Is Not Null)
And (Fornavne Is Not Null)
And (Fornavne <> '')
And (Efternavn Is Not Null)
And (Efternavn <> '')
And (WorkMail Is Not Null)
And (WorkMail <> '')
And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
<Your SQL Sentence>

Parameters

Users
Parameter Description
UsersOnly Runs all the parameters in this table
CreateUsers Create users
UpdateUsers Update users. This will also add authenticators if they are missing from the users.
DeleteUsers Delete users
Groups
Parameter Description
GroupsOnly Runs all the parameters in this table
CreateGroups Create groups
UpdateGroups Update groups
DeleteGroups Delete groups
AddGroupMembers Add new members to groups
RemoveGroupMembers Remove members from groups if they are no longer member of the group in the source data

FAQ

Find existing users

The user must be active for UMS to find the user otherwise it will create a new user.