Sva:

'''OBSOLETE - PRODUCT IS NOT LONGER AVAILABLE FOR SALE'''

Our OneNote Class Notebook integration is developed for schools, which want to avoid manual configuration and maintenance when using OneNote Class Notebook. The integration automatically extracts data from your student administration system and synchronizes it with OneNote Class Notebook, creating Notebooks for students and teachers. This makes it very easy to start using the learning tool in class. Once the configuration is done, teachers and students will get access to a wide range of useful tools. Your OneNote Class Notebooks can be created before the school year starts, giving teachers the opportunity to prepare themselves and upload materials at their own pace. If new students start after the school year has begun they too are automatically created and maintained in OneNote Class Notebook.

*It is not posible for teachers to Add/Remove other teachers, all maintenance must be done through the studyadministrative system such as Ludus, Lectio etc.
*Notebooks will be kept alive for students from study start to study end, ie. 3 years if they study at a Danish gymnasium.

==Prerequisites==

===Module requirements===
[[UMS]]

[[Office 365|Office 365 License]]

OneNote Class Notebook License

===Testing after setup===
Running Office 365 sync in UMS

===What to have ready===
!!REQUIRED!! Make App registration in Azure: [[MSGraphPermissions|Look here]]

===Is any physical item required===
No

===Should third party be contacted===
No

==Installation==
Check OneNote license is active, under "License Info"[[File:Onenotelicense.png|none|thumb|481x481px]]

Click on Office 365, Under SharePoint Setting click "Manage"
[[File:Onenotetemplateeditor.png|none|thumb|489x489px]]

Click Edit
[[File:Onenotetemplateedit.png|none|thumb|484x484px]]

” ''Office 365 SharePoint Site Settings''” Click on” manage''”''

” ''OneNote Class Notebook Settings''” Click on “add”
[[File:Onenoteclassnotebooksettings.png|none|thumb|538x538px]]

Fill the” Description”

Click on ”''Sections''” if UMS STANDARD is not selected
[[File:OneNotesections.png|none|thumb|476x476px]]
Sections must be filled out if you want other sections than those Inlogic sets Default.
[[File:OneNote Sections.png|none|thumb|447x447px]]

'''Use Name instead of title for Notebooks (Last part of URL)'''

This will make the title of the NoteBook be the same as the last part of the URL of the SharePoint site that the NoteBook is created in. It never changes unless this is unchecked.

'''Never update Notebook title after creation'''

The NoteBook will never update the title after it has been created, even though the SharePoint site changes title. it will be created with the title that SharePoint site has at createin time.

Remember to set "''OneNote Class Notebook Setting''" to "UMS OneNote

Closing All UMS Configurator window down.
[[File:Onenotesettings2.png|none|thumb|313x313px]]

Open CMD as admin.

Browser UserManagement folder.

Run “''LiveAtEdu_Sync.exe AddNotebooks2DB”''
[[File:Onenotecmd.png|none|thumb|573x573px]]

Open SQL (SSMS) and run a new Query (''Select NoteBookID, * From Office365SharePoint_Sites)'' Note NoteBookID is NULL.
[[File:Onenotesql.png|none|thumb|637x637px]]

AddNotebooks2sites, If SharePoint is available
[[File:Onenotecmd2.png|none|thumb|723x723px]]

Open SQL (SSMS) and run a new Query (''Select NoteBookID, * From Office365SharePoint_Sites'') Note NoteBookID is NULL.
[[File:Onenotesql2.png|none|thumb|614x614px]]

'''Open log file "LiveAtEdu_Sync.log" in the log you will see that all teams is first created and then students in the teams.'''

After "LiveAtEdu_Sync OneNoteClassNoteBookOnl" Note the NoteBookID is now complete.
[[File:Onenotesql3.png|none|thumb|670x670px]]

'''If sharepoint site missing'''

Click on Sharpoint
[[File:Onenotesharepoint.png|none|thumb|239x239px]]

Click on ”NEW” to create a new sharepoint sites
[[File:Onenotesharepointnew.png|none|thumb|534x534px]]
[[File:Onenotesharepointnew2.png|none|thumb|417x417px]]
TimeZone: Should be changed to match

Administrator: Is the user you are logged on with, you can check it by clicking on the icon

Double click on the newly created site
[[File:Onenotenewlycreatedsite.png|none|thumb|521x521px]]

Copy the Url
[[File:Onenotecopyurl.png|none|thumb|322x322px]]

Open UMS Configurator
[[File:Onenotetemplate.png|none|thumb|475x475px]]
Remember to use the right template

Click on Office365

Click on Manage

Click on Add

Fill out the Description field

Set the copied URL

Sections selected if requested otherwise than UMS default settings.

Open UMS Configurator

1. Click on Office 365

