Microsoft SDS - Revision history

Cna: Added link to SDS interactive guide

2021-03-26T10:06:39Z

Added link to SDS interactive guide

← Older revision		Revision as of 10:06, 26 March 2021
Line 40:		Line 40:
	<br />		<br />
	==Configuration of SDS profile==		==Configuration of SDS profile==
			https://interactiveguides-schooldatasync.azurewebsites.net/

	Login to https://sds.microsoft.com as a global administrator[[File:Microsoft SDS Dashboard New.jpg\|none\|thumb\|640x640px]]		Login to https://sds.microsoft.com as a global administrator[[File:Microsoft SDS Dashboard New.jpg\|none\|thumb\|640x640px]]
	Click '''Add Profile'''		Click '''Add Profile'''

Sva: /* Prevent Teams from sending spam to users */

2020-02-05T12:04:41Z

Prevent Teams from sending spam to users

← Older revision		Revision as of 12:04, 5 February 2020
Line 180:		Line 180:
	====Prevent Teams from sending spam to users====		====Prevent Teams from sending spam to users====
	If sender address contains “email.teams.microsoft.com” then redirect them to someone else.		If sender address contains “email.teams.microsoft.com” then redirect them to someone else.

			'''''Warning''': if you implement this rule, any mail notification from Teams will not reach users, this includes mail notifications on new chat messages and other communinactions between users in Teams.''
	[[File:Teams spam can be stopped with an Exchange flow.png\|left\|thumb\|1409x1409px\|Teams spam can be stopped with an Exchange flow]]		[[File:Teams spam can be stopped with an Exchange flow.png\|left\|thumb\|1409x1409px\|Teams spam can be stopped with an Exchange flow]]
	<br />		<br />

Khm at 13:26, 22 October 2019

2019-10-22T13:26:18Z

