G Suite: Difference between revisions
Replaced Office 365 with Google |
|||
(34 intermediate revisions by 2 users not shown) | |||
Line 13: | Line 13: | ||
==Prerequisites== | ==Prerequisites== | ||
===Module requirements=== | ===Module requirements=== | ||
[[ | [[Google app API]] | ||
==Installation== | ==Installation== | ||
[[File:Googleappsadminsettings.png|none|frame]] | |||
[[File:Googleappsadminsettings.png|none| | |||
=== Organization settings === | |||
See description how to create/setup further down this page | See description how to create/setup further down this page | ||
=== Users === | |||
==== Mail Alias ==== | |||
Choose what to use as the users mail address (login). | Choose what to use as the users mail address (login). | ||
====Disable users==== | |||
When marked the users will be disabled when they are no longer attending classes. | When marked the users will be disabled when they are no longer attending classes. | ||
====Delete users==== | |||
Choose if users are to be deleted after grace period has ended. | Choose if users are to be deleted after grace period has ended. | ||
====Forward mail to on premise mail server==== | |||
This will forward the users Google mail to the primary mail address from AD (If user does not have a proxy address it will read it from the mail attribute) | |||
This will forward the users | |||
====Keep inactive before deleting x days==== | |||
Specify a grace period where users are disabled. | Specify a grace period where users are disabled. | ||
==== Distribution lists ==== | |||
=====Maintain lists===== | |||
Mark this to create distribution groups in Google. The groups will be created, updated and deleted if this is specified. | |||
Mark this to create distribution groups in | |||
=====Delete lists===== | |||
Mark this to delete distributions groups when they are no longer active in the administrative system. Check the data export manuals too when this happens | Mark this to delete distributions groups when they are no longer active in the administrative system. Check the data export manuals too when this happens | ||
=====Delete unused lists after x days===== | |||
Specify in days how long the distribution groups are to be kept alive in Google before deletion. | |||
Specify in days how long the distribution groups are to be kept alive in | |||
==== Template security groups ==== | |||
=====Maintain===== | |||
This will create the security group entered in the field “template security group” in the destination node in the template settings. | This will create the security group entered in the field “template security group” in the destination node in the template settings. | ||
==== Timetable ==== | |||
=====Maintain===== | |||
Mark this to create timetable blocks in Google Apps. They will be created, updated and deleted. | Mark this to create timetable blocks in Google Apps. They will be created, updated and deleted. | ||
=====Delete old===== | |||
Mark this to delete old timetable blocks from calendars. | Mark this to delete old timetable blocks from calendars. | ||
=== | ===Site=== | ||
[[File:Googleappssite.png|none|thumb|720x720px]] | [[File:Googleappssite.png|none|thumb|720x720px]] | ||
''' | ====Automation type==== | ||
'''Full''' | |||
Means that site maintenance will be fully automated. | |||
''' | ====Remove learner method==== | ||
'''Deleted in AD''' | |||
Users will be removed from site when they are not active in UMS anymore | Users will be removed from site when they are not active in UMS anymore | ||
'''Finished on activity/course''' | |||
Users will be removed when they have finished with the course. | Users will be removed when they have finished with the course. | ||
''' | ====Delete sites==== | ||
'''Auto delete''' | |||
Sites will be delete when the last student has left the site | Sites will be delete when the last student has left the site | ||
'''Manual Delete''' | |||
Sites will not be deleted by UMS. This has to be done by an administrator | Sites will not be deleted by UMS. This has to be done by an administrator | ||
====Send mail to teacher(s)==== | |||
Send mail notification to teachers when they are attached to a site. | Send mail notification to teachers when they are attached to a site. | ||
====Create x days before==== | |||
Choose how many days before start that the sites are to be created. | Choose how many days before start that the sites are to be created. | ||
====Delete x days after end==== | |||
Choose how many days after end that the sites are to be deleted. | Choose how many days after end that the sites are to be deleted. | ||
====Teacher rights on sites==== | |||
Rights the teacher will have on the site when attached. | Rights the teacher will have on the site when attached. | ||
====Learner rights on sites==== | |||
Rights the student/learner will have on the site when attached. | Rights the student/learner will have on the site when attached. | ||
=== | ==== SQL Groups ==== | ||
Members of these groups will be attached to all sites created with this setting as teachers | Members of these groups will be attached to all sites created with this setting as teachers | ||
[[File:Googleappssqlgroups.png|none|thumb|458x458px]] | [[File:Googleappssqlgroups.png|none|thumb|458x458px]] | ||
=====Group name===== | |||
This can only be a group that is found in UMS | This can only be a group that is found in UMS | ||
You get a list of these groups by running this SQL command: | You get a list of these groups by running this SQL command: | ||
Select Distinct Aktivitet As Activity From Students Order By Activity | |||
====Activity Sites==== | |||
'''Do not create''' | |||
''' | |||
It will not create any sites based on activities. | It will not create any sites based on activities. | ||
''' | '''LMS has to be checked''' | ||
The field Aktivitet_LMS in the students table has to be | The field Aktivitet_LMS in the students table has to be “'''True'''”. (Look in the documentation for the specific administrative system to see how this is set) | ||
''' | '''Based on template filter''' | ||
Create sites based on a filter that is specified per template. | Create sites based on a filter that is specified per template. | ||
[[File:Googleappsactivitysites.png|none|thumb|493x493px]] | [[File:Googleappsactivitysites.png|none|thumb|493x493px]]'''All''' | ||
''' | |||
Create all sites. | Create all sites. | ||
'''Title''' | ====='''Title'''===== | ||
Title of the site. Changing this after a site has been created will cause it to be updated. | Title of the site. Changing this after a site has been created will cause it to be updated. | ||
=====Description===== | |||
Description of the site. Changing this after a site has been created will cause it to be updated. | Description of the site. Changing this after a site has been created will cause it to be updated. | ||
=== | ===== Search filter and criteria ===== | ||
This will enable you to concatenate sites that would have been created as to or more sites to be created as one site. | This will enable you to concatenate sites that would have been created as to or more sites to be created as one site. | ||
[[File:Googleappssearchfilters.png|none|thumb|401x401px]] | [[File:Googleappssearchfilters.png|none|thumb|401x401px]] | ||
====== Remarks ====== | |||
This is just for description purposes. | This is just for description purposes. | ||
====== Filter ====== | |||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | ||
====== Semester roll ====== | |||
====== Use replace string with empty ====== | |||
This will replace a section of the site with an empty string. | This will replace a section of the site with an empty string. | ||
====== Start index ====== | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
====== Length ====== | |||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
====== Add activity short description to node ID ====== | |||
This will add the field Kort_Betegnelse (Short Description) from the students table to the node id. | This will add the field Kort_Betegnelse (Short Description) from the students table to the node id. | ||
Node id is the URL. | Node id is the URL. | ||
==== | ====== Examples ====== | ||
If you have three activities named English1, English2, English3 and you only want one SharePoint site. | If you have three activities named English1, English2, English3 and you only want one SharePoint site. | ||
Line 219: | Line 171: | ||
This filter ensures that it is only applied to activities that matches this SQL sentence. | This filter ensures that it is only applied to activities that matches this SQL sentence. | ||
''' | '''Course Sites''' | ||
Course URL’s will always be created as | Course URL’s will always be created as “Activity_Course”. | ||
''' | '''Do not create''' | ||
It will not create any sites based on courses. | It will not create any sites based on courses. | ||
''' | '''LMS has to be checked''' | ||
The field Skolefag_LMS in the students table has to be | The field Skolefag_LMS in the students table has to be “'''True'''”. (Look in the documentation for the specific administrative system to see how this is set) | ||
''' | '''Based on template filter''' | ||
Create sites based on a filter that is specified per template. | Create sites based on a filter that is specified per template. | ||
[[File:Googleappsactivitysites.png|none|thumb|493x493px]] | [[File:Googleappsactivitysites.png|none|thumb|493x493px]] | ||
===== All===== | |||
Create all sites. | Create all sites. | ||
===== Title===== | |||
Title of the site. Changing this after a site has been created will cause it to be updated. | Title of the site. Changing this after a site has been created will cause it to be updated. | ||
===== Description===== | |||
Description of the site. Changing this after a site has been created will cause it to be updated. | Description of the site. Changing this after a site has been created will cause it to be updated. | ||
===== Search filter and criteria===== | |||
This will enable you to concatenate sites that would have been created as two or more sites to be created as one site. | This will enable you to concatenate sites that would have been created as two or more sites to be created as one site. | ||
[[File:Googleappsseachfilters3.png|none|thumb|427x427px]] | [[File:Googleappsseachfilters3.png|none|thumb|427x427px]] | ||
====== Remarks====== | |||
This is just for description purposes. | This is just for description purposes. | ||
====== Course Filter====== | |||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll. | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll. | ||
====== Semester roll====== | |||
====== Use replace string with empty====== | |||
This will replace a section of the site with an empty string. | This will replace a section of the site with an empty string. | ||
====== Start index====== | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
====== Length====== | |||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
====== Activity Filter====== | |||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | ||
====== Semester roll====== | |||
====== Use replace string with empty====== | |||
This will replace a section of the site with an empty string. | This will replace a section of the site with an empty string. | ||
====== Start index====== | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
====== Length====== | |||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
=== | ==== Drive ==== | ||
[[File:Googleappsdrive.png|none|thumb|720x720px]] | [[File:Googleappsdrive.png|none|thumb|720x720px]] | ||
''' | ===== Automation type===== | ||
<big>'''Full'''</big> | |||
Means that drive maintenance will be fully automated. | |||
===== <big>Remove learner method</big> ===== | |||
===== Deleted in AD ===== | |||
Users will be removed from drive when they are not active in UMS anymore | Users will be removed from drive when they are not active in UMS anymore | ||
===== Finished on activity/course ===== | |||
Users will be removed when they have finished with the course. | Users will be removed when they have finished with the course. | ||
===== <big>Delete drives</big> ===== | |||
'''Auto delete''' | |||
''' | |||
Drives will be delete when the last student has left the drive | Drives will be delete when the last student has left the drive | ||
''' | '''Manual Delete''' | ||
Drives will not be deleted by UMS. This has to be done by an administrator | Drives will not be deleted by UMS. This has to be done by an administrator | ||
===== Send mail to teacher(s) ===== | |||
Send mail notification to teachers when they are attached to a drive. | Send mail notification to teachers when they are attached to a drive. | ||
===== Create x days before ===== | |||
Choose how many days before start that the drives are to be created. | Choose how many days before start that the drives are to be created. | ||
===== Delete x days after end ===== | |||
Choose how many days after end that the drives are to be deleted. | Choose how many days after end that the drives are to be deleted. | ||
===== Teacher rights on drives ===== | |||
Rights the teacher will have on the drive when attached. | Rights the teacher will have on the drive when attached. | ||
===== Learner rights on drives ===== | |||
Rights the student/learner will have on the drive when attached. | Rights the student/learner will have on the drive when attached. | ||
===== SQL Groups ===== | |||
Members of these groups will be attached to all drives created with this setting as teachers | Members of these groups will be attached to all drives created with this setting as teachers | ||
[[File:Googleappssqlgroups.png|none|thumb|458x458px]] | [[File:Googleappssqlgroups.png|none|thumb|458x458px]] | ||
====== Group name ====== | |||
This can only be a group that is found in UMS | This can only be a group that is found in UMS | ||
Line 361: | Line 283: | ||
Select Distinct Aktivitet As Activity From Students Order By Activity | Select Distinct Aktivitet As Activity From Students Order By Activity | ||
===== Activity Drives ===== | |||
''' | '''Do not create''' | ||
It will not create any sites based on activities. | It will not create any sites based on activities. | ||
'''LMS has to be checked''' | |||
''' | |||
The field Aktivitet_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set) | The field Aktivitet_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set) | ||
'''Based on template filter''' | |||
''' | |||
Create sites based on a filter that is specified per template. | Create sites based on a filter that is specified per template. | ||
[[File:Googleappsactivitysites.png|none|thumb|493x493px]] | [[File:Googleappsactivitysites.png|none|thumb|493x493px]] | ||
''' | '''All''' | ||
Create all drives. | Create all drives. | ||
===== Description ===== | |||
Description of the drive. Changing this after a drive has been created will cause it to be updated. | Description of the drive. Changing this after a drive has been created will cause it to be updated. | ||
===== Search filter and criteria ===== | |||
This will enable you to concatenate drives that would have been created as to or more drives to be created as one drive. | This will enable you to concatenate drives that would have been created as to or more drives to be created as one drive. | ||
[[File:Googleappssearchfilters.png|none|thumb|401x401px]] | [[File:Googleappssearchfilters.png|none|thumb|401x401px]] | ||
====== Remarks ====== | |||
This is just for description purposes. | This is just for description purposes. | ||
====== Filter ====== | |||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | ||
====== Semester roll ====== | |||
====== Use replace string with empty ====== | |||
This will replace a section of the drive with an empty string. | This will replace a section of the drive with an empty string. | ||
====== Start index ====== | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
====== Length ====== | |||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
====== Add activity short description to node ID ====== | |||
This will add the field Kort_Betegnelse (Short Description) from the students table to the node id. | This will add the field Kort_Betegnelse (Short Description) from the students table to the node id. | ||
Node id is the URL. | Node id is the URL. | ||
'''Examples''' | '''Examples''' | ||
Line 435: | Line 339: | ||
This filter ensures that it is only applied to activities that matches this SQL sentence. | This filter ensures that it is only applied to activities that matches this SQL sentence. | ||
'''Course Drives''' | |||
''' | |||
Course URL’s will always be created as “activity_course”. | Course URL’s will always be created as “activity_course”. | ||
'''Do not create''' | |||
''' | |||
It will not create any drives based on courses. | It will not create any drives based on courses. | ||
'''LMS has to be checked''' | |||
''' | |||
The field Skolefag_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set) | The field Skolefag_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set) | ||
'''Based on template filter''' | |||
''' | |||
Create drives based on a filter that is specified per template. | Create drives based on a filter that is specified per template. | ||
[[File:Googleappsactivitysites.png|none|thumb|493x493px]] | [[File:Googleappsactivitysites.png|none|thumb|493x493px]] | ||
''' | '''All''' | ||
Create all drives. | Create all drives. | ||
Line 469: | Line 369: | ||
[[File:Googleappsseachfilters3.png|none|thumb|427x427px]] | [[File:Googleappsseachfilters3.png|none|thumb|427x427px]] | ||
''' | '''Remarks''' | ||
This is just for description purposes. | This is just for description purposes. | ||
''' | '''Course Filter''' | ||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll. | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll. | ||
''' | '''Semester roll''' | ||
''' | '''Use replace string with empty''' | ||
This will replace a section of the drive with an empty string. | This will replace a section of the drive with an empty string. | ||
'''Start index''' | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
''' | '''Length''' | ||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
''' | '''Activity Filter''' | ||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | ||
''' | '''Semester roll''' | ||
''' | '''Use replace string with empty''' | ||
This will replace a section of the drive with an empty string. | This will replace a section of the drive with an empty string. | ||
'''Start index''' | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
''' | '''Length''' | ||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
==== Classroom ==== | |||
There can only be a maximum of 990 classrooms in total in one organization. | There can only be a maximum of 990 classrooms in total in one organization. | ||
Line 519: | Line 419: | ||
[[File:Googleappsclassroomsettings.png|none|thumb|720x720px]] | [[File:Googleappsclassroomsettings.png|none|thumb|720x720px]] | ||
' | ===== Automation type'===== | ||
Full: Means that classroom maintenance will be fully automated. | Full: Means that classroom maintenance will be fully automated. | ||
''' | ===== Remove learner method ===== | ||
'''Deleted in AD''' | |||
Users will be removed from classroom when they are not active in UMS anymore | Users will be removed from classroom when they are not active in UMS anymore | ||
'''Finished on activity/course''' | |||
Users will be removed when they have finished with the course. | Users will be removed when they have finished with the course. | ||
''' | ===== Delete classrooms ===== | ||
'''Auto delete''' | |||
Classrooms will be delete when the last student has left the classroom | Classrooms will be delete when the last student has left the classroom | ||
'''Manual Delete''' | |||
Classrooms will not be deleted by UMS. This has to be done by an administrator | Classrooms will not be deleted by UMS. This has to be done by an administrator | ||
===== Send mail to teacher(s) ===== | |||
Send mail notification to teachers when they are attached to a classroom. | Send mail notification to teachers when they are attached to a classroom. | ||
===== Create x days before ===== | |||
Choose how many days before start that the classroom s are to be created. | Choose how many days before start that the classroom s are to be created. | ||
===== Delete x days after end ===== | |||
Choose how many days after end that the classroom s are to be deleted. | Choose how many days after end that the classroom s are to be deleted. | ||
===== SQL Groups ===== | |||
Members of these groups will be attached to all classrooms created with this setting as teachers | Members of these groups will be attached to all classrooms created with this setting as teachers | ||
[[ | [[File:Googleappssqlgroups.png|none|thumb|458x458px]] | ||
====== Group name ====== | |||
This can only be a group that is found in UMS | This can only be a group that is found in UMS | ||
You get a list of these groups by running this SQL command: | You get a list of these groups by running this SQL command: | ||
Select Distinct Aktivitet As Activity From Students Order By Activity | |||
===== Activity Classrooms ===== | |||
'''Do not create''' | |||
''' | |||
It will not create any sites based on activities. | It will not create any sites based on activities. | ||
''' | '''LMS has to be checked''' | ||
The field Aktivitet_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set) | The field Aktivitet_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set) | ||
''' | '''Based on template filter''' | ||
Create sites based on a filter that is specified per template. | Create sites based on a filter that is specified per template. | ||
[[ | [[File:Googleappsactivitysites.png|none|thumb|493x493px]] | ||
''' | '''All''' | ||
Create all classrooms. | Create all classrooms. | ||
====== Description ====== | |||
Description of the classroom. Changing this after a classroom has been created will cause it to be updated. | Description of the classroom. Changing this after a classroom has been created will cause it to be updated. | ||
===== Search filter and criteria ===== | |||
This will enable you to concatenate classrooms that would have been created as to or more classrooms to be created as one classroom. | This will enable you to concatenate classrooms that would have been created as to or more classrooms to be created as one classroom. | ||
[[ | [[File:Googleappssearchfilters.png|none|thumb|401x401px]] | ||
====== Remarks ====== | |||
This is just for description purposes. | This is just for description purposes. | ||
====== Filter ====== | |||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | ||
====== Semester roll ====== | |||
====== Use replace string with empty ====== | |||
This will replace a section of the classroom with an empty string. | This will replace a section of the classroom with an empty string. | ||
====== Start index ====== | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
====== Length ====== | |||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
====== Add activity short description to node ID ====== | |||
This will add the field Kort_Betegnelse (Short Description) from the students table to the node id. | This will add the field Kort_Betegnelse (Short Description) from the students table to the node id. | ||
Line 629: | Line 511: | ||
Set the settings as shown below | Set the settings as shown below | ||
[[ | [[File:Googleappsseachfilters2.png|none|thumb|413x413px]] | ||
This filter ensures that it is only applied to activities that matches this SQL sentence. | This filter ensures that it is only applied to activities that matches this SQL sentence. | ||
===== Course Classrooms ===== | |||
Course URL’s will always be created as “activity course”. | Course URL’s will always be created as “activity course”. | ||
''' | '''Do not create''' | ||
It will not create any classrooms based on courses. | It will not create any classrooms based on courses. | ||
''' | '''LMS has to be checked''' | ||
The field Skolefag_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set) | The field Skolefag_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set) | ||
''' | '''Based on template filter''' | ||
Create classrooms based on a filter that is specified per template. | Create classrooms based on a filter that is specified per template. | ||
[[ | [[File:Googleappsactivitysites.png|none|thumb|493x493px]] | ||
''' | '''All''' | ||
Create all classrooms. | Create all classrooms. | ||
====== Description ====== | |||
Description of the classroom. Changing this after a classroom has been created will cause it to be updated. | Description of the classroom. Changing this after a classroom has been created will cause it to be updated. | ||
===== Search filter and criteria ===== | |||
This will enable you to concatenate classrooms that would have been created as two or more classrooms to be created as one classroom. | This will enable you to concatenate classrooms that would have been created as two or more classrooms to be created as one classroom. | ||
[[ | [[File:Googleappsseachfilters3.png|none|thumb|427x427px]] | ||
====== Remarks ====== | |||
This is just for description purposes. | This is just for description purposes. | ||
====== Course Filter ====== | |||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll. | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll. | ||
====== Semester roll ====== | |||
====== Use replace string with empty ====== | |||
This will replace a section of the classroom with an empty string. | This will replace a section of the classroom with an empty string. | ||
====== Start index ====== | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
====== Length ====== | |||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
====== Activity Filter ====== | |||
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll | ||
====== Semester roll ====== | |||
====== Use replace string with empty ====== | |||
This will replace a section of the classroom with an empty string. | This will replace a section of the classroom with an empty string. | ||
====== Start index ====== | |||
Determine where to start in string to remove. | Determine where to start in string to remove. | ||
====== Length ====== | |||
How many characters will be removed from the string. | How many characters will be removed from the string. | ||
=== Organization Settings === | |||
When creating Google API refer to this lInk | When creating Google API refer to this lInk | ||
[[Google app API|http://wiki.inlogic.dk/index.php/Google_app_API]] [[File:Googleappsorganizationsettings.png|none|thumb|378x378px]] | [[Google app API|http://wiki.inlogic.dk/index.php/Google_app_API]] [[File:Googleappsorganizationsettings.png|none|thumb|378x378px]] | ||
''' | '''Description''' | ||
Add a description to be able to identify the account. | Add a description to be able to identify the account. | ||
''' | '''Admin login''' | ||
Mail address of an administrative user | Mail address of an administrative user | ||
''' | '''Password''' | ||
Password for the admin login specified | Password for the admin login specified | ||
''' | '''Domain''' | ||
The google domain that is used. | The google domain that is used. | ||
''' | '''Client ID, Client Secret''' | ||
This is obtained when following the instructions in the PDF document | This is obtained when following the instructions in the PDF document | ||
''' | '''Refresh token''' | ||
This will be generated the first time google synchronization is started. If this is reset UMS will asked for it again when the next synchronization is run. | This will be generated the first time google synchronization is started. If this is reset UMS will asked for it again when the next synchronization is run. | ||
''' | '''Timetable Users''' | ||
This can be used when creating timetable blocks. Look in timetable documentation for this feature. | This can be used when creating timetable blocks. Look in timetable documentation for this feature. | ||
Line 741: | Line 611: | ||
[[File:Googleappstemplateeditor.png|none|thumb|687x687px]] | [[File:Googleappstemplateeditor.png|none|thumb|687x687px]] | ||
''' | '''Setting''' | ||
This is the setting described above | This is the setting described above | ||
''' | '''Organization setting''' | ||
Specify where the users are created | Specify where the users are created | ||
Line 771: | Line 641: | ||
A list of categories added to the site when creating it separated with a ; | A list of categories added to the site when creating it separated with a ; | ||
A category called UMS will be added | A category called UMS will be added as well. (This cannot be change) | ||
''' | '''SQL Groups''' | ||
Members of these groups will be attached to all sites created with this setting as teachers | Members of these groups will be attached to all sites created with this setting as teachers | ||
[[ | [[File:Googleappssqlgroups.png|none|thumb|458x458px]] | ||
''' | '''Group name''' | ||
This can only be a group that is found in UMS | This can only be a group that is found in UMS | ||
You get a list of these groups by running this SQL command: | You get a list of these groups by running this SQL command: | ||
Select Distinct Aktivitet As Activity From Students Order By Activity | |||
Select Distinct Aktivitet As Activity From Students Order By Activity | |||
'''Drive settings''' | '''Drive settings''' | ||
Settings used when creating drives from this template | Settings used when creating drives from this template | ||
''' | '''Careful, do not name any of these type of subfolders with the same name.''' | ||
[[File:GoogleApps Drive Settings.jpg|none|frame]] | |||
'''Path''' | |||
The path where the drives are created | The path where the drives are created | ||
'''Create user specific subfolder''' | '''Create user specific subfolder''' | ||
Can only be used with learner rights set to viewer. | |||
Create a folder for each student that is attached to each drive | Create a folder for each student that is attached to each drive | ||
Line 804: | Line 675: | ||
'''Create subfolder (Teacher Read/Write - Student Read)''' | '''Create subfolder (Teacher Read/Write - Student Read)''' | ||
Can only be used with learner rights set to viewer. | |||
A folder where teachers can upload data that students can only read | A folder where teachers can upload data that students can only read | ||
Line 812: | Line 685: | ||
'''Create subfolder (Teacher Read/Write - Student Read/Write)''' | '''Create subfolder (Teacher Read/Write - Student Read/Write)''' | ||
Can only be used with learner rights set to viewer. | |||
A folder where teachers and students can share data both with read/write | A folder where teachers and students can share data both with read/write | ||
Line 822: | Line 697: | ||
[[File:Googleappsstudents.png|none|thumb|279x279px]] | [[File:Googleappsstudents.png|none|thumb|279x279px]] | ||
''' | '''SQL Groups''' | ||
Members of these groups will be attached to all sites created with this setting as teachers | Members of these groups will be attached to all sites created with this setting as teachers | ||
[[ | [[File:Googleappssqlgroups.png|none|thumb|458x458px]] | ||
''' | '''Group name''' | ||
This can only be a group that is found in UMS | This can only be a group that is found in UMS | ||
You get a list of these groups by running this SQL command: | You get a list of these groups by running this SQL command: | ||
Select Distinct Aktivitet As Activity From Students Order By Activity | |||
Select Distinct Aktivitet As Activity From Students Order By Activity | |||
'''Classroom settings''' | '''Classroom settings''' | ||
Settings used when creating classrooms from this template | Settings used when creating classrooms from this template | ||
[[File:Googleappsclassroomsettings2.png|none|thumb]] | [[File:Googleappsclassroomsettings2.png|none|thumb]] S'''QL Groups''' | ||
''' | |||
Members of these groups will be attached to all sites created with this setting as teachers | Members of these groups will be attached to all sites created with this setting as teachers | ||
[[ | [[File:Googleappssqlgroups.png|none|thumb|458x458px]] | ||
''' | '''Group name''' | ||
This can only be a group that is found in UMS | This can only be a group that is found in UMS | ||
You get a list of these groups by running this SQL command: | You get a list of these groups by running this SQL command: | ||
Select Distinct Aktivitet As Activity From Students Order By Activity | |||
Select Distinct Aktivitet As Activity From Students Order By Activity | |||
==Installation G Suite Sync== | ==Installation G Suite Sync== | ||
Steps to make UMS sync work with G Suite. | Steps to make UMS sync work with G Suite. | ||
Log on | Log on https://console.developers.google.com with your Google Admin account. | ||
[[Google app API]] | |||
[[ | |||
Go to the UMS “usermanagement folder” and run “GoogleApps_Sync.exe” manually. | Go to the UMS “usermanagement folder” and run “GoogleApps_Sync.exe” manually. |
Latest revision as of 12:11, 13 June 2024
UMS integrates to G Suite with the module G Suite Sync which:
- Creates users and their e-mail accounts
- Maintains users in G Suite, i.e. data changes are synchronised to UMS
- Synchronises passwords
- Deletes users who no longer attend the school
Integration to G Suite quickly becomes profitable. With UMS, the school saves resources by automating many manual tasks
- Avoid having to program scripts to synchronise the data
- Users are automatically created with data from your student administration system
- It reduces the workload for the IT-department
Prerequisites
Module requirements
Installation
Organization settings
See description how to create/setup further down this page
Users
Mail Alias
Choose what to use as the users mail address (login).
Disable users
When marked the users will be disabled when they are no longer attending classes.
Delete users
Choose if users are to be deleted after grace period has ended.
Forward mail to on premise mail server
This will forward the users Google mail to the primary mail address from AD (If user does not have a proxy address it will read it from the mail attribute)
Keep inactive before deleting x days
Specify a grace period where users are disabled.
Distribution lists
Maintain lists
Mark this to create distribution groups in Google. The groups will be created, updated and deleted if this is specified.
Delete lists
Mark this to delete distributions groups when they are no longer active in the administrative system. Check the data export manuals too when this happens
Delete unused lists after x days
Specify in days how long the distribution groups are to be kept alive in Google before deletion.
Template security groups
Maintain
This will create the security group entered in the field “template security group” in the destination node in the template settings.
Timetable
Maintain
Mark this to create timetable blocks in Google Apps. They will be created, updated and deleted.
Delete old
Mark this to delete old timetable blocks from calendars.
Site
Automation type
Full
Means that site maintenance will be fully automated.
Remove learner method
Deleted in AD
Users will be removed from site when they are not active in UMS anymore
Finished on activity/course
Users will be removed when they have finished with the course.
Delete sites
Auto delete
Sites will be delete when the last student has left the site
Manual Delete
Sites will not be deleted by UMS. This has to be done by an administrator
Send mail to teacher(s)
Send mail notification to teachers when they are attached to a site.
Create x days before
Choose how many days before start that the sites are to be created.
Delete x days after end
Choose how many days after end that the sites are to be deleted.
Teacher rights on sites
Rights the teacher will have on the site when attached.
Learner rights on sites
Rights the student/learner will have on the site when attached.
SQL Groups
Members of these groups will be attached to all sites created with this setting as teachers
Group name
This can only be a group that is found in UMS
You get a list of these groups by running this SQL command:
Select Distinct Aktivitet As Activity From Students Order By Activity
Activity Sites
Do not create
It will not create any sites based on activities.
LMS has to be checked
The field Aktivitet_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set)
Based on template filter
Create sites based on a filter that is specified per template.
All
Create all sites.
Title
Title of the site. Changing this after a site has been created will cause it to be updated.
Description
Description of the site. Changing this after a site has been created will cause it to be updated.
Search filter and criteria
This will enable you to concatenate sites that would have been created as to or more sites to be created as one site.
Remarks
This is just for description purposes.
Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll
Semester roll
Use replace string with empty
This will replace a section of the site with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Add activity short description to node ID
This will add the field Kort_Betegnelse (Short Description) from the students table to the node id.
Node id is the URL.
Examples
If you have three activities named English1, English2, English3 and you only want one SharePoint site.
Set the settings as shown below
This filter ensures that it is only applied to activities that matches this SQL sentence.
Course Sites
Course URL’s will always be created as “Activity_Course”.
Do not create
It will not create any sites based on courses.
LMS has to be checked
The field Skolefag_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set)
Based on template filter
Create sites based on a filter that is specified per template.
All
Create all sites.
Title
Title of the site. Changing this after a site has been created will cause it to be updated.
Description
Description of the site. Changing this after a site has been created will cause it to be updated.
Search filter and criteria
This will enable you to concatenate sites that would have been created as two or more sites to be created as one site.
Remarks
This is just for description purposes.
Course Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll.
Semester roll
Use replace string with empty
This will replace a section of the site with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Activity Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll
Semester roll
Use replace string with empty
This will replace a section of the site with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Drive
Automation type
Full
Means that drive maintenance will be fully automated.
Remove learner method
Deleted in AD
Users will be removed from drive when they are not active in UMS anymore
Finished on activity/course
Users will be removed when they have finished with the course.
Delete drives
Auto delete
Drives will be delete when the last student has left the drive
Manual Delete
Drives will not be deleted by UMS. This has to be done by an administrator
Send mail to teacher(s)
Send mail notification to teachers when they are attached to a drive.
Create x days before
Choose how many days before start that the drives are to be created.
Delete x days after end
Choose how many days after end that the drives are to be deleted.
Teacher rights on drives
Rights the teacher will have on the drive when attached.
Learner rights on drives
Rights the student/learner will have on the drive when attached.
SQL Groups
Members of these groups will be attached to all drives created with this setting as teachers
Group name
This can only be a group that is found in UMS
You get a list of these groups by running this SQL command:
Select Distinct Aktivitet As Activity From Students Order By Activity
Activity Drives
Do not create
It will not create any sites based on activities.
LMS has to be checked
The field Aktivitet_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set)
Based on template filter
Create sites based on a filter that is specified per template.
All
Create all drives.
Description
Description of the drive. Changing this after a drive has been created will cause it to be updated.
Search filter and criteria
This will enable you to concatenate drives that would have been created as to or more drives to be created as one drive.
Remarks
This is just for description purposes.
Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll
Semester roll
Use replace string with empty
This will replace a section of the drive with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Add activity short description to node ID
This will add the field Kort_Betegnelse (Short Description) from the students table to the node id.
Node id is the URL.
Examples
If you have three activities named English1, English2, English3 and you only want one SharePoint drive.
Set the settings as shown below
This filter ensures that it is only applied to activities that matches this SQL sentence.
Course Drives
Course URL’s will always be created as “activity_course”.
Do not create
It will not create any drives based on courses.
LMS has to be checked
The field Skolefag_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set)
Based on template filter
Create drives based on a filter that is specified per template.
All
Create all drives.
Description
Description of the drive. Changing this after a drive has been created will cause it to be updated.
Search filter and criteria
This will enable you to concatenate drives that would have been created as two or more drives to be created as one drive.
Remarks
This is just for description purposes.
Course Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll.
Semester roll
Use replace string with empty
This will replace a section of the drive with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Activity Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll
Semester roll
Use replace string with empty
This will replace a section of the drive with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Classroom
There can only be a maximum of 990 classrooms in total in one organization.
Google designed features (Not UMS)
If a teacher leaves the school, the material that he has put into classrooms will be deleted as well.
If a user has too many classrooms it will be very slow for this user.
Automation type'
Full: Means that classroom maintenance will be fully automated.
Remove learner method
Deleted in AD
Users will be removed from classroom when they are not active in UMS anymore
Finished on activity/course
Users will be removed when they have finished with the course.
Delete classrooms
Auto delete
Classrooms will be delete when the last student has left the classroom
Manual Delete
Classrooms will not be deleted by UMS. This has to be done by an administrator
Send mail to teacher(s)
Send mail notification to teachers when they are attached to a classroom.
Create x days before
Choose how many days before start that the classroom s are to be created.
Delete x days after end
Choose how many days after end that the classroom s are to be deleted.
SQL Groups
Members of these groups will be attached to all classrooms created with this setting as teachers
Group name
This can only be a group that is found in UMS
You get a list of these groups by running this SQL command:
Select Distinct Aktivitet As Activity From Students Order By Activity
Activity Classrooms
Do not create
It will not create any sites based on activities.
LMS has to be checked
The field Aktivitet_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set)
Based on template filter
Create sites based on a filter that is specified per template.
All
Create all classrooms.
Description
Description of the classroom. Changing this after a classroom has been created will cause it to be updated.
Search filter and criteria
This will enable you to concatenate classrooms that would have been created as to or more classrooms to be created as one classroom.
Remarks
This is just for description purposes.
Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll
Semester roll
Use replace string with empty
This will replace a section of the classroom with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Add activity short description to node ID
This will add the field Kort_Betegnelse (Short Description) from the students table to the node id.
Node id is the URL.
Examples
If you have three activities named English1, English2, English3 and you only want one SharePoint classroom.
Set the settings as shown below
This filter ensures that it is only applied to activities that matches this SQL sentence.
Course Classrooms
Course URL’s will always be created as “activity course”.
Do not create
It will not create any classrooms based on courses.
LMS has to be checked
The field Skolefag_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set)
Based on template filter
Create classrooms based on a filter that is specified per template.
All
Create all classrooms.
Description
Description of the classroom. Changing this after a classroom has been created will cause it to be updated.
Search filter and criteria
This will enable you to concatenate classrooms that would have been created as two or more classrooms to be created as one classroom.
Remarks
This is just for description purposes.
Course Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll.
Semester roll
Use replace string with empty
This will replace a section of the classroom with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Activity Filter
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll
Semester roll
Use replace string with empty
This will replace a section of the classroom with an empty string.
Start index
Determine where to start in string to remove.
Length
How many characters will be removed from the string.
Organization Settings
When creating Google API refer to this lInk
http://wiki.inlogic.dk/index.php/Google_app_API
Description
Add a description to be able to identify the account.
Admin login
Mail address of an administrative user
Password
Password for the admin login specified
Domain
The google domain that is used.
Client ID, Client Secret
This is obtained when following the instructions in the PDF document
Refresh token
This will be generated the first time google synchronization is started. If this is reset UMS will asked for it again when the next synchronization is run.
Timetable Users
This can be used when creating timetable blocks. Look in timetable documentation for this feature.
Template Settings
This is where you specify which templates are synchronized with Google and how.
Setting
This is the setting described above
Organization setting
Specify where the users are created
Path
This is where all users is placed
Use this path when below 13 years of age
This is where users that are under 13 years is placed. If this is not specified everyone will be placed under the path setting. (This is helpful when it comes to Google+)
OU Description
The description that is set on the OU when it is created.
Site settings
Settings used when creating sites from this template
Site category
A list of categories added to the site when creating it separated with a ;
A category called UMS will be added as well. (This cannot be change)
SQL Groups
Members of these groups will be attached to all sites created with this setting as teachers
Group name
This can only be a group that is found in UMS
You get a list of these groups by running this SQL command:
Select Distinct Aktivitet As Activity From Students Order By Activity
Drive settings
Settings used when creating drives from this template
Careful, do not name any of these type of subfolders with the same name.
Path
The path where the drives are created
Create user specific subfolder
Can only be used with learner rights set to viewer.
Create a folder for each student that is attached to each drive
Suffix
A text string that is appended to the folder name
Create subfolder (Teacher Read/Write - Student Read)
Can only be used with learner rights set to viewer.
A folder where teachers can upload data that students can only read
Suffix
A text string that is appended to the folder name
Create subfolder (Teacher Read/Write - Student Read/Write)
Can only be used with learner rights set to viewer.
A folder where teachers and students can share data both with read/write
Suffix
A text string that is appended to the folder name
Example
SQL Groups
Members of these groups will be attached to all sites created with this setting as teachers
Group name
This can only be a group that is found in UMS
You get a list of these groups by running this SQL command:
Select Distinct Aktivitet As Activity From Students Order By Activity
Classroom settings
Settings used when creating classrooms from this template
SQL Groups
Members of these groups will be attached to all sites created with this setting as teachers
Group name
This can only be a group that is found in UMS
You get a list of these groups by running this SQL command:
Select Distinct Aktivitet As Activity From Students Order By Activity
Installation G Suite Sync
Steps to make UMS sync work with G Suite.
Log on https://console.developers.google.com with your Google Admin account.
Go to the UMS “usermanagement folder” and run “GoogleApps_Sync.exe” manually.
Login to Google using credentials from Google Organization settings.
When logged in succesfully, “Accept” the following
If you get a “This page can’t be displayed”
Do not be alarmed. The job has been activated and you can check your GoogleApps_Sync.log to confirm that the job has completed running.
Parameters
> GoogleApps_Sync.exe [<optional> Action]
Eg.
> GoogleApps_Sync.exe
> GoogleApps_Sync.exe UsersOnly
Parameter | Description |
---|---|
UsersOnly | Runs all the parameters in this table |
CreateLearners | |
CreateStaff | |
UpdateLearners | |
UpdateStaff | |
RenameLearners | Rename the learners with a new mail/Login |
RenameTeachers | Rename the teachers with a new mail/Login |
DeleteLearners | |
DeleteStaff | |
DisableLearners | |
EnableLearners | |
DisableStaff | |
EnableStaff | |
UpdateLearnerOU | Move the learners to the correct OU |
UpdateTeacherOU | Move the teachers to the correct OU |
UpdateTeacherMailForward | |
UpdateLearnerMailForward |
Parameter | Description |
---|---|
GroupsOnly | Runs all the parameters in this table |
CreateGroups | |
CleanUpGroups | |
AddTeachersToGroups | |
RemoveTeachersFromGroups | |
AddLearnersToGroups | |
RemoveLearnersFromGroups |
Parameter | Description |
---|---|
TemplateGroupsOnly | Runs all the parameters in this table |
RemoveUsersFromTemplateGroups | Remove users from template security groups |
AddUsers2TemplateGroups | Add users to template security groups |
DeleteTemplateGroups | Delete groups that are no longer template security groups |
Parameter | Description |
---|---|
WebSitesOnly | Runs all the parameters in this table |
AddSites2DB | Add new sites to UMS DB |
CreateSites | |
UpdateSites | |
DeleteSites | |
AddTeachers2Site | |
AddLearners2Site | |
DeleteTeachersWebSites | |
DeleteLearnersWebSites |
Parameter | Description |
---|---|
ClassroomOnly | Runs all the parameters in this table |
AddClassrooms2DB | Add new classrooms to UMS DB |
CreateClassrooms | |
UpdateClassrooms | |
DeleteClassrooms | |
AddTeachers2Classroom | |
AddLearners2Classroom | |
DeleteTeachersClassroom | |
DeleteLearnersClassroom |
Technical settings
FAQ
Why do I not get the drive/site created?
1. Activity
a. Is there a user on the activity with a primary template that has an office 365 setting attached
b. Is the flag Aktivitet_LMS = True
2. Course
a. Is there a user on the course with a primary template that has an office 365 setting attached
b. Is the flag Skolefag_LMS = True
CreateGroups Error
Get root folders [Inlogic_Alle 1e-elever]
(CreateGroups) Error Google.Apis.Requests.RequestError
Not Authorized to access this resource/api [403] Errors [ Message[Not Authorized to access this resource/api] Location[ - ] Reason[forbidden] Domain[global]
Get root folders
(CreateGroups) Error Google.Apis.Requests.RequestError
Not Authorized to access this resource/api [403]
Errors [ Message[Not Authorized to access this resource/api] Location[ - ] Reason[forbidden] Domain[global]
The reason why that error occurs is that the mail adr. is used by another group or user. Test by manually creating a group in google admin portal. The image below shows the error.
To correct this error: create a USER with the same email address and then delete it again. After this, it will be possible to create the Group.