Timetable: Difference between revisions
No edit summary |
|||
| 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 has to be created, updated or deleted. | ||
The following systems is supported | The following systems is supported | ||
| Line 6: | Line 5: | ||
*Office 365 | *Office 365 | ||
*Exchange | *Exchange | ||
*GSuite | *GSuite<br /> | ||
<br /> | |||
==Parameters== | ==Parameters== | ||
| Line 16: | Line 13: | ||
=====Help===== | =====Help===== | ||
Displays a microsoft forms with the different parameters. | Displays a microsoft forms with the different parameters.<br /> | ||
<br /> | |||
=====Applyrights===== | =====Applyrights===== | ||
Only works for Exchange and Office365. Restores rights for a room if they have accidentally been deleted or changed. | Only works for Exchange and Office365. Restores rights for a room if they have accidentally been deleted or changed.<br /> | ||
<br /> | |||
=====Systems===== | =====Systems===== | ||
| Line 34: | Line 27: | ||
GSuite | GSuite | ||
[[Timetable/itslearning|Itslearning]] | [[Timetable/itslearning|Itslearning]]<br /> | ||
<br /> | |||
=====Action===== | =====Action===== | ||
| Line 43: | Line 34: | ||
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. | update - Used to update the Timetables that needs to be updated that are associated with the given [mail] parameter.<br /> | ||
<br /> | |||
=====Mail===== | =====Mail===== | ||
| Line 56: | Line 45: | ||
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'). | 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'). | 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').<br /> | ||
<br /> | |||
=====StartDate===== | =====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. | 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.<br /> | ||
<br /> | |||
=====EndDate===== | =====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. | 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.<br /> | ||
<br /> | |||
=====Type===== | =====Type===== | ||
| Line 80: | Line 63: | ||
===[[Timetable/itslearning|itslearning]]=== | ===[[Timetable/itslearning|itslearning]]=== | ||
Office 365 | |||
Google GSuite | |||
==FAQ== | ==FAQ== | ||
| Line 88: | Line 74: | ||
|skemabrikker.exe office365 find tea@umsacademic.onmicrosoft.com 12-05-2019 13-05-2019 All | |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 ''' | 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]] | [[File:Skemabrikkerlog.png|none|thumb|864x864px]] | ||
| Line 100: | Line 86: | ||
And SkemaBrikkerNewEntries.Activity = SkemaBrikker_Students.Activity | And SkemaBrikkerNewEntries.Activity = SkemaBrikker_Students.Activity | ||
Where | Where | ||
Revision as of 14:40, 13 May 2019
Skemabrikker.exe is a small sync job that needs to run when timetables has to be created, updated or deleted.
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
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/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
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
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 |