← Older revision		Revision as of 13:26, 22 October 2019
Line 115:		Line 115:
	<br>test firewall: https://www.yougetsignal.com/tools/open-ports </li>		<br>test firewall: https://www.yougetsignal.com/tools/open-ports </li>
	<li>UMS backend is not configured properly</li>		<li>UMS backend is not configured properly</li>
			<li>OS version that supports TLS 1.2 - [https://docs.microsoft.com/en-us/dotnet/framework/network-programming/tls#support-for-tls-12 See more here]
			</li>
	</ul>		</ul>

Khm at 13:23, 22 October 2019

2019-10-22T13:23:09Z

← Older revision		Revision as of 13:23, 22 October 2019
Line 14:		Line 14:
	**Templates must have a Office 365 Teams template		**Templates must have a Office 365 Teams template
	*Updated data in SQL tables (update data with LiveAtEdu_Sync)		*Updated data in SQL tables (update data with LiveAtEdu_Sync)
			*OS version that supports TLS 1.2 - [https://docs.microsoft.com/en-us/dotnet/framework/network-programming/tls#support-for-tls-12 See more here]

	===What to have ready===		===What to have ready===
Line 143:		Line 144:
	Hereafter the user will be correctly maintained by LiveAtEdu_Sync and SDS synchronization will not fail.		Hereafter the user will be correctly maintained by LiveAtEdu_Sync and SDS synchronization will not fail.

	==== Missing students ====		====Missing students====
	You can inspect the data UMS has provided for SDS using the views in UMS database.		You can inspect the data UMS has provided for SDS using the views in UMS database.
	Example: show the students that are enrolled in a class with title VUCTM_m202dsabaug.19		Example: show the students that are enrolled in a class with title VUCTM_m202dsabaug.19

Sva: /* Missing students */

2019-08-30T11:46:56Z

Missing students

← Older revision		Revision as of 11:46, 30 August 2019
Line 152:		Line 152:
	Compare the number of students in UMS database and what you see in SDS. In this example there should have been 31 students but only 4 are visible.		Compare the number of students in UMS database and what you see in SDS. In this example there should have been 31 students but only 4 are visible.
	[[File:Missing students in SDS.png\|none\|thumb\|300x300px]]		[[File:Missing students in SDS.png\|none\|thumb\|300x300px]]
	In order to fix the problem: remove ~~all~~ references between ~~students~~ and ~~teams~~ in UMS database and run a full LiveAtEdu_Sync. After a while SDS will update all learners on teams.		In order to fix the problem: remove references between student(s) and class(es) in UMS database and run a full LiveAtEdu_Sync. After a while SDS will update all learners on teams.

			Delete all references
	{\| class="wikitable"		{\| class="wikitable"
	!delete from Office365TeamsXRef_Learners_Teams		!delete from Office365TeamsXRef_Learners_Teams
			\|}

			Delete references for a student
			{\| class="wikitable"
			!delete from Office365TeamsXRef_Learners_Teams where Office365Teams_Learners_ID in (
			select id from Office365Teams_Learners where username = 'maze0074')
			\|}

			Delete references for a class
			{\| class="wikitable"
			!delete from Office365TeamsXRef_Learners_Teams where Office365Teams_ID in (
			select sourcedId from V_Office365TeamsClasses where title = 'VUCTM_t203dsaGAug.19')
	\|}		\|}

Sva: /* FAQ */

2019-08-30T08:09:52Z

FAQ

← Older revision		Revision as of 08:09, 30 August 2019
Line 145:		Line 145:
	==== Missing students ====		==== Missing students ====
	You can inspect the data UMS has provided for SDS using the views in UMS database.		You can inspect the data UMS has provided for SDS using the views in UMS database.
			Example: show the students that are enrolled in a class with title VUCTM_m202dsabaug.19
	{\| class="wikitable"		{\| class="wikitable"
	~~\|+Example: show the students that are enrolled in a class with title VUCTM_m202dsabaug.19~~
	!select * from V_Office365TeamsEnrollments where class_id in (		!select * from V_Office365TeamsEnrollments where class_id in (
	select sourcedId from V_Office365TeamsClasses where title = 'VUCTM_m202dsabaug.19')		select sourcedId from V_Office365TeamsClasses where title = 'VUCTM_m202dsabaug.19')
Line 154:		Line 154:
	In order to fix the problem: remove all references between students and teams in UMS database and run a full LiveAtEdu_Sync. After a while SDS will update all learners on teams.		In order to fix the problem: remove all references between students and teams in UMS database and run a full LiveAtEdu_Sync. After a while SDS will update all learners on teams.
	{\| class="wikitable"		{\| class="wikitable"
	~~\|+Remove all references between students and teams~~
	!delete from Office365TeamsXRef_Learners_Teams		!delete from Office365TeamsXRef_Learners_Teams
	\|}		\|}

Sva: /* Known problems and how you handle them */

2019-08-30T07:56:45Z

Known problems and how you handle them

← Older revision		Revision as of 07:56, 30 August 2019
Line 132:		Line 132:
	[[File:Sync error - CSV.png\|none\|thumb\|1440x1440px]]		[[File:Sync error - CSV.png\|none\|thumb\|1440x1440px]]

	==== The teacher could not be added to the class ====		====The teacher could not be added to the class====
	[[File:Sync error - CSV - teacher could not be added to the class.png\|none\|thumb\|1660x1660px]]		[[File:Sync error - CSV - teacher could not be added to the class.png\|none\|thumb\|1660x1660px]]
	In order to find who the teacher is, search for sourcedid in this view:		In order to find who the teacher is, search for sourcedid in this view:
Line 143:		Line 143:
	Hereafter the user will be correctly maintained by LiveAtEdu_Sync and SDS synchronization will not fail.		Hereafter the user will be correctly maintained by LiveAtEdu_Sync and SDS synchronization will not fail.

	~~<br />~~		==== Missing students ====
			You can inspect the data UMS has provided for SDS using the views in UMS database.
			{\| class="wikitable"
			\|+Example: show the students that are enrolled in a class with title VUCTM_m202dsabaug.19
			!select * from V_Office365TeamsEnrollments where class_id in (
			select sourcedId from V_Office365TeamsClasses where title = 'VUCTM_m202dsabaug.19')
			\|}
			Compare the number of students in UMS database and what you see in SDS. In this example there should have been 31 students but only 4 are visible.
			[[File:Missing students in SDS.png\|none\|thumb\|300x300px]]
			In order to fix the problem: remove all references between students and teams in UMS database and run a full LiveAtEdu_Sync. After a while SDS will update all learners on teams.
			{\| class="wikitable"
			\|+Remove all references between students and teams
			!delete from Office365TeamsXRef_Learners_Teams
			\|}

	====It takes longer than normal to configure Teams====		====It takes longer than normal to configure Teams====
	During problems with the Teams service at Microsoft you might experience a long time for configuration of sections. There is nothing you or we can do about it, just be patient and wait.		During problems with the Teams service at Microsoft you might experience a long time for configuration of sections. There is nothing you or we can do about it, just be patient and wait.

Sva: /* Errors in synchronization */

2019-04-10T09:53:01Z

Errors in synchronization

@@ Line 131: / Line 131: @@
 Any application error must be handled by [[Microsoft Support|'''Microsoft Support''']] and remember to attach the CSV file along with a document describing the problems you experience.
 [[File:Sync error - CSV.png|none|thumb|1440x1440px]]
 <br />
 ====It takes longer than normal to configure Teams====

Sva: Undo revision 2655 by Sva (talk)

2019-03-22T12:57:24Z

Undo revision 2655 by Sva (talk)

← Older revision		Revision as of 12:57, 22 March 2019
Line 7:		Line 7:
	===Module requirements===		===Module requirements===

	*UMS ~~Web~~		*[[UMS]]
	*~~Advanced CSV export~~		*[[Teams\|Teams configurations]]
			**Modules, a Office 365 Tenant setting
			**Modules, a Office 365 Teams setting
			**Templates must have an Organization type
			**Templates must have a Office 365 Teams template
			*Updated data in SQL tables (update data with LiveAtEdu_Sync)

			===What to have ready===

			*A valid licens file that includes Office 365 Teams
			*A star-certficate or a certificate that includes the hostheader of the SDS webservice
			*A firewall opening to port 443 since the SDS webservice uses HTTPS

	==Installation of SDS webservice==		==Installation of SDS webservice==

Sva: /* Prerequisites */

2019-03-22T12:56:31Z

Prerequisites

← Older revision		Revision as of 12:56, 22 March 2019
Line 7:		Line 7:
	===Module requirements===		===Module requirements===

	*[[UMS]]		*UMS Web
	*~~[[Teams\|Teams configurations]]~~		*Advanced CSV export
	**Modules, a Office 365 Tenant setting
	**Modules, a Office 365 Teams setting
	**Templates must have an Organization type
	**Templates must have a Office 365 Teams template
	*Updated data in SQL tables (update data with LiveAtEdu_Sync)

	~~===What to have ready===~~

	*A valid licens file that includes Office 365 Teams
	*A star-certficate or a certificate that includes the hostheader of the SDS webservice
	*A firewall opening to port 443 since the SDS webservice uses HTTPS

	==Installation of SDS webservice==		==Installation of SDS webservice==