2. Click Manage and (Site Settings)

3. Select "Students" and click "Add"
[[File:Onenotesitesettings.png|none|thumb|509x509px]]

Click under” Organization ''setting” and choose the created field.''

''Select "LMS has to be Checked"''
[[File:Onenotesettings3.png|none|thumb|596x596px]]

Remember to ACTIVE the “office365 OneNote setting” and click OK
[[File:Onenoteoffice365.png|none|thumb|559x559px]]

Open CMD as admin''.''

Brows to UserManagement ''folder.''

Run ''"LiveAtEdu_Sync.exe AddNotebooks2DB"''
[[File:Onenotecmd4.png|none|thumb|556x556px]]

Open SQL SSMS and run a new query (Select NoteBookID, * From Office365OneNoteClassNotebook)

Notice the NoteBookID is NULL.
[[File:Onenotenotebookid.png|none|thumb|694x694px]]

Open CMD as admin.

Brows to UserManagement folder.

Run "LiveAtEdu_Sync.exe OneNoteClassNoteBookOnly" and open log file "LiveAtEdu_Sync.log" in the log you will see that all teams is first created and then students in the teams.
[[File:Onenote5.png|none|thumb|675x675px]]

==Technical settings==

==FAQ==

Itslearning

2019-06-21T12:47:29Z

Sva: /* FAQ */

Timetable

2019-06-21T10:17:25Z

Sva:

Skemabrikker.exe is a small sync job that needs to run when timetables has to be created, updated or deleted.

Example of timetable in UMS and Outlook:
[[File:Timetable in UMS and Outlook.png|none|thumb|600x600px]]

The following systems is supported

*Office 365
*Exchange
*GSuite 

==Parameters==

===Usage===
Skemabrikker.exe [<optional> System] [<optional> Action] [<optional> Mail] [<optional> StartDate] [<optional> EndDate] [<optional> Type [UMS | NonUMS | All]]

=====Help=====
Displays a microsoft forms with the different parameters. 

=====Applyrights=====
Only works for Exchange and Office365. Restores rights for a room if they have accidentally been deleted or changed. 

=====Systems=====
This parameter is used to define what system Skemabrikker.exe will populate the Timetables to. We currently support Timetable integration to these systems:

Exchange

Office 365

GSuite

[[Timetable/itslearning|Itslearning]] 

=====Action=====
find - Used to display the Timetables associated with the given [mail] parameter.

delete - Used to delete the Timetables associated with the given [mail] parameter.

update - Used to update the Timetables that needs to be updated that are associated with the given [mail] parameter. 

=====Mail=====
mail/UPN - This parameter used if the [action] parameter needs to affect a specific user.

Teachersonly - This parameter used if the [action] parameter needs to only affect teachers.

Studentsonly - This parameter used if the [action] parameter needs to only affect students.

Roomsonly - This parameter is used if the [action] parameter needs to only affect a given physical Classroom (When this parameter is used you need to add the ID for the given room ie. [Action] [Mail] 'Room_ID').

Activitiesonly - This parameter is used if the [action] parameter needs to only affect a given activity (When this parameter is used you need to add the ID for the given activity ie. [Action] [Mail] 'Activity_ID'). 

=====StartDate=====
This parameter is used in to define the start date in which the find, delete or update parameter will affect the timetables. The format for this parameter is dd-mm-yyyy. 

=====EndDate=====
This parameter is used in to define the end date in which the find, delete or update parameter will affect the timetables The format for this parameter is dd-mm-yyyy. 

=====Type=====
UMS - This parameter is used to define that the timetables has to have been generated by UMS will be affected.

NonUMS - This parameter is used to define that the timetables has to have not been generated by UMS will be affected.

All - This parameter is used to define that timetables both from UMS and non UMS will be affected. 

==External systems==

===[[Timetable/itslearning|itslearning]]===

===[[Timetable/Office365|Office 365]]===

===[[Timetable/GoogleGSuite|Google GSuite]]===

==FAQ==

