Difference between revisions of "Timetable"

From UmsWiki
Jump to: navigation, search
m
Line 1: Line 1:
Skemabrikker.exe is a small sync job that needs to run when timetables has to be created, updated or deleted.
+
Skemabrikker.exe is a small sync job that needs to run when timetables are created, updated or deleted.
  
 
Example of timetable in UMS and Outlook:
 
Example of timetable in UMS and Outlook:
Line 5: Line 5:
  
  
The following systems is supported
+
The following systems are supported:
  
 
*Office 365
 
*Office 365
Line 17: Line 17:
  
 
=====Help=====
 
=====Help=====
Displays a microsoft forms with the different parameters.<br />
+
Displays Microsoft forms with the different parameters.<br />
  
 
=====Applyrights=====
 
=====Applyrights=====
Line 23: Line 23:
  
 
=====Systems=====
 
=====Systems=====
This parameter is used to define what system Skemabrikker.exe will populate the Timetables to. We currently support Timetable integration to these 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
 
Exchange
Line 34: Line 34:
  
 
=====Action=====
 
=====Action=====
find - Used to display the Timetables associated with the given [mail] parameter.
+
find - Used to display the timetables associated with the given [mail] parameter.
  
delete - Used to delete 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.<br />
+
update - Used to update the timetables that needs to be updated and are associated with the given [mail] parameter.<br />
  
 
=====Mail=====
 
=====Mail=====
mail/UPN - This parameter used if the [action] parameter needs to affect a specific user.
+
mail/UPN - This parameter is used if the [action] parameter needs to affect a specific user.
  
 
Teachersonly - This parameter used if the [action] parameter needs to only affect teachers.
 
Teachersonly - This parameter used if the [action] parameter needs to only affect teachers.
Line 101: Line 101:
 
|}
 
|}
  
==== How do I change format and content of timetable blocks in Outlook? ====
+
====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
 
Open UMS Configurator, select Modules "TimeTable" and select your datasource, then edit Format And Content
  

Revision as of 13:40, 3 July 2019

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

Example of timetable in UMS and Outlook:

Timetable in UMS and Outlook.png


The following systems are 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 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

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 and are associated with the given [mail] parameter.

Mail

mail/UPN - This parameter is 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

itslearning

Office 365

Google GSuite

FAQ

How do I find timetable blocks with skemabrikker.exe ?

Example following the general parameters:

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

Skemabrikkerlog.png

How do I find timetable blocks with SQL statements ?

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.

Timetable format and content.png