Teams: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
No edit summary
Kia (talk | contribs)
 
(44 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 Office 365 settings.
[[File:Teams Office 365 Settings.jpg|none|thumb|556x556px]]
[[File:Teams Office 365 Settings Edit.jpg|none|thumb|838x838px]]


== 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.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)
[[File:Teams Settings Edit.jpg|none|thumb|759x759px]]


==== Description ====
===Organization===
Give the Site settings a name.
[[Organization]]


==== Organization settings ====
==Installation==
Choose the Organization setting you want to use for this site setting.
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.


==== Users ====
==Teams settings==
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.


===== Username =====
====Use SDS====
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.
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]].


This column will be used as the login.
====Activate Team====
Let UMS activate the Team so teachers does not need to.


===== Delete users =====
====Delete Teams options====
Delete the users when they are no longer active
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.


===== Keep inactive before deleting =====
Administrators are kindly reminded to make a procedure for deleting teams manually, consider the life time cyclus for student information in Teams.
Wait this number of days before deleting inactive users


==== Template security groups ====
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 the box to create, update, and delete template security groups that has an Teams setting attached.


==== Upload student information ====
====Send mail to teachers====  
Check these boxes to send and update information on students:
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


==== Upload employee information ====
How to: [[Microsoft_SDS#Prevent_Teams_from_sending_spam_to_users]]
Check these boxes to send and update information on employees:
* Address
* Phone
* Mobile Phone
* Mail


=== Site ===
====Activity Teams====  
See [[LMS Settings]] for options that are not described below.
Activity Teams are for students for the daily communications, filesharing, and assignments.
[[File:Teams Settings Edit Site Settings.jpg|none|thumb|895x895px]]
==== Language ====
The language used for a site when it is created


==== Course category ====
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")
The category is put on the site when it is created


==== Activity 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.


==== Course sites ====
==Template Teams Settings==
See [[Site selection settings]]
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 Template Settings.jpg|none|thumb|556x556px]]
[[File:Teams Template Settings Edit.jpg|none|thumb|422x422px]]


== Organization settings ==
====Description====
[[File:Teams Organization Settings.jpg|link=http://wiki.inlogic.dk/index.php/File:Teams%20Organization%20Settings.jpg|none|thumb|556x556px]]
Enter a description for this setting.
[[File:Teams Organization Settings Edit.jpg|link=http://wiki.inlogic.dk/index.php/File:Teams%20Organization%20Settings%20Edit.jpg|none|thumb|324x324px]]
==== Description ====
Give your Organization setting a name.


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


==== Password ====
====SQL Groups====
Type your password for API connection (contact Teams to acquire your password).
See [[LMS Settings]] for this option.


==== Source organization ====
====Team Type====
Type the source organization for API connection (contact Teams to acquire the source organization).
Select the type of team to create. SDS only works with "'''Education - Class Team'''"


==== SQL Criteria ====
'''"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. If left blank there are no criteria.


==== Installation ID ====
====Template ID====
Type the password for the user with access to the database.
Create the team from another Team/Template.
=== Sub accounts ===
This section explains how to create a hierarchy in Teams. [[File:Teams Sub accounts.jpg|none|thumb|620x620px]]


==== DisplayName ====
'''Note :''' This only work for non Enterprise tenants and the template must be in en-US language.
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 ====
====Team visibility====
Select a column from the students table use the contents of that column to build the hierarchy.
Can be set to Private or Public


==== SQL Criteria ====
'''Note :''' This does not work if SDS is used.
Select only rows that match the SQL sentence. If left blank there are no criteria.


==== Example of how UMS will build a hierarchy ====
==FAQ==
The first two root elements come from the '<nowiki/>Sub accounts' settings.


All courses that UMS creates will be put in 'UMS Courses'.
===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
[[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>
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
</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.


All groups will be sorted in the hierarchy. Groups that are not sorted in the hierarchy will be put in 'UMS Groups'.
===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.


All template security groups will be created in 'UMS Template Groups'.[[File:Teams hierarchy.jpg|none|thumb|920x920px]]
TeamNames can be inspected in SQL with select * from Office365Teams
[[File:SQL inspect teamname.png|none|thumb|640x640px]]


== Site 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 Site Template Settings.jpg|none|thumb|556x556px]]
[[File:Prefix activities in template data source.png|none|thumb|660x660px]]
[[File:Teams Site Template Settings Edit.jpg|none|thumb|422x422px]]
<br />
==== Description ====
Enter a description for this setting.
 
==== Template ====
Enter a template that is used when creating courses.


==== SQL Groups ====
===How do I delete ALL existing Teams and recreate them with new names ?===
See [[LMS Settings]] for this option.


== Group Settings ==
#Run this SQL:  update Office365Teams set DeleteOnNextRun = 1, IsCreated = 1
You need to attach a cohort setting to a template. This will tell UMS that cohorts will be created from this template.
#Run LiveAtEdu with a parameter:  LiveAtEdu_Sync.exe deleteteams
[[File:Teams Group Template Settings.jpg|none|thumb|556x556px]]
#Monitor the table and see that teams disapear:  select * from Office365Teams
[[File:Teams Group Template Settings Edit.jpg|none|thumb|422x422px]]
#When no unwanted teams exist in  the table, then populate the table again: LiveAtEdu_Sync.exe addteams2db
==== Description ====
#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
Enter a description for this setting.
 
==== Template ====
Enter a template that is used when creating groups.
 
==== SQL Groups ====
See [[LMS Settings]] for this option.


== 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