====How do I find timetable blocks with skemabrikker.exe ?====
Example following the general parameters:
{| class="wikitable"
|skemabrikker.exe office365 find tea@umsacademic.onmicrosoft.com 12-05-2019 13-05-2019 All
|}
Inspect the skemabrikker.log. The long string value in the logfile refers to the ID in the table '''SkemaBrikkerSavedEntries_Students, SkemaBrikkerSavedEntries_Teachers, SkemaBrikkerSavedEntries_Rooms, SkemaBrikkerSavedEntries_Activities'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

====How do I find timetable blocks with SQL statements ?====
{| class="wikitable"
|select SkemaBrikkerNewEntries.*

From SkemaBrikkerNewEntries

Join SkemaBrikker_Students On SkemaBrikkerNewEntries.SkemaBegivenhed_ID = SkemaBrikker_Students.SkemaBegivenhed_ID And SkemaBrikkerNewEntries.SkemaBrikkerAdminServers_ID = SkemaBrikker_Students.SkemaBrikkerAdminServers_ID

And SkemaBrikkerNewEntries.Activity = SkemaBrikker_Students.Activity

Where

SkemaBrikker_Students.cpr In (Select Cpr from Students where studienr= 'xxxxxx')

and SkemaBrikkerNewEntries.Dato = '28-11-2018'

Order By RealStartDateTime
|}

==== How do I change format and content of timetable blocks in Outlook? ====
Open UMS Configurator, select Modules "TimeTable" and select your datasource, then edit Format And Content

Variables can be replaced as pictured below.
[[File:Timetable format and content.png|none|thumb|1152x1152px]]

File:Timetable format and content.png

2019-06-21T10:15:11Z

Sva:

Timetable format and content

File:Timetable in UMS and Outlook.png

2019-06-21T10:11:03Z

Sva:

Timetable in UMS and Outlook

Itslearning

2019-06-21T09:46:47Z

Sva: /* FAQ */

Our itslearning 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 itslearning with the same password they use to access the school’s IT-system. The itslearning 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===
[[UMS]]

===What to have ready===

*Request a test site from Its learning. It's learning will send username, password and URL for the test site.
*The user must be system Administrator on the test site.
*You must have itslearning give the rights to "'''manage Enterprise web services'''" for this administrative user
*As System Administrator will you have access to the following displayed on the image below

[[File:It's learing 1.png|none|thumb|755x755px]]

Make sure that "Manage API" is enabled, as shown in the image below
[[File:It's learing 2.png|none|thumb|753x753px]]

Click on "Manage Enterprise web services" as shown in the image below
[[File:It's learing 3.png|none|thumb|752x752px]]

Fill out in the following points, as shown in the image below.

*Title
*Username (If set to auto-generate, new username will be generated. If set to import, will username be imported from ums)
*Password (If set to auto-generate, new password will be generated. If set to import, will password be imported from ums)
*User profile data (choose which permerts should sync to it's learning)
*System to use must be set to IMS-Enterprise
*URL to service (copy url for it to be used later)
*Username (copy url for it to be used later)
*Password (copy url for it to be used later)

[[File:Capture.png|none|thumb|857x857px]]

==Installation==
Open UMS Configurator and go to Template > itslearning. Click the first manage button.
[[File:Itslearning Template.jpg|none|thumb|791x791px]]

You will now see an overview of your itslearning settings.
[[File:Itslearning Settings.jpg|none|thumb|556x556px]]

==itslearning settings==
[[File:Itslearning Settings Edit.jpg|none|thumb|751x751px]]
====Description====
Give the Site settings a name.

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

====Users====

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

This column will be used as the login.

=====Delete users=====
Delete the users when they are no longer active

=====Keep inactive before deleting=====
Wait this number of days before deleting inactive users

====Template security groups====
Check the box to create, update, and delete template security groups that has an itslearning setting attached.

====Upload student information====
Check these boxes to send and update information on students:

*Address
*Phone
*Mobile Phone
*Mail

====Upload employee information====
Check these boxes to send and update information on employees:

*Address
*Phone
*Mobile Phone
*Mail

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

====Course category====
The category is put on the site when it is created

====Activity sites====
See [[Site selection settings]]

====Course sites====
See [[Site selection settings]]

==Organization settings==
[[File:Itslearning Organization Settings.jpg|link=http://wiki.inlogic.dk/index.php/File:Itslearning%20Organization%20Settings.jpg|none|thumb|556x556px]]
[[File:Itslearning Organization Settings Edit.jpg|link=http://wiki.inlogic.dk/index.php/File:Itslearning%20Organization%20Settings%20Edit.jpg|none|thumb|449x449px]]
====Description====
Give your Organization setting a name.

====Username====
Type your username for API connection (contact itslearning to acquire your username or login as an admin on yourschool.itslearning.com, Manage IMS Enterprise web services).

====Password====
Type your password for API connection (contact itslearning to acquire your username or login as an admin on yourschool.itslearning.com, Manage IMS Enterprise web services).

====Source organization====
Type the source organization for API connection (contact itslearning to acquire the source organization).

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

====Organization API Client ID====
Only relevant if you have a contract with itslearning that allows synchronization of timetableblocks

====Organization API Client secret====
Only relevant if you have a contract with itslearning that allows synchronization of timetableblocks

====Use test installation====
Enable this to use a test installation instead of production.

====Installation ID====
This is an ID you set in UMS to specify the multiple organization settings belong to the same itslearning installation.

itslearning installations that has the same URL should normally have the same ID in UMS.
===Sub accounts===
This section explains how to create a hierarchy in itslearning. [[File:Itslearning Sub accounts.jpg|none|thumb|620x620px]]

====Description====
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====
Select a column from the students table use the contents of that column to build the hierarchy.

====SQL Criteria====
Select only rows that match the SQL sentence. If left blank there are no criteria.

====Example of how UMS will build a hierarchy====

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

All template security groups will be created in 'UMS Template Groups'.

[[File:Itslearning hierarchy.jpg|none|thumb|1263x1263px]]

===Sub accounts Courses===
This section explains how to create a hierarchy in itslearning. [[File:Itslearning Sub accounts.jpg|none|thumb|620x620px]]

====Description====
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====
Select a column from the students table use the contents of that column to build the hierarchy.

====Database field (Displayname)====
Select a column from the students table use the contents of that column as title in the hierarchy. This is dependent on the "'''Database field'''".

====SQL Criteria====
Select only rows that match the SQL sentence. If left blank there are no criteria.

====Example of how UMS will build a hierarchy====

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

All courses that becomes inactive will be put in 'UMS Courses archive'.
[[File:Itslearning hierarchy Courses.jpg|none|thumb|1263x1263px]]

==Site Settings==
You need to attach a cohort setting to a template. This will tell UMS that cohorts will be created from this template.
[[File:Itslearning Site Template Settings.jpg|none|thumb|556x556px]]
[[File:Itslearning Site Template Settings Edit.jpg|none|thumb|422x422px]]

====Description====
Enter a description for this setting.

====Template====
Enter a template SyncKey that is used when creating courses.

if you are using a course that was created by UMS then remember to prefix the template name with UMSCourse_.

Validation rule: The course template SyncKey must exist, and must refer to a course template, not a regular course.

[https://developer.itslearning.com/Working_with_course_templates_in_IMS_ES.html Working_with_course_templates_in_IMS_ES]

====SQL Groups====
See [[LMS Settings]] for this option.

==Group Settings==
You need to attach a cohort setting to a template. This will tell UMS that cohorts will be created from this template.
[[File:Itslearning Group Template Settings.jpg|none|thumb|556x556px]]
[[File:Itslearning Group Template Settings Edit.jpg|none|thumb|422x422px]]
====Description====
Enter a description for this setting.

====Template====
This is not yet used.

Enter a template that is used when creating groups.

====SQL Groups====
See [[LMS Settings]] for this option.

==FAQ==

=== Is password synchronization between UMS and Itslearning supported? ===
Short answer: No

2019-06-05T09:57:39Z

Sva:

ExportUserInfoToAdminSystems.exe

=[[ExportUserInfoToAdminSystems/Lectio|Lectio]]=
=[[ExportUserInfoToAdminSystems/EASY-C|EASY-C]]=
=[[ExportUserInfoToAdminSystems/LUDUS|LUDUS]]=
=[[ExportUserInfoToAdminSystems/SIS|SIS]]=

ExportUserInfoToAdminSystems

2019-06-05T09:55:59Z

Sva: Created page with "ExportUserInfoToAdminSystems.exe =CampusNexus= =Lectio= =ExportUserInfoToAdminSystems/..."

ExportUserInfoToAdminSystems.exe

=[[ExportUserInfoToAdminSystems/CampusNexus|CampusNexus]]=
=[[ExportUserInfoToAdminSystems/Lectio|Lectio]]=
=[[ExportUserInfoToAdminSystems/EASY-C|EASY-C]]=
=[[ExportUserInfoToAdminSystems/LUDUS|LUDUS]]=
=[[ExportUserInfoToAdminSystems/Tabulex|Tabulex]]=
=[[ExportUserInfoToAdminSystems/Synergetic|Synergetic]]=
=[[ExportUserInfoToAdminSystems/Maze|Maze]]=
=[[ExportUserInfoToAdminSystems/Cases21|Cases21]]=
=[[ExportUserInfoToAdminSystems/Active_Directory|Active Directory]]=
=[[ExportUserInfoToAdminSystems/UNILogin|UNILogin]]=
=[[ExportUserInfoToAdminSystems/UDDATA|UDDATA]]=
=[[ExportUserInfoToAdminSystems/ITReg|ITReg]]=
=[[ExportUserInfoToAdminSystems/EduMate|EduMate]]=
=[[ExportUserInfoToAdminSystems/SEQTA|SEQTA]]=
=[[ExportUserInfoToAdminSystems/NemBoern|NemBoern]]=
=[[ExportUserInfoToAdminSystems/KMDElev|KMDElev]]=
=[[ExportUserInfoToAdminSystems/Navision|Navision]]=
=[[ExportUserInfoToAdminSystems/STADS|STADS]]=