Timetable: Difference between revisions
No edit summary |
No edit summary |
||
| Line 17: | Line 17: | ||
==External systems== | ==External systems== | ||
=== [[Timetable/itslearning|itslearning]] === | ===[[Timetable/itslearning|itslearning]]=== | ||
==FAQ== | ==FAQ== | ||
==== How do I find timetable blocks with skemabrikker.exe ? ==== | |||
To '''find''' all timetables generated by UMS for a user or for ie. every student use the following parameters with the skemabrikker.exe command. | To '''find''' all timetables generated by UMS for a user or for ie. every student use the following parameters with the skemabrikker.exe command. | ||
| Line 33: | Line 35: | ||
It is not recommended to run the '''office365 delete''' parameter with the '''All''' parameter since it will delete everything in the affected users calender's in the given time frame. | It is not recommended to run the '''office365 delete''' parameter with the '''All''' parameter since it will delete everything in the affected users calender's in the given time frame. | ||
==== 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= '159873') | |||
and SkemaBrikkerNewEntries.Dato = '28-11-2018' | |||
Order By RealStartDateTime | |||
|} | |||
<br /> | |||
Revision as of 08:21, 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
Usage
Skemabrikker.exe [<optional> System] [<optional> Action] [<optional> StartDate] [<optional> EndDate] [<optional> Type [UMS | NonUMS | All]]
Parameters
External systems
itslearning
FAQ
How do I find timetable blocks with skemabrikker.exe ?
To find all timetables generated by UMS for a user or for ie. every student use the following parameters with the skemabrikker.exe command.
Skemabrikker.exe office365 find <mail> <StartDate> <EndDate> [UMS | NonUMS | All]
By default the UMS parameter is selected, since there is generally no need to affect and look for items that wasn't generated by UMS. Instead of the <mail> parameter you can use AllTimeTableEmployees and AllTimeTableStudents to select either employees or students respectively.
To delete all timetables generated by UMS for a user or for ie. every student use the following parameters with the skemabrikker.exe command.
Skemabrikker.exe office365 delete <mail> <StartDate> <EndDate> [UMS | NonUMS | All]
By default the UMS parameter is selected, since there is generally no need to affect and look for items that wasn't generated by UMS. Instead of the <mail> parameter you can use AllTimeTableEmployees and AllTimeTableStudents to select either employees or students respectively.
It is not recommended to run the office365 delete parameter with the All parameter since it will delete everything in the affected users calender's in the given time frame.
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
SkemaBrikker_Students.cpr In (Select Cpr from Students where studienr= '159873') and SkemaBrikkerNewEntries.Dato = '28-11-2018' Order By RealStartDateTime |