Timetable: Difference between revisions
| (13 intermediate revisions by 3 users not shown) | |||
| Line 14: | Line 14: | ||
===Usage=== | ===Usage=== | ||
Skemabrikker.exe [<optional> System] [<optional> Action] [<optional> Mail] [<optional> StartDate] [<optional> EndDate] [<optional> Type [UMS | NonUMS | All]] | > Skemabrikker.exe [<optional> System] [<optional> Action] [<optional> Mail] [<optional> StartDate] [<optional> EndDate] [<optional> Type [UMS | NonUMS | All]] | ||
Eg. | |||
> Skemabrikker.exe Office365 teachersonly | |||
> Skemabrikker.exe Office365 find tea@umsacademic.onmicrosoft.com 12-05-2019 13-05-2019 All | |||
====Applyrights==== | ====Applyrights==== | ||
| Line 27: | Line 28: | ||
Exchange | Exchange | ||
Office365 | |||
GoogleApps | |||
[[Timetable/itslearning|Itslearning]]<br /> | [[Timetable/itslearning|Itslearning]]<br /> | ||
=====Teachersonly===== | |||
This parameter is used if the [action] parameter needs to affect only teachers. | |||
=====Studentsonly===== | |||
This parameter is used if the [action] parameter needs to affect only students. | |||
=====Roomsonly===== | |||
This parameter is used if the [action] parameter needs to affect only 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'). | |||
=====Coursesonly===== | |||
This parameter is used if the [action] parameter needs to only affect a given course (When this parameter is used you need to add the ID for the given course ie. [Action] [Mail] 'Activity_ID_Course_ID'). | |||
====Action==== | ====Action==== | ||
delete | =====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. | |||
=====cleanup===== | |||
Used to find UMS appointments in users calendars and delete them if they are not found in UMS database. | |||
====Mail==== | ====Mail==== | ||
=====mail/UPN===== | |||
This parameter is used if the [action] parameter needs to affect a specific user. | |||
=====AllTimeTableStudents===== | |||
This will delete timetable blocks from all known students | |||
'''Works with''' | |||
Office 365 | |||
Exchange | |||
=====AllTimeTableEmployees===== | =====AllTimeTableEmployees===== | ||
This will | This will delete timetable blocks from all known employees | ||
{| class="wikitable" | |||
|+ | |||
!Eg : Skemabrikker.exe Office365 delete AllTimeTableEmployees 01-08-2022 31-09-2022 UMS | |||
|} | |||
'''Works with''' | |||
Office 365 | |||
Exchange | |||
=====AllTimeTableRooms===== | =====AllTimeTableRooms===== | ||
This will delete timetable blocks from all known | This will delete timetable blocks from all known rooms. | ||
'''Works with''' | |||
Office 365 | |||
====StartDate==== | ====StartDate==== | ||
This parameter is used 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. | This parameter is used 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==== | ====EndDate==== | ||
| Line 120: | Line 153: | ||
[[File:Timetable format and content.png|none|thumb|1152x1152px]] | [[File:Timetable format and content.png|none|thumb|1152x1152px]] | ||
<br /> | <br /> | ||
===Run only for one user=== | |||
====Students==== | |||
Skemabrikker.exe studentsonly <username> | |||
====Teachers==== | |||
Skemabrikker.exe teachersonly <username><br /> | |||
Latest revision as of 13:19, 29 August 2022
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:
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]]
Eg.
> Skemabrikker.exe Office365 teachersonly
> Skemabrikker.exe Office365 find tea@umsacademic.onmicrosoft.com 12-05-2019 13-05-2019 All
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
Office365
GoogleApps
Teachersonly
This parameter is used if the [action] parameter needs to affect only teachers.
Studentsonly
This parameter is used if the [action] parameter needs to affect only students.
Roomsonly
This parameter is used if the [action] parameter needs to affect only 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').
Coursesonly
This parameter is used if the [action] parameter needs to only affect a given course (When this parameter is used you need to add the ID for the given course ie. [Action] [Mail] 'Activity_ID_Course_ID').
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.
cleanup
Used to find UMS appointments in users calendars and delete them if they are not found in UMS database.
mail/UPN
This parameter is used if the [action] parameter needs to affect a specific user.
AllTimeTableStudents
This will delete timetable blocks from all known students
Works with
Office 365
Exchange
AllTimeTableEmployees
This will delete timetable blocks from all known employees
| Eg : Skemabrikker.exe Office365 delete AllTimeTableEmployees 01-08-2022 31-09-2022 UMS |
|---|
Works with
Office 365
Exchange
AllTimeTableRooms
This will delete timetable blocks from all known rooms.
Works with
Office 365
StartDate
This parameter is used 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 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 that have been generated by UMS, will be effected.
NonUMS - This parameter is used to define that the timetables that have not been generated by UMS, will be effected.
All - This parameter is used to define that timetables both from UMS and non UMS, will be effected.
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 log file refers to the ID in the table SkemaBrikkerSavedEntries_Students, SkemaBrikkerSavedEntries_Teachers, SkemaBrikkerSavedEntries_Rooms, SkemaBrikkerSavedEntries_Activities.
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.
Run only for one user
Students
Skemabrikker.exe studentsonly <username>
Teachers
Skemabrikker.exe teachersonly <username>