Teams: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Kia (talk | contribs)
 
(45 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Our Teams integration is developed for schools that want to avoid hour-long administrative tasks. The integration automatically creates, maintains, and deletes users based on data from your student administrative system. It also creates and maintains group rooms, which teachers and students can use for teaching purposes. The rooms automatically use the language you require and can be categorized according to your needs, making them easier to find. Rooms that are no longer in use are deleted automatically.  
Our Teams integration is developed for schools that want to avoid hour-long administrative tasks. The integration automatically creates, maintains, and deletes users based on data from your student administrative system. It also creates and maintains group rooms, which teachers and students can use for teaching purposes. The rooms automatically use the language you require and can be categorized according to your needs, making them easier to find. Rooms that are no longer in use are deleted automatically.  


=== Configuration in UMS ===
===Configuration in UMS===
This allows users to log into Teams with the same password they use to access the school’s IT-system. The Teams integration gives you an easy overview and ensures that the users’ data is always managed correctly, without requiring any manual updates. This frees up time for the IT-department so they can focus on other tasks.
This allows users to log into Teams with the same password they use to access the school’s IT-system. The Teams integration gives you an easy overview and ensures that the users’ data is always managed correctly, without requiring any manual updates. This frees up time for the IT-department so they can focus on other tasks.


== Prerequisites ==
==Prerequisites==


=== Module requirements ===
===Module requirements===
[[UMS]]
[[Office365 Tenant]]


=== What to have ready ===
[[Office 365]]
[[Microsoft SDS]]


== Installation ==
===Unsupported administrative systems===
Open UMS Configurator and go to Template > Teams. Click the first manage button.
[[File:Teams Office 365 Template.jpg|none|thumb|791x791px]]
You will now see an overview of your Teams settings.
[[File:Teams Office 365 Settings.jpg|none|thumb|556x556px]]


== Teams settings ==
Tabulex and KMD does not provide teacher relations to classes. Without teachers class enrollments, Teams can't be created. This requires a change to extract data from [[GetStudents/UNILogin|UNILogin]] instead. <br />
===What to have ready===
[[UMS update guide]] (update to the latest version)


[[File:Teams Settings Edit.jpg|none|thumb|751x751px]]
[[Microsoft SDS]] (This can only be setup after you have configured UMS and installed the Web program https://downloads.inlogic.dk/inlogic_IMS_sync.zip)
==== Description ====
Give the Site settings a name.


==== Organization settings ====
===Organization===
Choose the Organization setting you want to use for this site setting.
[[Organization]]


==== Users ====
==Installation==
Open UMS Configurator and go to Template > Office 365. Click the first manage button.
[[File:Teams Office 365 Template.jpg|none|thumb|640x640px]]
You will now see an overview of your Office 365 settings.
[[File:Teams Office 365 Settings.jpg|none|thumb|556x556px]]
[[File:Teams Office 365 Settings Edit.jpg|none|thumb|640x640px]]You need to set a Teams settings on this Office 365 Setting. Shown in the red square.


===== Username =====
==Teams settings==
Choose a column from the students table. Its default is <Not used>. This means that the username will be the same as in Active Directory.
You will now see an overview of your Teams settings.[[File:Teams Settings.jpg|none|thumb|556x556px]]Click '''Add''' or '''Edit'''
[[File:Office365 Teams Settings Edit.jpg|none|thumb|886x886px]]
See [[LMS Settings]] for options that are not described below.


This column will be used as the login.
====Use SDS====
Use Microsoft School Data sync instead of Microsoft Graph to create Teams and add persons. SDS only works with "'''Education - Class Team'''" in [[Teams#Team Type|Template Teams Settings]].


===== Delete users =====
====Activate Team====
Delete the users when they are no longer active
Let UMS activate the Team so teachers does not need to.


===== Keep inactive before deleting =====
====Delete Teams options====
Wait this number of days before deleting inactive users
Once a team is deleted you can’t recover lost files and conversations from a deleted course/team, hence we recommend that you consider which delete option setting that are best for your organisation. If delete option are set to “Manual delete sites” no teams will automatically deleted and will stay available until deleted by an team owner or office 365 administrator.


==== Template security groups ====
Administrators are kindly reminded to make a procedure for deleting teams manually, consider the life time cyclus for student information in Teams.
Check the box to create, update, and delete template security groups that has an Teams setting attached.


==== Upload student information ====
If delete options are set to “Auto delete when there are no more learners” teams will be automatically deleted once there are no more students at the school who has been attending the course/team. In some countries like Denmark the school must preserve courses / teams for the whole school period, which is supported by this setting.
Check these boxes to send and update information on students:
* Address
* Phone
* Mobile Phone
* Mail


==== Upload employee information ====
====Send mail to teachers====  
Check these boxes to send and update information on employees:
UMS can notify users when they have been added to a SharePoint site, a OneNote Class Notebook or a Team. However, Microsoft School Data Sync always sends mails to users. Avoid this with an Exchange mail flow.
* Address
* Phone
* Mobile Phone
* Mail


=== Site ===
How to: [[Microsoft_SDS#Prevent_Teams_from_sending_spam_to_users]]
See [[LMS Settings]] for options that are not described below.
[[File:Teams Settings Edit Site Settings.jpg|none|thumb|895x895px]]
==== Language ====
The language used for a site when it is created


==== Course category ====
====Activity Teams====  
The category is put on the site when it is created
Activity Teams are for students for the daily communications, filesharing, and assignments.


==== Activity sites ====
Select a title from a range of options. Some schools prefer class names like “ukmba18ftsep”, other schools prefer “Mathematics 3z (ma3z)”. In order to obtain a team name like “Mathematics 3z (ma3z)” select the option "Activity description (Short description")
See [[Site selection settings]]


==== Course sites ====
====Course Teams====  
See [[Site selection settings]]
Some student information systems (SIS) like EASY are course-based and not activity-based. If you are using a course-based SIS then configure this section instead of Activity Teams.


== Organization settings ==
==Template Teams Settings==
[[File:Teams Organization Settings.jpg|link=http://wiki.inlogic.dk/index.php/File:Teams%20Organization%20Settings.jpg|none|thumb|556x556px]]
You need to attach a teams template setting to a template. This will tell UMS that Teams will be created from this template.
[[File:Teams Organization Settings Edit.jpg|link=http://wiki.inlogic.dk/index.php/File:Teams%20Organization%20Settings%20Edit.jpg|none|thumb|324x324px]]
[[File:Teams Template Settings.jpg|none|thumb|556x556px]]
==== Description ====
[[File:Teams Template Settings Edit.jpg|none|thumb|422x422px]]
Give your Organization setting a name.


==== Username ====
====Description====
Type your username for API connection (contact Teams to acquire your username).
Enter a description for this setting.


==== Password ====
====Hide from address list====
Type your password for API connection (contact Teams to acquire your password).
Enable this to hide teams from address list.


==== Source organization ====
====SQL Groups====
Type the source organization for API connection (contact Teams to acquire the source organization).
See [[LMS Settings]] for this option.
 
==== SQL Criteria ====
This is an overall SQL sentence that is used when creating groups. It is used in conjunction with the sub account settings. This has no impact on courses being created. If left blank there are no criteria.


==== Installation ID ====
====Team Type====
Type the password for the user with access to the database.
Select the type of team to create. SDS only works with "'''Education - Class Team'''"
=== Sub accounts ===
This section explains how to create a hierarchy in Teams. [[File:Teams Sub accounts.jpg|none|thumb|620x620px]]


==== DisplayName ====
'''"Custom Team Template"''' Does not work for EDU tenants.
This is an overall SQL sentence that is used when creating groups. It is used in conjunction with the sub account settings. This has no impact on courses being created.


==== Database field ====
====Template ID====
Select a column from the students table use the contents of that column to build the hierarchy.
Create the team from another Team/Template.


==== SQL Criteria ====
'''Note :''' This only work for non Enterprise tenants and the template must be in en-US language.
Select only rows that match the SQL sentence. If left blank there are no criteria.


==== Example of how UMS will build a hierarchy ====
====Team visibility====
The first two root elements come from the '<nowiki/>Sub accounts' settings.
Can be set to Private or Public


All courses that UMS creates will be put in 'UMS Courses'.
'''Note :''' This does not work if SDS is used.


All groups will be sorted in the hierarchy. Groups that are not sorted in the hierarchy will be put in 'UMS Groups'.
==FAQ==


All template security groups will be created in 'UMS Template Groups'.[[File:Teams hierarchy.jpg|none|thumb|920x920px]]
===Why is my class not created in Teams ?===
 
If no teacher have a timetable for the class, it will not be created in Teams. Inspect this in sds.microsoft.com / Your Organization / View Sections, Teachers, and Students
== Site Settings ==
[[File:Teams not created because of missing teachers.png|none|thumb|640x640px]]Use this SQL to investigate timetable entries in UMS database (replace activity codes in SQL)<table><tr><td><pre>
You need to attach a cohort setting to a template. This will tell UMS that cohorts will be created from this template.
select SkemaBrikkerNewEntries.*
[[File:Teams Site Template Settings.jpg|none|thumb|556x556px]]
from SkemaBrikkerNewEntries, SkemaBrikker_Teachers
[[File:Teams Site Template Settings Edit.jpg|none|thumb|422x422px]]
Where
==== Description ====
SkemaBrikkerNewEntries.SkemaBegivenhed_ID = SkemaBrikker_Teachers.SkemaBegivenhed_ID
Enter a description for this setting.
And SkemaBrikkerNewEntries.SkemaBrikkerAdminServers_ID = SkemaBrikker_Teachers.SkemaBrikkerAdminServers_ID
And SkemaBrikker_Teachers.cpr In (Select Cpr from Students where Activity in ('G17daaG31708' , 'G17enaD1708' ,'G17daaG21708'))
Order By RealStartDateTime
</pre>
</td></tr></table>If no data exist then you have to change the datasource on the staff template to a supported school administrative system.


==== Template ====
===How do I change Team names ?===
Enter a template that is used when creating courses.
Depending on which parameter selected to name Team it is possible to alter names after creation. This can be done via SQL statements editing selected parameter value and if setting is set in SDS, it will rename Team on next sync cycle.


==== SQL Groups ====
TeamNames can be inspected in SQL with select * from Office365Teams
See [[LMS Settings]] for this option.
[[File:SQL inspect teamname.png|none|thumb|640x640px]]


== Group Settings ==
===How do I prefix Team names ?===
You need to attach a cohort setting to a template. This will tell UMS that cohorts will be created from this template.
Administrators of multiple schools on the same Office 365 tenant may want to prefix activities in order make Team names more transparent. Image dozens of schools with similar activities, how can a teacher or a student with actitivities accross institutions be able to distinguish teams? By prefixing the actitivities in the data sources! However, if you provision a new prefix on an existing datasource you must be aware of that new AD groups will be created and existing AD groups will be obsolete.  
[[File:Teams Group Template Settings.jpg|none|thumb|556x556px]]
[[File:Prefix activities in template data source.png|none|thumb|660x660px]]
[[File:Teams Group Template Settings Edit.jpg|none|thumb|422x422px]]
<br />
==== Description ====
Enter a description for this setting.


==== Template ====
===How do I delete ALL existing Teams and recreate them with new names ?===
Enter a template that is used when creating groups.


==== SQL Groups ====
#Run this SQL:  update Office365Teams set DeleteOnNextRun = 1, IsCreated = 1
See [[LMS Settings]] for this option.
#Run LiveAtEdu with a parameter:  LiveAtEdu_Sync.exe deleteteams
#Monitor the table and see that teams disapear:  select * from Office365Teams
#When no unwanted teams exist in  the table, then populate the table again:  LiveAtEdu_Sync.exe addteams2db
#Inspect the team names and if it looks good (depending on what option you selected in configurator) then you are ready to create them by using  LiveAtEdu_Sync.exe teamsonly


== FAQ ==
<br />

Latest revision as of 10:33, 26 March 2021

Our Teams integration is developed for schools that want to avoid hour-long administrative tasks. The integration automatically creates, maintains, and deletes users based on data from your student administrative system. It also creates and maintains group rooms, which teachers and students can use for teaching purposes. The rooms automatically use the language you require and can be categorized according to your needs, making them easier to find. Rooms that are no longer in use are deleted automatically.

Configuration in UMS

This allows users to log into Teams with the same password they use to access the school’s IT-system. The Teams integration gives you an easy overview and ensures that the users’ data is always managed correctly, without requiring any manual updates. This frees up time for the IT-department so they can focus on other tasks.

Prerequisites

Module requirements

Office365 Tenant

Office 365

Unsupported administrative systems

Tabulex and KMD does not provide teacher relations to classes. Without teachers class enrollments, Teams can't be created. This requires a change to extract data from UNILogin instead.

What to have ready

UMS update guide (update to the latest version)

Microsoft SDS (This can only be setup after you have configured UMS and installed the Web program https://downloads.inlogic.dk/inlogic_IMS_sync.zip)

Organization

Organization

Installation

Open UMS Configurator and go to Template > Office 365. Click the first manage button.

You will now see an overview of your Office 365 settings.

You need to set a Teams settings on this Office 365 Setting. Shown in the red square.

Teams settings

You will now see an overview of your Teams settings.

Click Add or Edit

See LMS Settings for options that are not described below.

Use SDS

Use Microsoft School Data sync instead of Microsoft Graph to create Teams and add persons. SDS only works with "Education - Class Team" in Template Teams Settings.

Activate Team

Let UMS activate the Team so teachers does not need to.

Delete Teams options

Once a team is deleted you can’t recover lost files and conversations from a deleted course/team, hence we recommend that you consider which delete option setting that are best for your organisation. If delete option are set to “Manual delete sites” no teams will automatically deleted and will stay available until deleted by an team owner or office 365 administrator.

Administrators are kindly reminded to make a procedure for deleting teams manually, consider the life time cyclus for student information in Teams.

If delete options are set to “Auto delete when there are no more learners” teams will be automatically deleted once there are no more students at the school who has been attending the course/team. In some countries like Denmark the school must preserve courses / teams for the whole school period, which is supported by this setting.

Send mail to teachers

UMS can notify users when they have been added to a SharePoint site, a OneNote Class Notebook or a Team. However, Microsoft School Data Sync always sends mails to users. Avoid this with an Exchange mail flow.

How to: Microsoft_SDS#Prevent_Teams_from_sending_spam_to_users

Activity Teams

Activity Teams are for students for the daily communications, filesharing, and assignments.

Select a title from a range of options. Some schools prefer class names like “ukmba18ftsep”, other schools prefer “Mathematics 3z (ma3z)”. In order to obtain a team name like “Mathematics 3z (ma3z)” select the option "Activity description (Short description")

Course Teams

Some student information systems (SIS) like EASY are course-based and not activity-based. If you are using a course-based SIS then configure this section instead of Activity Teams.

Template Teams Settings

You need to attach a teams template setting to a template. This will tell UMS that Teams will be created from this template.

Description

Enter a description for this setting.

Hide from address list

Enable this to hide teams from address list.

SQL Groups

See LMS Settings for this option.

Team Type

Select the type of team to create. SDS only works with "Education - Class Team"

"Custom Team Template" Does not work for EDU tenants.

Template ID

Create the team from another Team/Template.

Note : This only work for non Enterprise tenants and the template must be in en-US language.

Team visibility

Can be set to Private or Public

Note : This does not work if SDS is used.

FAQ

Why is my class not created in Teams ?

If no teacher have a timetable for the class, it will not be created in Teams. Inspect this in sds.microsoft.com / Your Organization / View Sections, Teachers, and Students

Use this SQL to investigate timetable entries in UMS database (replace activity codes in SQL)

select SkemaBrikkerNewEntries.*
from SkemaBrikkerNewEntries, SkemaBrikker_Teachers
Where 
SkemaBrikkerNewEntries.SkemaBegivenhed_ID = SkemaBrikker_Teachers.SkemaBegivenhed_ID
And SkemaBrikkerNewEntries.SkemaBrikkerAdminServers_ID = SkemaBrikker_Teachers.SkemaBrikkerAdminServers_ID
And SkemaBrikker_Teachers.cpr In (Select Cpr from Students where Activity in ('G17daaG31708' , 'G17enaD1708' ,'G17daaG21708'))
Order By RealStartDateTime

If no data exist then you have to change the datasource on the staff template to a supported school administrative system.

How do I change Team names ?

Depending on which parameter selected to name Team it is possible to alter names after creation. This can be done via SQL statements editing selected parameter value and if setting is set in SDS, it will rename Team on next sync cycle.

TeamNames can be inspected in SQL with select * from Office365Teams

How do I prefix Team names ?

Administrators of multiple schools on the same Office 365 tenant may want to prefix activities in order make Team names more transparent. Image dozens of schools with similar activities, how can a teacher or a student with actitivities accross institutions be able to distinguish teams? By prefixing the actitivities in the data sources! However, if you provision a new prefix on an existing datasource you must be aware of that new AD groups will be created and existing AD groups will be obsolete.


How do I delete ALL existing Teams and recreate them with new names ?

  1. Run this SQL: update Office365Teams set DeleteOnNextRun = 1, IsCreated = 1
  2. Run LiveAtEdu with a parameter: LiveAtEdu_Sync.exe deleteteams
  3. Monitor the table and see that teams disapear: select * from Office365Teams
  4. When no unwanted teams exist in the table, then populate the table again: LiveAtEdu_Sync.exe addteams2db
  5. Inspect the team names and if it looks good (depending on what option you selected in configurator) then you are ready to create them by using LiveAtEdu_Sync.exe teamsonly