UmsWiki - User contributions [en]

InLogic SMS Gateway

2023-03-17T10:49:29Z

Mej: /* Update/Install USB modeswitch */

==Important==
To be able to send SMS, the inLogic SMS Gateway requires GSM modems with USB interface. We recommend "HUAWEI LTE USB Stick Model: E3372".

===Hardware Compatibility List===
[http://consumer.huawei.com/en/mobile-broadband/e3531/specs/ Huawei E3531]

[http://consumer.huawei.com/en/mobile-broadband/e3372/ Huawei E3372] (inLogic's choice)

[http://consumer.huawei.com/lk/mobile-broadband/dongles/features/e3131-lk.htm Huawei E3131i]

[http://www.tp-link.com/la/products/details/cat-5090_MA260.html TP-Link MA260]

==Network Port Openings==

====TCP port openings from server to gateway. TCP port opening where UMS sms sever service run.====
{| class="wikitable"
!Port
!Usage
|-
|22
|SSH access
|-
|443
|HTTPS access
|}

====TCP port openings from gateway to server.====
{| class="wikitable"
!Port
!Usage
|-
|80
|HTTP access
|-
|443
|HTTPS access
|}

==Prepare Modem==
{|
![[File:20180516 104258-50%.jpg|none|thumb|800x800px]]
!Plug-in Modems

!
!
|-
|[[File:20180516 104358-50%.jpg|none|thumb|800x800px]]
|'''Plug-in Ethernet cable'''

'''Plug-in power cable'''
|
|
|-
|
|
|
|
|-
|
|
|
|
|}

==System Login==
Once the gateway is [[#Prepare Modem|prepared]] and booted, open a browser and go to http://192.168.1.2. Login through the 'Login' button in the top right corner.
[[File:Main Login button.png|none|thumb|1240x1240px]]
You will now see a login box where you can log in with with USERNAME: admin and PASSWORD: admin.
[[File:Login.png|none|thumb|1240x1240px]]

==Main Page==
After logging in, the system info page appears. This page shows the gateway's status.[[File:Main.png|none|thumb|1240x1240px]]
To open the menu, click on this icon: [[File:Foxbox menu button.png|frameless|23x23px]]
[[File:Main with menu.png|none|thumb|1240x1240px]]

==Network Configuration==
Click on menu tab 'Network config'.

Change the IP settings and press 'Save Configuration'. When you have saved your settings, [[InLogic SMS Gateway#Reboot|Reboot]] the gateway as instructed below in 'Modem Settings'.
[[File:Network Config.png|none|thumb|1240x1240px]]

==Modem Settings==

===Hostname and Frontend Settings===

====Hostname====
Open the menu and go to 'Modem Settings'.

Set 'Modem Hostname' as FQDN and save your changes. Your modem will now restart.[[File:Modem Settings Hostname.png|none|thumb|1240x1240px]]

====Frontend====
Open the menu and go to 'Modem Settings'.

If redirect is enable on iis set (HTTPS)

Change 'FrontEnd Address' to fit your configuration and save your settings.[[File:Modem Settings Frontend.png|none|thumb|1240x1240px]]

===Certificate Settings (https)===
Open the menu and go to 'Modem Settings'.

Click 'Choose File' and choose a .pfx certificate from your computer.

Entera a .pfx certificate password in the 'Certificate Password' field and click 'Save'.
[[File:Modem Settings Certificate.png|none|thumb|1240x1240px]]

===User Settings===
Open the menu and go to 'Modem Settings'.

The default admin user password is 'admin'. To change the default admin user password, write the new password in the 'Password' field just below the 'Username' field admin.

The default sendsms user password is 'sendsms'. To change the default sendsms user password, write the new password in the 'Password' field just below the 'Username' field sendsms.

Click 'Save' to confirm the password change.
[[File:Modem Settings User.png|none|thumb|1240x1240px]]

==Control Panel==
Open the menu and go to 'Control Panel'.

Here, you can see staus, as well as turn on and off, the SMS Engine.[[File:Control Panel.png|none|thumb|1240x1240px]]

==SMS==

===Inbox===
To see a log for incoming messages, open the menu and go to 'Inbox'.
[[File:Inbox.png|none|thumb|1240x1240px]]

===Outbox===
To see a log for outgoing messages, open the menu and go to 'Outbox'.
[[File:Outbox.png|none|thumb|1240x1240px]]

===Failed===
To see a log for failed messages, open the menu and go to 'Failed'.
[[File:Failed.png|none|thumb|1240x1240px]]
===Write New===
To write a new SMS, open the menu and go to 'Write New'.

Choose the modem you wish to send your message from in the drop down menu 'Outgoing channel'. If left blank, the system will choose the first available modem.

Enter the phone number you wish to send your SMS to in the 'To' field. Pleas note that international prefix is mandatory.

Write your message in the 'Message' field.

When you have finished, click 'Send'.[[File:Write New guide.png|none|thumb|1240x1240px]]

==Time Zone Settings==
Open the menu and go to 'Time Zone Settings'.

The NTP & Time Zone Settings is by default set to enable external NTP.

For internal NTP, uncheck the 'Enable External NTP' box and write a list of NTP servers separated by comma, in the 'Internal NTP' field.

To change your time zone, choose a time zone from the 'Time Zone' drop down menu.

Click 'Save' to change your settings.
[[File:Time Zone Settings.png|none|thumb|1240x1240px]]

==Tools==
Open the menu and go to 'Modem Settings'.

===Shell===
Use 'in browser' shell to change advanced settings.

Use with caution! Please note that if you make any changes without consulting us first, support will be charged accordingly with our hourly rate.
[[File:Modem Settings Shell.png|none|thumb|1240x1240px]]
===Root Settings===
Change of root password require putty.exe. Default root password can be requested from inlogic.

Use Putty.exe to connect to Inlogic Gateway, run command ''(sudo passwd root'') and follow the instructions on screen.
[[File:Modem Settings Root.png|none|thumb|1240x1240px]]

==Additional information==
Additional information about the product, users, and programs used in the tutorial.
====Usernames and passwords====
====SSH Clients====
{| class="wikitable"
|+A list of SSH Clients
!Program name
!URL
|-
|PuTTy
|https://www.putty.org/
|}

====Open source FTP Client====
{| class="wikitable"
|+A list of FTP clients
!Program name
!URL
|-
|WinSCP
|https://winscp.net/eng/index.php
|-
|FileZilla
|https://filezilla-project.org/
|}
==FAQ==

===Linux commands===

==== Update ubuntu ====
sudo apt-get update -y
sudo apt-get upgrade -y

====Update inLogic files and Database from command line====
rm -rf /mnt/Update/update
wget --no-check-certificate <nowiki>https://downloads.inlogic.dk/inlogicgatewaymodem/Update.zip</nowiki> -O /mnt/Update/Update.zip
unzip /mnt/Update/Update.zip -d /mnt/Update/update
chmod 777 /mnt/Update/update/mnt/flash/root/updateservice/update.sh
/mnt/Update/update/mnt/flash/root/updateservice/update.sh

'''Commands'''

*Commands shows Status of Apache (systemctl status apache2.service)
*update system ( apt-get udate apt-get update)

====Update/Install USB modeswitch====
sudo wget <nowiki>https://www.draisberghof.de/usb_modeswitch/usb-modeswitch-2.6.0.tar.bz2</nowiki> -O /tmp/usb-modeswitch-2.6.0.tar.bz2
sudo tar xvf /tmp/usb-modeswitch-2.6.0.tar.bz2 -C /tmp
sudo wget <nowiki>https://downloads.inlogic.dk/inlogicgatewaymodem/usb_modeswitch/usb_modeswitch_dispatcher.tcl</nowiki> -O /tmp/usb-modeswitch-2.6.0/usb_modeswitch_dispatcher.tcl
cd /tmp/usb-modeswitch-2.6.0
make;make install

====Update ubuntu from 18 to 20====
Use default answers when running these commands.
sudo sed -i 's/bionic/focal/g' /etc/apt/sources.list
sudo sed -i 's/bionic/focal/g' /etc/apt/sources.list.d/odroid.list
sudo apt-get update -y
sudo apt-get upgrade -y
sudo apt-get dist-upgrade -y

====How to change IP settings====

*nano /etc/netplan/01-netconf.yaml
*reboot

====Logs====

=====Log viewers=====

*tail
*tail -f (this is similar to using cmtrace in windows)
*nano
*vim

=====Log files=====

*/var/log/smstools/smsd.log
*/var/log/syslog
*/var/log/mysql/error.log
*/var/log/apache2/error.log

=====See USB devices=====

*lsusb

==Rest API==
Theres a REST API to use, to send messages from the inLogic SMS Gateway.

===Send SMS===
{| class="wikitable"
!Title
!
|-
|URL
|source/send_sms.php
|-
|Method
|POST
|-
|URL Parameters
|Username

Password

To

Message
|-
|Success Response
|200 - Success
Returns ID of send SMS
|-
|Error Response
|401 - Unauthorized
|-
|Error Resposne
|403 - Forbidden
|-
|Error Response
|500 - Internal server error
|-
|Sample Request
|source/send_sms.php?username=smsuser&pwd=testpassword123&from=ums&to=22446688&message=Dette er en test besked
|-
|Notes
|
|}

Example
curl -X POST <nowiki>https://modem.ums.dk/source/send_sms.php?username=</nowiki><USERNAME>&pwd=<PASSWORD>&from=ums&to=<RECIEPIENT>&message=<MESSAGE>

===Check SMS Status===
{| class="wikitable"
!Title
!
|-
|URL
|webservice/getstatus.php
|-
|Method
|POST
|-
|URL Parameters
|Username

Password

ID
|-
|Success Response
|200 - Success
Returns status of send SMS

ScheduledToSend = -1

OK = 0

OK_WithError = 1

InUMSQueue = 2

InModemQueue = 3

Failed = 4

IDNotFound = 5

SentViaMail = 100

FailedSendingViaMail = 101
|-
|Error Response
|401 - Unauthorized
|-
|Error Resposne
|403 - Forbidden
|-
|Error Response
|500 - Internal server error
|-
|Sample Request
|webservice/getstatus.php?=smsuser&pwd=testpassword123&id=1
|-
|Notes
|
|}

Example
curl -X POST https://modem.ums.dk/webservice/getstatus.php?username=<USERNAME>&pwd=<PASSWORD>&id=<ID>

InLogic SMS Gateway

2023-03-17T10:48:54Z

Mej: /* Update USB modeswitch */

==Important==
To be able to send SMS, the inLogic SMS Gateway requires GSM modems with USB interface. We recommend "HUAWEI LTE USB Stick Model: E3372".

===Hardware Compatibility List===
[http://consumer.huawei.com/en/mobile-broadband/e3531/specs/ Huawei E3531]

[http://consumer.huawei.com/en/mobile-broadband/e3372/ Huawei E3372] (inLogic's choice)

[http://consumer.huawei.com/lk/mobile-broadband/dongles/features/e3131-lk.htm Huawei E3131i]

[http://www.tp-link.com/la/products/details/cat-5090_MA260.html TP-Link MA260]

==Network Port Openings==

====TCP port openings from server to gateway. TCP port opening where UMS sms sever service run.====
{| class="wikitable"
!Port
!Usage
|-
|22
|SSH access
|-
|443
|HTTPS access
|}

====TCP port openings from gateway to server.====
{| class="wikitable"
!Port
!Usage
|-
|80
|HTTP access
|-
|443
|HTTPS access
|}

==Prepare Modem==
{|
![[File:20180516 104258-50%.jpg|none|thumb|800x800px]]
!Plug-in Modems

!
!
|-
|[[File:20180516 104358-50%.jpg|none|thumb|800x800px]]
|'''Plug-in Ethernet cable'''

'''Plug-in power cable'''
|
|
|-
|
|
|
|
|-
|
|
|
|
|}

==System Login==
Once the gateway is [[#Prepare Modem|prepared]] and booted, open a browser and go to http://192.168.1.2. Login through the 'Login' button in the top right corner.
[[File:Main Login button.png|none|thumb|1240x1240px]]
You will now see a login box where you can log in with with USERNAME: admin and PASSWORD: admin.
[[File:Login.png|none|thumb|1240x1240px]]

==Main Page==
After logging in, the system info page appears. This page shows the gateway's status.[[File:Main.png|none|thumb|1240x1240px]]
To open the menu, click on this icon: [[File:Foxbox menu button.png|frameless|23x23px]]
[[File:Main with menu.png|none|thumb|1240x1240px]]

==Network Configuration==
Click on menu tab 'Network config'.

Change the IP settings and press 'Save Configuration'. When you have saved your settings, [[InLogic SMS Gateway#Reboot|Reboot]] the gateway as instructed below in 'Modem Settings'.
[[File:Network Config.png|none|thumb|1240x1240px]]

==Modem Settings==

===Hostname and Frontend Settings===

====Hostname====
Open the menu and go to 'Modem Settings'.

Set 'Modem Hostname' as FQDN and save your changes. Your modem will now restart.[[File:Modem Settings Hostname.png|none|thumb|1240x1240px]]

====Frontend====
Open the menu and go to 'Modem Settings'.

If redirect is enable on iis set (HTTPS)

Change 'FrontEnd Address' to fit your configuration and save your settings.[[File:Modem Settings Frontend.png|none|thumb|1240x1240px]]

===Certificate Settings (https)===
Open the menu and go to 'Modem Settings'.

Click 'Choose File' and choose a .pfx certificate from your computer.

Entera a .pfx certificate password in the 'Certificate Password' field and click 'Save'.
[[File:Modem Settings Certificate.png|none|thumb|1240x1240px]]

===User Settings===
Open the menu and go to 'Modem Settings'.

The default admin user password is 'admin'. To change the default admin user password, write the new password in the 'Password' field just below the 'Username' field admin.

The default sendsms user password is 'sendsms'. To change the default sendsms user password, write the new password in the 'Password' field just below the 'Username' field sendsms.

Click 'Save' to confirm the password change.
[[File:Modem Settings User.png|none|thumb|1240x1240px]]

==Control Panel==
Open the menu and go to 'Control Panel'.

Here, you can see staus, as well as turn on and off, the SMS Engine.[[File:Control Panel.png|none|thumb|1240x1240px]]

==SMS==

===Inbox===
To see a log for incoming messages, open the menu and go to 'Inbox'.
[[File:Inbox.png|none|thumb|1240x1240px]]

===Outbox===
To see a log for outgoing messages, open the menu and go to 'Outbox'.
[[File:Outbox.png|none|thumb|1240x1240px]]

===Failed===
To see a log for failed messages, open the menu and go to 'Failed'.
[[File:Failed.png|none|thumb|1240x1240px]]
===Write New===
To write a new SMS, open the menu and go to 'Write New'.

Choose the modem you wish to send your message from in the drop down menu 'Outgoing channel'. If left blank, the system will choose the first available modem.

Enter the phone number you wish to send your SMS to in the 'To' field. Pleas note that international prefix is mandatory.

Write your message in the 'Message' field.

When you have finished, click 'Send'.[[File:Write New guide.png|none|thumb|1240x1240px]]

==Time Zone Settings==
Open the menu and go to 'Time Zone Settings'.

The NTP & Time Zone Settings is by default set to enable external NTP.

For internal NTP, uncheck the 'Enable External NTP' box and write a list of NTP servers separated by comma, in the 'Internal NTP' field.

To change your time zone, choose a time zone from the 'Time Zone' drop down menu.

Click 'Save' to change your settings.
[[File:Time Zone Settings.png|none|thumb|1240x1240px]]

==Tools==
Open the menu and go to 'Modem Settings'.

===Shell===
Use 'in browser' shell to change advanced settings.

Use with caution! Please note that if you make any changes without consulting us first, support will be charged accordingly with our hourly rate.
[[File:Modem Settings Shell.png|none|thumb|1240x1240px]]
===Root Settings===
Change of root password require putty.exe. Default root password can be requested from inlogic.

Use Putty.exe to connect to Inlogic Gateway, run command ''(sudo passwd root'') and follow the instructions on screen.
[[File:Modem Settings Root.png|none|thumb|1240x1240px]]

==Additional information==
Additional information about the product, users, and programs used in the tutorial.
====Usernames and passwords====
====SSH Clients====
{| class="wikitable"
|+A list of SSH Clients
!Program name
!URL
|-
|PuTTy
|https://www.putty.org/
|}

====Open source FTP Client====
{| class="wikitable"
|+A list of FTP clients
!Program name
!URL
|-
|WinSCP
|https://winscp.net/eng/index.php
|-
|FileZilla
|https://filezilla-project.org/
|}
==FAQ==

===Linux commands===

==== Update ubuntu ====
sudo apt-get update -y
sudo apt-get upgrade -y

====Update inLogic files and Database from command line====
rm -rf /mnt/Update/update
wget --no-check-certificate <nowiki>https://downloads.inlogic.dk/inlogicgatewaymodem/Update.zip</nowiki> -O /mnt/Update/Update.zip
unzip /mnt/Update/Update.zip -d /mnt/Update/update
chmod 777 /mnt/Update/update/mnt/flash/root/updateservice/update.sh
/mnt/Update/update/mnt/flash/root/updateservice/update.sh

'''Commands'''

*Commands shows Status of Apache (systemctl status apache2.service)
*update system ( apt-get udate apt-get update)

====Update/Install USB modeswitch====
sudo wget https://www.draisberghof.de/usb_modeswitch/usb-modeswitch-2.6.0.tar.bz2 -O /tmp/usb-modeswitch-2.6.0.tar.bz2
sudo tar xvf /tmp/usb-modeswitch-2.6.0.tar.bz2 -C /tmp
sudo wget https://downloads.inlogic.dk/inlogicgatewaymodem/usb_modeswitch/usb_modeswitch_dispatcher.tcl -O /tmp/usb-modeswitch-2.6.0/usb_modeswitch_dispatcher.tcl
cd /tmp/usb-modeswitch-2.6.0
make;make install

====Update ubuntu from 18 to 20====
Use default answers when running these commands.
sudo sed -i 's/bionic/focal/g' /etc/apt/sources.list
sudo sed -i 's/bionic/focal/g' /etc/apt/sources.list.d/odroid.list
sudo apt-get update -y
sudo apt-get upgrade -y
sudo apt-get dist-upgrade -y

====How to change IP settings====

*nano /etc/netplan/01-netconf.yaml
*reboot

====Logs====

=====Log viewers=====

*tail
*tail -f (this is similar to using cmtrace in windows)
*nano
*vim

=====Log files=====

*/var/log/smstools/smsd.log
*/var/log/syslog
*/var/log/mysql/error.log
*/var/log/apache2/error.log

=====See USB devices=====

*lsusb

==Rest API==
Theres a REST API to use, to send messages from the inLogic SMS Gateway.

===Send SMS===
{| class="wikitable"
!Title
!
|-
|URL
|source/send_sms.php
|-
|Method
|POST
|-
|URL Parameters
|Username

Password

To

Message
|-
|Success Response
|200 - Success
Returns ID of send SMS
|-
|Error Response
|401 - Unauthorized
|-
|Error Resposne
|403 - Forbidden
|-
|Error Response
|500 - Internal server error
|-
|Sample Request
|source/send_sms.php?username=smsuser&pwd=testpassword123&from=ums&to=22446688&message=Dette er en test besked
|-
|Notes
|
|}

Example
curl -X POST <nowiki>https://modem.ums.dk/source/send_sms.php?username=</nowiki><USERNAME>&pwd=<PASSWORD>&from=ums&to=<RECIEPIENT>&message=<MESSAGE>

===Check SMS Status===
{| class="wikitable"
!Title
!
|-
|URL
|webservice/getstatus.php
|-
|Method
|POST
|-
|URL Parameters
|Username

Password

ID
|-
|Success Response
|200 - Success
Returns status of send SMS

ScheduledToSend = -1

OK = 0

OK_WithError = 1

InUMSQueue = 2

InModemQueue = 3

Failed = 4

IDNotFound = 5

SentViaMail = 100

FailedSendingViaMail = 101
|-
|Error Response
|401 - Unauthorized
|-
|Error Resposne
|403 - Forbidden
|-
|Error Response
|500 - Internal server error
|-
|Sample Request
|webservice/getstatus.php?=smsuser&pwd=testpassword123&id=1
|-
|Notes
|
|}

Example
curl -X POST https://modem.ums.dk/webservice/getstatus.php?username=<USERNAME>&pwd=<PASSWORD>&id=<ID>

InLogic SMS Gateway

2023-03-17T10:45:25Z

Mej: /* Update inLogic files and Database from command line */

==Important==
To be able to send SMS, the inLogic SMS Gateway requires GSM modems with USB interface. We recommend "HUAWEI LTE USB Stick Model: E3372".

===Hardware Compatibility List===
[http://consumer.huawei.com/en/mobile-broadband/e3531/specs/ Huawei E3531]

[http://consumer.huawei.com/en/mobile-broadband/e3372/ Huawei E3372] (inLogic's choice)

[http://consumer.huawei.com/lk/mobile-broadband/dongles/features/e3131-lk.htm Huawei E3131i]

[http://www.tp-link.com/la/products/details/cat-5090_MA260.html TP-Link MA260]

==Network Port Openings==

====TCP port openings from server to gateway. TCP port opening where UMS sms sever service run.====
{| class="wikitable"
!Port
!Usage
|-
|22
|SSH access
|-
|443
|HTTPS access
|}

====TCP port openings from gateway to server.====
{| class="wikitable"
!Port
!Usage
|-
|80
|HTTP access
|-
|443
|HTTPS access
|}

==Prepare Modem==
{|
![[File:20180516 104258-50%.jpg|none|thumb|800x800px]]
!Plug-in Modems

!
!
|-
|[[File:20180516 104358-50%.jpg|none|thumb|800x800px]]
|'''Plug-in Ethernet cable'''

'''Plug-in power cable'''
|
|
|-
|
|
|
|
|-
|
|
|
|
|}

==System Login==
Once the gateway is [[#Prepare Modem|prepared]] and booted, open a browser and go to http://192.168.1.2. Login through the 'Login' button in the top right corner.
[[File:Main Login button.png|none|thumb|1240x1240px]]
You will now see a login box where you can log in with with USERNAME: admin and PASSWORD: admin.
[[File:Login.png|none|thumb|1240x1240px]]

==Main Page==
After logging in, the system info page appears. This page shows the gateway's status.[[File:Main.png|none|thumb|1240x1240px]]
To open the menu, click on this icon: [[File:Foxbox menu button.png|frameless|23x23px]]
[[File:Main with menu.png|none|thumb|1240x1240px]]

==Network Configuration==
Click on menu tab 'Network config'.

Change the IP settings and press 'Save Configuration'. When you have saved your settings, [[InLogic SMS Gateway#Reboot|Reboot]] the gateway as instructed below in 'Modem Settings'.
[[File:Network Config.png|none|thumb|1240x1240px]]

==Modem Settings==

===Hostname and Frontend Settings===

====Hostname====
Open the menu and go to 'Modem Settings'.

Set 'Modem Hostname' as FQDN and save your changes. Your modem will now restart.[[File:Modem Settings Hostname.png|none|thumb|1240x1240px]]

====Frontend====
Open the menu and go to 'Modem Settings'.

If redirect is enable on iis set (HTTPS)

Change 'FrontEnd Address' to fit your configuration and save your settings.[[File:Modem Settings Frontend.png|none|thumb|1240x1240px]]

===Certificate Settings (https)===
Open the menu and go to 'Modem Settings'.

Click 'Choose File' and choose a .pfx certificate from your computer.

Entera a .pfx certificate password in the 'Certificate Password' field and click 'Save'.
[[File:Modem Settings Certificate.png|none|thumb|1240x1240px]]

===User Settings===
Open the menu and go to 'Modem Settings'.

The default admin user password is 'admin'. To change the default admin user password, write the new password in the 'Password' field just below the 'Username' field admin.

The default sendsms user password is 'sendsms'. To change the default sendsms user password, write the new password in the 'Password' field just below the 'Username' field sendsms.

Click 'Save' to confirm the password change.
[[File:Modem Settings User.png|none|thumb|1240x1240px]]

==Control Panel==
Open the menu and go to 'Control Panel'.

Here, you can see staus, as well as turn on and off, the SMS Engine.[[File:Control Panel.png|none|thumb|1240x1240px]]

==SMS==

===Inbox===
To see a log for incoming messages, open the menu and go to 'Inbox'.
[[File:Inbox.png|none|thumb|1240x1240px]]

===Outbox===
To see a log for outgoing messages, open the menu and go to 'Outbox'.
[[File:Outbox.png|none|thumb|1240x1240px]]

===Failed===
To see a log for failed messages, open the menu and go to 'Failed'.
[[File:Failed.png|none|thumb|1240x1240px]]
===Write New===
To write a new SMS, open the menu and go to 'Write New'.

Choose the modem you wish to send your message from in the drop down menu 'Outgoing channel'. If left blank, the system will choose the first available modem.

Enter the phone number you wish to send your SMS to in the 'To' field. Pleas note that international prefix is mandatory.

Write your message in the 'Message' field.

When you have finished, click 'Send'.[[File:Write New guide.png|none|thumb|1240x1240px]]

==Time Zone Settings==
Open the menu and go to 'Time Zone Settings'.

The NTP & Time Zone Settings is by default set to enable external NTP.

For internal NTP, uncheck the 'Enable External NTP' box and write a list of NTP servers separated by comma, in the 'Internal NTP' field.

To change your time zone, choose a time zone from the 'Time Zone' drop down menu.

Click 'Save' to change your settings.
[[File:Time Zone Settings.png|none|thumb|1240x1240px]]

==Tools==
Open the menu and go to 'Modem Settings'.

===Shell===
Use 'in browser' shell to change advanced settings.

Use with caution! Please note that if you make any changes without consulting us first, support will be charged accordingly with our hourly rate.
[[File:Modem Settings Shell.png|none|thumb|1240x1240px]]
===Root Settings===
Change of root password require putty.exe. Default root password can be requested from inlogic.

Use Putty.exe to connect to Inlogic Gateway, run command ''(sudo passwd root'') and follow the instructions on screen.
[[File:Modem Settings Root.png|none|thumb|1240x1240px]]

==Additional information==
Additional information about the product, users, and programs used in the tutorial.
====Usernames and passwords====
====SSH Clients====
{| class="wikitable"
|+A list of SSH Clients
!Program name
!URL
|-
|PuTTy
|https://www.putty.org/
|}

====Open source FTP Client====
{| class="wikitable"
|+A list of FTP clients
!Program name
!URL
|-
|WinSCP
|https://winscp.net/eng/index.php
|-
|FileZilla
|https://filezilla-project.org/
|}
==FAQ==

===Linux commands===

==== Update ubuntu ====
sudo apt-get update -y
sudo apt-get upgrade -y

====Update inLogic files and Database from command line====
rm -rf /mnt/Update/update
wget --no-check-certificate <nowiki>https://downloads.inlogic.dk/inlogicgatewaymodem/Update.zip</nowiki> -O /mnt/Update/Update.zip
unzip /mnt/Update/Update.zip -d /mnt/Update/update
chmod 777 /mnt/Update/update/mnt/flash/root/updateservice/update.sh
/mnt/Update/update/mnt/flash/root/updateservice/update.sh

'''Commands'''

*Commands shows Status of Apache (systemctl status apache2.service)
*update system ( apt-get udate apt-get update)

====Update USB modeswitch====
sudo wget https://www.draisberghof.de/usb_modeswitch/usb-modeswitch-2.6.0.tar.bz2 -O /tmp/usb-modeswitch-2.6.0.tar.bz2
sudo tar xvf /tmp/usb-modeswitch-2.6.0.tar.bz2 -C /tmp
sudo wget https://downloads.inlogic.dk/inlogicgatewaymodem/usb_modeswitch/usb_modeswitch_dispatcher.tcl -O /tmp/usb-modeswitch-2.6.0/usb_modeswitch_dispatcher.tcl
cd /tmp/usb-modeswitch-2.6.0
make;make install

====Update ubuntu from 18 to 20====
Use default answers when running these commands.
sudo sed -i 's/bionic/focal/g' /etc/apt/sources.list
sudo sed -i 's/bionic/focal/g' /etc/apt/sources.list.d/odroid.list
sudo apt-get update -y
sudo apt-get upgrade -y
sudo apt-get dist-upgrade -y

====How to change IP settings====

*nano /etc/netplan/01-netconf.yaml
*reboot

====Logs====

=====Log viewers=====

*tail
*tail -f (this is similar to using cmtrace in windows)
*nano
*vim

=====Log files=====

*/var/log/smstools/smsd.log
*/var/log/syslog
*/var/log/mysql/error.log
*/var/log/apache2/error.log

=====See USB devices=====

*lsusb

==Rest API==
Theres a REST API to use, to send messages from the inLogic SMS Gateway.

===Send SMS===
{| class="wikitable"
!Title
!
|-
|URL
|source/send_sms.php
|-
|Method
|POST
|-
|URL Parameters
|Username

Password

To

Message
|-
|Success Response
|200 - Success
Returns ID of send SMS
|-
|Error Response
|401 - Unauthorized
|-
|Error Resposne
|403 - Forbidden
|-
|Error Response
|500 - Internal server error
|-
|Sample Request
|source/send_sms.php?username=smsuser&pwd=testpassword123&from=ums&to=22446688&message=Dette er en test besked
|-
|Notes
|
|}

Example
curl -X POST <nowiki>https://modem.ums.dk/source/send_sms.php?username=</nowiki><USERNAME>&pwd=<PASSWORD>&from=ums&to=<RECIEPIENT>&message=<MESSAGE>

===Check SMS Status===
{| class="wikitable"
!Title
!
|-
|URL
|webservice/getstatus.php
|-
|Method
|POST
|-
|URL Parameters
|Username

Password

ID
|-
|Success Response
|200 - Success
Returns status of send SMS

ScheduledToSend = -1

OK = 0

OK_WithError = 1

InUMSQueue = 2

InModemQueue = 3

Failed = 4

IDNotFound = 5

SentViaMail = 100

FailedSendingViaMail = 101
|-
|Error Response
|401 - Unauthorized
|-
|Error Resposne
|403 - Forbidden
|-
|Error Response
|500 - Internal server error
|-
|Sample Request
|webservice/getstatus.php?=smsuser&pwd=testpassword123&id=1
|-
|Notes
|
|}

Example
curl -X POST https://modem.ums.dk/webservice/getstatus.php?username=<USERNAME>&pwd=<PASSWORD>&id=<ID>

SSO

2023-01-16T08:09:56Z

Mej: Corrected spelling error on Set-AdfsSslCertificate -Thumbprint

[[File:Single-Sign-On-SSO-DK.png|thumb]]
Our Single Sign-on (SSO) module is designed for schools that would like to make it easy for employees and students to use the school's various electronic systems. With the SSO module, users get one login and password that logs them into all the associated services at once.

For example, students can Access the school's LMS system, library system, digital dictionaries and databases with scientific publications - all by signing in with SSO once and for all.

This saves time and effort whenever users need to use one of the school's systems. At the same time, it gives users a simpler everyday life because they do not have to worry about having to keep in mind several logins.

==Prerequisite and purpose==

===Prerequisite===
This requires that:

*An installed Active Directory federation services (AD FS) server.
*Access to configuration snap in. Either via Remote PowerShell or directly on the server.
*An UMS installation, licensed to SSO from inLogic.
*A star or new certificate for the address that the AD FS server needs.

===purpose===

==Installation==

===Installation===

==Change ADFS certificates in UMS==
The UMS server also needs the certificates from the ADFS server. This is done by consuming the metadata. ''You can use <nowiki>https://samlmd2cert.azurewebsites.net/</nowiki> to get the certificate files.'' 

When you have the new and updated certificates from ADFS it needs to be in rootfolder of the UMS Application.

Physical path (C:\inetpub\wwwroot).

And we need to update the records in the UMS database, if the name of the file has changed.
Update SSOSetting set PartnerCertificateFile = 'TheNameOfCertificate_signing.cer'
Where ID = <The id of the active setting>
It is the signing certificate the UMS needs from the ADFS.

Now delete the old certificate files from your UMS folder, do an iisreset to let the UMS resolve the newly entered information in the databse.

==Changing the Self Signed Certificate in SSO.==

#Get started by clicking on the house icon in the menu. Search for IIS and click on Internet Information Services (IIS) Manager.[[File:Sso iis manager.png|none|thumb]]
#In the Connections column on the left, click on the name of the server. Double-click on Server Certificates.[[File:IIS-Cert-1.png|none|thumb|497x497px]]
#In the Actions column on the right, click on Create Self-Signed Certificate.[[File:IIS-Cert-2.png|none|thumb|499x499px]]
#Enter any friendly name and then click OK.[[File:IIS-Cert-3.png|none|thumb|508x508px]]
#You will now have an IIS Self Signed Certificate valid for 1 year listed under Server Certificates.
#Right click on the new create certificate and then click '''Export.'''[[File:IIS-Cert-4.png|none|thumb|742x742px]]
#Remember to delete the old self signed certificate (C:\inetpub\wwwroot).[[File:IIS-Cert-5.png|none|thumb|573x573px]]
#Enter the path (C:\inetpub\wwwroot\UMS-SSO). The new password you type will be used later on when you set up your environment. Please remember this password. Click OK.[[File:IIS-Cert-8.png|none|thumb|771x771px]]
#Open SQl Management Studio and type “''select * from SSOSetting''”. You will see all settings for UMS SSO.
#Update the Certificate by typing “''update SSOSetting set LocalCertificateFile ='UMS-SSO.pfx''”
#Update the Password by typing “''update SSOSetting set LocalCertificatePassword ='Velk0mmen2018''”.[[File:IIS-Cert-9.png|none|thumb|781x781px]]
#Open the IIS Server and click Start. Click Run type IISReset and then click OK.[[File:IIS-Cert-10.png|none|thumb|377x377px]]
#Open the AD FS Server and search for AD FS. Click on AD FS Management.[[File:IIS-Cert-11.png|none|thumb|305x305px]]
#Click on the Trust Relationships folder and then click on Relying Party Trusts.
#In the details panel, click the relying party trust that you want to update from federation metadata.
#In the Action panel, click Update from Federation Metadata.
#In the properties dialog box for the trust, click Update to start the update.
#When the update is complete, click OK.[[File:IIS-Cert-12.png|none|thumb|745x745px]]

==Certificates - Update Service Communication Certificate==

===Things to have ready:===
A new updated certificate with private key - <file>.pfx

A connection to AD FS server, with administrator rights.

First install the certificate on the server, select my computer when asked.

Now go to AD FS -> Service -> Certificates -> Set Service Communications Certificate...

Now select "view more" -> And select the new certificate

[[File:ADFSChangeCertificate.png|1389x1389px]]

And now we need to set the certificate on the http.sys on adfs
Set-AdfsSslCertificate -Thumbprint xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Now go to Services and restart the AD FS Service

==Certificates - Automatic rollover==
Out of the box, ADFS generates two self-signed certificates that are good for one year. One certificate for token signing, and one for token encryption.

The token signing certificate is for signing the tokens used in the user sign on process, and it is considered the “bedrock of security” for ADFS. If someone gained access to this certificate (the public/private key pair), they could impersonate your ADFS environment.

The token decryption certificate is used for encrypting the tokens used in the user sign on process. This certificate isn’t used very often.

For more information about AD FS Certificates see https://blogs.technet.microsoft.com/askpfeplat/2015/01/26/adfs-deep-dive-certificate-planning/

===Token Certificate Validity Periods===
By default, ADFS is configured to generate self-signed token certificates with a duration of one year. This duration can be changed, but keep in mind that the token-signing certificate is the foundation of the sign on process, and therefore, it really shouldn’t have a duration longer than 3 years.

===ADFS Federation Metadata===
The public key portion of both certificates are included in the ADFS Federation Metadata, and are available from a public URL endpoint on all ADFS servers in the farm. Relying Party (RP) applications that can consume federation metadata will automatically pick up certificate changes whenever they pull the federation metadata file (FederationMetadata.xml) from your ADFS environment.

Example URL
<nowiki>https://adfs.contoso.com/FederationMetadata/2007-06/FederationMetadata.xml</nowiki>
Before performing a token certificate rollover, you will want to reach out to your RP partners (application owners) to see how often their application pulls the federation metadata so that they will experience little to no downtime before trusting the new certificates.

However, most applications do not automatically retrieve the federation metadata on a schedule. Instead, an application owner will need to import the federation metadata from an XML file, or manually force the application to retrieve the federation metadata from the URL endpoint.

And then there’s the applications that don’t consume federation metadata at all — they have to be manually updated. This means you will need to send the public key portion of the new certificates to the application owners.

===Certificate and Rollover Settings===
Run the following PowerShell command on the primary ADFS server to view the properties related to certificates:
Get-AdfsProperties | FL AutoCert*, Certificate*

===ADFS Properties Related to Certificate Renewal===
'''Auto Certificate Rollover'''

When the auto-rollover process is enabled (set to “True”), ADFS will automatically generate new “Secondary” certificates before the current ones expire, and then eventually promote them to be “Primary”. For a manual renewal process, this should be set to “False” until you’re ready to generate new “Secondary” certificates.

'''Certificate Generation Threshold'''

New certificates will be generated this number of days before the expiration of the current “Primary” certificates.

'''Certificate Promotion Threshold'''

Number of days the newly generated certificate will exist before being promoted from the “Secondary” certificate to the “Primary” certificate.

'''Certificate Critical Threshold'''

Number of days prior to expiry of the certificates before a new certificate is generated and promoted to the “Primary” certificate.

'''Certificate Duration'''

Validity period of the auto-generated certificates. Default is 1 year.

'''Certificate Rollover Interval'''

Number of minutes at which ADFS checks to see if a new certificate needs to be generated.

===Token Certificate Rollover Process===
There are 3 approaches for rolling over the token certificates. Which one to use will depend on the number of relying party trusts you have, the level of control you wish to exert upon the process, and the timing of the certificate expirations.

'''Automatic Staged Rollover'''

You would use this process when ADFS controls when the new self-signed token certificates are generated, and when they are promoted to become the “Primary” certificates.

'''Manual Staged Rollover'''

You would use this process to manually control when the new self-signed token certificates are generated, and when they are promoted to become the “Primary” certificates.

'''Immediate Manual Rollover'''

Think of this as a certificate cut-over process. You would do this if you wanted to roll over your certificates immediately without having a set of primary and secondary certificates. You would also do this if your current certificates expired and you need to renew immediately.

Keep in mind that there will be outage when Token certificates are immediately generated & promoted. The relying parties (application owners) must update their configuration with the new certificates, but until they do so, single sign-on will not work.

===Automatic Staged Rollover===
This process should only be used if you have already communicated to all your relying party application owners with information about the schedule for which the new certificates will be generated, when they will be promoted to the “Primary” certificate, and when the old certificates will expire.

Note that an ADFS administrator will need to export the public portion of the new certificates and send them to the application owners.

Additionally, you can use this process if all of the relying party applications pull your ADFS federation metadata automatically on a schedule. However, this is very rare because most SaaS providers do not want to incur the expense of querying federation metadata changes for hundreds, thousands, or even millions of endpoints. More than likely, you will need to coordinate with the application owners to update their applications.

Permissions: Domain Admin & Local Admin on the primary ADFS server in the farm.

Step 1: Certificate Duration

Set the number of days that will become the validity period of the new self-signed token certificates.

*1 Year: 365
*3 Years: 1095
*5 Years: 1827

Set-ADFSProperties -CertificateDuration 1095
Step 2: Certificate Generation Threshold

Set the number of days before the expiration date of the current certificates that ADFS should generate the new certificates. Thirty days is usually a good number, but you could make it more.
Set-ADFSProperties -CertificateGenerationThreshold 30
Step 3: Certificate Promotion Threshold

When ADFS generates the new self-signed certificates, they are initially set as “Secondary” certificates. ADFS will then use the value of this property to determine the number of days after the new certificates are generated to promote them to be the “Primary” certificates.
Set-ADFSProperties -CertificatePromotionThreshold 25
Step 4: Certificate Critical Threshold

If for some reason ADFS has not generated new self-signed certificates, or newly generated certificates have not been promoted to “Primary”, ADFS will perform these actions within the number of days set in this property prior to expiry of the current primary certificates. Leaving the default 2 days is usually best.
Set-ADFSProperties -CertificateCriticalThreshold 2
Step 5: Auto Certificate Rollover

This enables/disables the ADFS certificate rollover process, which uses the properties configured in the previous steps to rollover (renew & promote) the token certificates. This needs to be enabled.
Set-ADFSProperties -AutoCertificateRollover $true
Step 6: Export the New Certificates

If needed by the application owners, export the new certificates without their private keys. You can do this while the new certificates are set as “Secondary”.

Open the ADFS Management Console: ADFS > Service > Certificates

For each token certificate, perform the following:

*Right-click the certificate > View Certificate…
*In the new window > Details (tab) > Copy to File (button) > Next
*Select: DER Encoded Binary X.509 (.CER) -or- Base-64 Encoded X.509 (.CER)
*Next > Browse to a location to save the file and give it a name
*Next > Finish

Note: To export the certificate in .PEM format, choose Base-64 Encoded X.509 (.CER), and then rename the saved file with the .pem file extension.

Step 7: Export the Federation Metadata XML

If needed by the application owners, run the below PowerShell commands on the ADFS server to export the new ADFS Federation Metadata XML file. Make sure you modify the File Path before running the commands.
# Set the file path
$FilePath = "C:\Users\ADFSAdmin\Desktop\ADFS-MetaData.xml"

<nowiki>#</nowiki> Export MetaData XML
$mUrl = (Get-ADFSEndpoint | where Protocol -eq "Federation Metadata").FullUrl.ToString()
$httpHelper = new-object System.Net.WebClient
$metadataAsString = $httpHelper.DownloadString($mUrl)
$httpHelper.DownloadFile($mUrl , "$($FilePath)")
Note: If you export the metadata while there are both primary and secondary certificates, both of the certificates will be included in the XML file. After the secondary certificates are promoted to primary, and the old certificates are deleted, you should generate a new XML file for future use.

===Manual Staged Rollover===
You would use this process to manually control when the new self-signed token certificates are generated, and when they are promoted to become the “Primary” certificates. You will have full control over the rollover process. ADFS will not do anything automatically.

Permissions: Domain Admin & Local Admin on the primary ADFS server in the farm.

Step 1: Auto Certificate Rollover

This enables/disables the ADFS certificate rollover process, which uses the properties configured in the below steps to rollover (renew & promote) the token certificates automatically. This should be set to False. If not, run the following command.
Set-ADFSProperties -AutoCertificateRollover $false
Step 2: Certificate Duration

Set the number of days that will become the validity period of the new self-signed token certificates.

*1 Year: 365
*3 Years: 1095
*5 Years: 1827

Set-ADFSProperties -CertificateDuration 1095
Step 3: Certificate Generation Threshold

Set the number of days before the expiration date of the current certificates that ADFS should generate the new certificates. Depending on when you plan to manually generate the new certificates, this number should be greater than the number of days between when you generate the new certificates, and when the old certificates expire.

You need to set this because you have to enable the ADFS auto rollover process in order to generate the new certificates. After you generate the new certificates, you will immediately disable the auto rollover process.

Assuming you will generate the new certificates 30 days before the old ones expire, you could set this to 40.
Set-ADFSProperties -CertificateGenerationThreshold 40
Step 4: Certificate Promotion Threshold

When ADFS generates the new self-signed certificates, they are initially set as “Secondary” certificates. ADFS will then use the value of this property to determine the number of days after the new certificates are generated to promote them to be the “Primary” certificates.

Even though the ADFS auto rollover process will be disabled, this property should be set to a number lower than the above Certificate Generation Threshold property.
Set-ADFSProperties -CertificatePromotionThreshold 35
Step 5: Certificate Critical Threshold

If for some reason ADFS has not generated new self-signed certificates, or newly generated certificates have not been promoted to “Primary”, ADFS will perform these actions within the number of days set in this property prior to expiry of the current primary certificates. Leaving the default 2 days is usually best.
Set-ADFSProperties -CertificateCriticalThreshold 2
Step 6: Generate the New Certificates

When you are ready to generate the new token certificates as “Secondary” certificates, use the below PowerShell commands. Both the current “Primary” certificates and the new “Secondary” certificates will be available to the relying party applications.

Note that you cannot manually generate the new token certificates when the ADFS auto rollover process is disabled. Therefore, the commands enable the process, generates the new certificates as “Secondary”, and then disables the process.
Set-ADFSProperties -AutoCertificateRollover $true

Update-AdfsCertificate -CertificateType Token-Decrypting
Update-AdfsCertificate -CertificateType Token-Signing

Set-ADFSProperties -AutoCertificateRollover $false
Step 7: Export the Certificates

If needed by the application owners, export the certificates without their private keys.

Open the ADFS Management Console: ADFS > Service > Certificates

For each token certificate, perform the following:

*Right-click the certificate > View Certificate…
*In the new window > Details (tab) > Copy to File (button) > Next
*Select: DER Encoded Binary X.509 (.CER) -or- Base-64 Encoded X.509 (.CER)
*Next > Browse to a location to save the file and give it a name
*Next > Finish

Note: To export the certificate in .PEM format, choose Base-64 Encoded X.509 (.CER), and then rename the saved file with the .pem file extension.

Step 8: Export the Federation Metadata XML

If needed by the application owners, run the below PowerShell commands on the ADFS server to export the ADFS Federation Metadata XML file. Make sure you modify the File Path before running the commands.
# Set the file path
$FilePath = "C:\Users\ADFSAdmin\Desktop\ADFS-MetaData.xml"

<nowiki>#</nowiki> Export MetaData XML
$mUrl = (Get-ADFSEndpoint | where Protocol -eq "Federation Metadata").FullUrl.ToString()
$httpHelper = new-object System.Net.WebClient
$metadataAsString = $httpHelper.DownloadString($mUrl)
$httpHelper.DownloadFile($mUrl , "$($FilePath)")
Note: Both primary and secondary certificates will be included in the XML file. After you promote the new certificates and delete the old certificates, you should generate a new XML file for future use.

Step 9: Promote the New Certificates

Before the old certificates expire, you need to promote the new certificates to “Primary”.

ADFS Management Console: ADFS > Service > Certificates

For each “Secondary” token certificate, perform the following:

*Right-click the certificate > Set as Primary

Step 10: Delete the Old Certificates

After the old certificates have expired, you can delete them from the ADFS Management Console. Note that you only have the option to delete “Secondary” certificates. You cannot delete a “Primary” certificate.

ADFS Management Console: ADFS > Service > Certificates

For each “Secondary” token certificate, perform the following:

*Right-click the certificate > Delete

===Immediate Manual Rollover===
When doing an immediate rollover, you force ADFS to immediately generate new certificates, promote them to “Primary”, and delete the old certificates.

You would use these steps if you have a few relying party trusts and the application owners are ready to pull the new federation metadata from the ADFS public endpoint after a rollover. You would also use these steps if the ADFS auto rollover process is disabled, and your token certificates have expired.

After the rollover, you can export the new certificates & federation metadata, and send them to your relying party application owners.

Permissions: Domain Admin & Local Admin on the primary ADFS server in the farm.

Step 1: Certificate Duration

Set the number of days that will become the validity period of the new self-signed token certificates.

*1 Year: 365
*3 Years: 1095
*5 Years: 1827

Set-ADFSProperties -CertificateDuration 1095
Step 2: Generate the New Certificates

Note that you cannot generate the new token certificates when the ADFS auto rollover process is disabled. Therefore, the below commands enable the process, generate the new certificates, and then disable the process. The -Urgent switch indicates that the certificate rollover process should happen immediately, and remove older certificates.
Set-ADFSProperties -AutoCertificateRollover $true

Update-AdfsCertificate -CertificateType Token-Decrypting -Urgent
Update-AdfsCertificate -CertificateType Token-Signing -Urgent

Set-ADFSProperties -AutoCertificateRollover $false
Step 3: Export the Certificates

If needed by the application owners, export the certificates without their private keys.

Open the ADFS Management Console: ADFS > Service > Certificates

For each token certificate, perform the following:

*Right-click the certificate > View Certificate…
*In the new window > Details (tab) > Copy to File (button) > Next
*Select: DER Encoded Binary X.509 (.CER) -or- Base-64 Encoded X.509 (.CER)
*Next > Browse to a location to save the file and give it a name
*Next > Finish

Note: To export the certificate in .PEM format, choose Base-64 Encoded X.509 (.CER), and then rename the saved file with the .pem file extension.

Step 4: Export the Federation Metadata XML

If needed by the application owners, run the below PowerShell commands on the ADFS server to export the ADFS Federation Metadata XML file. Make sure you modify the File Path before running the commands.
# Set the file path
$FilePath = "C:\Users\ADFSAdmin\Desktop\ADFS-MetaData.xml"

<nowiki>#</nowiki> Export MetaData XML
$mUrl = (Get-ADFSEndpoint | where Protocol -eq "Federation Metadata").FullUrl.ToString()
$httpHelper = new-object System.Net.WebClient
$metadataAsString = $httpHelper.DownloadString($mUrl)
$httpHelper.DownloadFile($mUrl , "$($FilePath)")

==FAQ==

How to set SPN

<nowiki>http://www.gatepoint.ch/cmdreferenz/html/9341c753-11ff-4acc-993c-b05d50f32330.htm#bkmk_examples</nowiki>

*Update metadata to Office365. ('''Update-MsolFederatedDomain -DomainName mydomain.com -SupportMultiDomain''') 

=== FOCES certificate til STIL OIOSAML 3.0 ===
https://www.nets.eu/dk-da/l%C3%B8sninger/nemid/funktionssignatur

==Final==

STIL Settings

2021-11-02T13:11:57Z

Mej:

http://wiki.inlogic.dk/index.php/STIL_Settings_Roles

MSGraphPermissions

2021-10-26T09:02:11Z

Mej:

'''MS graph permissions is a UMS backend requirement from version 8.5.203 which was released in June 2021"'''

'''MS graph permissions are required by these UMS modules (LiveAtEdu,OneNote, Sharepoint, Office 365 Timeblok and MS Teams)'''

 

==Creating App Registration==

Go to [http://portal.azure.com Azure Portal] and login with you admin account( '''the same UMS uses''').

'''!!! ATTENTION !!! use service account that UMS uses'''

When logged in go to Azure Active Directory:
[[File:Graph1.jpg|left|thumb|832x832px]]

Go to App registrations
[[File:Graph2.jpg|none|thumb|831x831px]]

Click on New application registration
[[File:Graph3.jpg|none|thumb|909x909px]]

Give the new App a name ex. "UMSGraph", Choose "Web app / API" in Application type, set "Sign-on URL" to "http://localhost". After setting Application Permission values click "Create"
[[File:Graph43.jpg|none|thumb|913x913px]]

You will return to previous screen, here click "your new app"
[[File:Grahp5.jpg|none|thumb|905x905px]]

Click "Certificates & secrets"

Click "New Client Secret"

Enter a "Description" and set "Expires" to the interval that suits your needs.

Click "Add"
[[File:Graph6.jpg|none|thumb|908x908px]]

Copy "Value ID" We will use this later

'''!!! ATTENTION !!! the key value will never be visible again so ensure to copy it.''' [[File:Graph7.png|none|thumb|790x790px]]

Copy the "VALUE Key into "UMS Configurator" field Client Secret

[[File:Tewxddf.png|frameless|566x566px]]

Copy the "Directory Tenant ID " into "UMS Configurator" Field Tenant ID

Copy the "Appplication Client ID " into "UMS Configurator" Field Client ID
[[File:Id.jpg|none|thumb|1120x1120px]]

Click "Api permissions"

Click "Add a permission"
[[File:Graph8.png|none|thumb|780x780px]]

==Setup UMS to use Application just Created==
In the UMS Configurator go to Modules->Office 365 and click "SharePoint organization settings"
[[File:UMSConfiguratorSharepointOrganizationSettings.png|none|thumb|600x600px]]
Choose your SharePoint organization setting and click "Edit..."
[[File:UMSConfiguratorSharepointOrganizationSettingsEdit.png|none|thumb|600x600px]]
Input your "Tenant Name" ex. "cortenso'''.onmicrosoft.com'''", paste the previously copied Application ID into "Client ID" field and paste previously copied KEY into "Client secret" and click "Ok"
[[File:UMSConfiguratorSharepointOrganizationSettingsEditWindow.png|none|thumb|600x600px]]
You are now all set to use the new MS Graph integration.

==Permissions overview==

===Microsoft Graph===
{| class="wikitable sortable"
|+Default permissions
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|User.ReadWrite.All
|Application
|Microsoft Graph
|Setting attributes on the user in Office 365
|Live_at_edu.exe
|-
|Group.ReadWrite.All
|Application
|Microsoft Graph
|Setting group attributes on Office 365 groups
|Live_at_edu.exe
|-
|GroupMember.ReadWrite.All
|Application
|Microsoft Graph
|Manage GroupMembers in Office 365
|Live_at_edu.exe
|-
|Directory.ReadWrite.All
|Application
|Microsoft Graph
|Setting attributes on the user in Azure Active Directory
|Live_at_edu.exe
|-
|MailboxSettings.ReadWrite
|Application
|Microsoft Graph
|Used to set mailbox settings in Office 365.
Used to get/create categories
|Live_at_edu.exe
Skemabrikker.exe
|-
|Calendars.ReadWrite
|Application
|Microsoft Graph
|Used to allow UMS to sync calendar events to Office 365
|Skemabrikker.exe
|-
|Files.ReadWrite.All
|Application
|Microsoft Graph
|Used to provision OneDrive for users
|Live_at_edu.exe
|}
{| class="wikitable sortable"
|+Teams sync permissions
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|EduRoster.ReadWrite.All
|Application
|Microsoft Graph
|Allows the UMS to handle users on roster
|Live_at_edu.exe
|-
|Member.Read.Hidden
|Application
|Microsoft Graph
|Allows the UMS to handle users on roster
|Live_at_edu.exe
|-
|TeamMember.ReadWrite.All
|Application
|Microsoft Graph
|Used to add or remove users from Team
|Live_at_edu.exe
|-
|TeamsTab.ReadWrite.All
|Application
|Microsoft Graph
|Used to create tabs in teams
|Live_at_edu.exe
|-
|TeamsAppInstallation.ReadForTeam.All
|Application
|Microsoft Graph
|Used to install app in teams
|Live_at_edu.exe
|-
|Team.Create
|Application
|Microsoft Graph
|Used to create Teams
|Live_at_edu.exe
|-
|Team.ReadBasic.All
|Application
|Microsoft Graph
|Used to read teams
|Live_at_edu.exe
|}

===SharePoint===
{| class="wikitable sortable"
|+SharePoint sync permissions
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|Sites.FullControl.All
|Application
|Microsoft Graph
|Have full control of all site collections
|Office365_SP_OneNote.exe
|-
|Sites.Manage.All
|Application
|Microsoft Graph
|Read and write items and lists in all site collections
|Office365_SP_OneNote.exe
|-
|Sites.ReadWrite.All
|Application
|Microsoft Graph
|Read and write items in all site collections
|Office365_SP_OneNote.exe
|-
|User.ReadWrite.All
|Application
|Microsoft Graph
|Read and write user profiles
|Office365_SP_OneNote.exe
|}

===OneNote===
{| class="wikitable sortable"
|+OneNote sync permissions
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|Notes.ReadWrite.All
|Application
|Microsoft Graph
|
|Office365_SP_OneNote.exe
|} 
{| class="wikitable"
|+Password Sync
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|Roles and Administrators
|Application
|Microsoft Graph
|Reset password for Users
|Password_Sync
|}

===Password Administrator===

To Add Password administrator roles. Click '''Roles and administrator'''
[[File:Passwordd.png|left|thumb|1167x1167px]]

Click Add Assignments and Search for graph user
Click Add.
[[File:Password1.png|left|1167x1167px|thumb]]

MSGraphPermissions

2021-10-26T08:58:13Z

Mej:

'''MS graph permissions is a UMS backend requirement from version 8.5.203 which was released in June 2021"'''

'''MS graph permissions are required by these UMS modules (LiveAtEdu,OneNote, Sharepoint, Office 365 Timeblok and MS Teams)'''

 

==Creating App Registration==

Go to [http://portal.azure.com Azure Portal] and login with you admin account( '''the same UMS uses''').

'''!!! ATTENTION !!! use service account that UMS uses'''

When logged in go to Azure Active Directory:

 
[[File:Graph1.jpg|left|thumb|832x832px]]

Go to App registrations
[[File:Graph2.jpg|none|thumb|831x831px]]

Click on New application registration
[[File:Graph3.jpg|none|thumb|909x909px]]

Give the new App a name ex. "UMSGraph", Choose "Web app / API" in Application type, set "Sign-on URL" to "http://localhost". After setting Application Permission values click "Create"
[[File:Graph43.jpg|none|thumb|913x913px]]
You will return to previous screen, here click "your new app"
[[File:Grahp5.jpg|none|thumb|905x905px]]

Click "Certificates & secrets"

Click "New Client Secret"

Enter a "Description" and set "Expires" to the interval that suits your needs.

Click "Add"
[[File:Graph6.jpg|none|thumb|908x908px]]

Copy "Value ID" We will use this later

'''!!! ATTENTION !!! the key value will never be visible again so ensure to copy it.''' [[File:Graph7.png|none|thumb|790x790px]]

Copy the "VALUE Key into "UMS Configurator" field Client Secret

[[File:Tewxddf.png|frameless|566x566px]]

Copy the "Directory Tenant ID " into "UMS Configurator" Field Tenant ID

Copy the "Appplication Client ID " into "UMS Configurator" Field Client ID
[[File:Id.jpg|none|thumb|1120x1120px]]

Click "Api permissions"

Click "Add a permission"
[[File:Graph8.png|none|thumb|780x780px]]

==Setup UMS to use Application just Created==
In the UMS Configurator go to Modules->Office 365 and click "SharePoint organization settings"
[[File:UMSConfiguratorSharepointOrganizationSettings.png|none|thumb|600x600px]]
Choose your SharePoint organization setting and click "Edit..."
[[File:UMSConfiguratorSharepointOrganizationSettingsEdit.png|none|thumb|600x600px]]
Input your "Tenant Name" ex. "cortenso'''.onmicrosoft.com'''", paste the previously copied Application ID into "Client ID" field and paste previously copied KEY into "Client secret" and click "Ok"
[[File:UMSConfiguratorSharepointOrganizationSettingsEditWindow.png|none|thumb|600x600px]]
You are now all set to use the new MS Graph integration.

==Permissions overview==

===Microsoft Graph===
{| class="wikitable sortable"
|+Default permissions
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|User.ReadWrite.All
|Application
|Microsoft Graph
|Setting attributes on the user in Office 365
|Live_at_edu.exe
|-
|Group.ReadWrite.All
|Application
|Microsoft Graph
|Setting group attributes on Office 365 groups
|Live_at_edu.exe
|-
|GroupMember.ReadWrite.All
|Application
|Microsoft Graph
|Manage GroupMembers in Office 365
|Live_at_edu.exe
|-
|Directory.ReadWrite.All
|Application
|Microsoft Graph
|Setting attributes on the user in Azure Active Directory
|Live_at_edu.exe
|-
|MailboxSettings.ReadWrite
|Application
|Microsoft Graph
|Used to set mailbox settings in Office 365.
Used to get/create categories
|Live_at_edu.exe
Skemabrikker.exe
|-
|Calendars.ReadWrite
|Application
|Microsoft Graph
|Used to allow UMS to sync calendar events to Office 365
|Skemabrikker.exe
|-
|Files.ReadWrite.All
|Application
|Microsoft Graph
|Used to provision OneDrive for users
|Live_at_edu.exe
|}
{| class="wikitable sortable"
|+Teams sync permissions
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|EduRoster.ReadWrite.All
|Application
|Microsoft Graph
|Allows the UMS to handle users on roster
|Live_at_edu.exe
|-
|Member.Read.Hidden
|Application
|Microsoft Graph
|Allows the UMS to handle users on roster
|Live_at_edu.exe
|-
|TeamMember.ReadWrite.All
|Application
|Microsoft Graph
|Used to add or remove users from Team
|Live_at_edu.exe
|-
|TeamsTab.ReadWrite.All
|Application
|Microsoft Graph
|Used to create tabs in teams
|Live_at_edu.exe
|-
|TeamsAppInstallation.ReadForTeam.All
|Application
|Microsoft Graph
|Used to install app in teams
|Live_at_edu.exe
|-
|Team.Create
|Application
|Microsoft Graph
|Used to create Teams
|Live_at_edu.exe
|-
|Team.ReadBasic.All
|Application
|Microsoft Graph
|Used to read teams
|Live_at_edu.exe
|}

===SharePoint===
{| class="wikitable sortable"
|+SharePoint sync permissions
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|Sites.FullControl.All
|Application
|Microsoft Graph
|Have full control of all site collections
|Office365_SP_OneNote.exe
|-
|Sites.Manage.All
|Application
|Microsoft Graph
|Read and write items and lists in all site collections
|Office365_SP_OneNote.exe
|-
|Sites.ReadWrite.All
|Application
|Microsoft Graph
|Read and write items in all site collections
|Office365_SP_OneNote.exe
|-
|User.ReadWrite.All
|Application
|Microsoft Graph
|Read and write user profiles
|Office365_SP_OneNote.exe
|}

===OneNote===
{| class="wikitable sortable"
|+OneNote sync permissions
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|Notes.ReadWrite.All
|Application
|Microsoft Graph
|
|Office365_SP_OneNote.exe
|} 
{| class="wikitable"
|+Password Sync
!Permission name
!Permission type
!API
!Used for
!Used by
|-
|Roles and Administrators
|Application
|Microsoft Graph
|Reset password for Users
|Password_Sync
|}

===Password Administrator===

To Add Password administrator roles. Click '''Roles and administrator'''
[[File:Passwordd.png|left|thumb|1167x1167px]]

Click Add Assignments and Search for graph user

Click Add.
[[File:Password1.png|left|1167x1167px|thumb]]

STIL UNI Login

2020-06-08T07:17:25Z

Mej: /* FAQ */

UNI•Login er et digitalt ID for børn, unge og ansatte på institutioner, som giver adgang til nationale tjenester og en lang række pædagogiske services og online læremidler. UNI•Login kan bruges både til gratis webtjenester og til webtjenester, som institutionerne kan abonnere på. Institutionerne benytter ofte UNI•Login til adgangsstyring på lokalnet, intranet, trådløse net, skytjenester og andre webløsninger, hvor brugerne skal sikres nem adgang. UNI-Login leveres af STIL, Styrelsen for IT og Læring, der tidligere hed Uni-C.

==Prerequisites==

===Supported administrative systems===
Alle

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

===Should third party be contacted===
Kræver en adgang til WS17 ved STIL som skal bestilles.

https://viden.stil.dk/display/STILVIDENOFFENTLIG/Tilslutning#expand-Sdanopretterduentilslutningsaftale

OLD LINK (http://www.stil.dk/It-og-administration/Brugere-og-adgangsstyring/Udbyder-UNILogin/UNI-Login-Eksport)

==UNI-C Dataprovider==
Sender UNI-Login’s til STIL

For at sende disse data til STIL skal man aktiverer servicen '''UNILogin Upload'''. Se mere her [[Configurator/Services]]

Når det er indtastet vil servicen hvert 5 minut se efter om der er kommet en ny students tabel og sende nye data til STIL.

Når man har indtastet navnet og gemt skal man starte servicen "'''UMS UNILogin Upload'''" eller genstarte serveren.

Sættes op på den enkelte template under UNI-C noden
[[File:STIL Account setting.jpg|none|thumb|485x485px]]

===Account settings===
Her bestemmes hvor man vil sende brugerne fra den pågældende template hen.

===Institution number===
Det institutions nummer hvor data skal sendes hen.

===Upload UNI Logins to STIL===
Tells UMS that all templates using this setting will be uploaded to STIL. This will create/add users to the institution number.

===Create new UNI login when CPR changes===
When a CPR changes UMS will tell STIL that it has to create a new UNI login.

If this checkbox is not checked, then you must manually change the UNI Login at https://ba.emu.dk at the same time you change it in the administrative system.

=== Access group ===
Members of this Active Directory group will have access to this account in UMS Web.

The module is called STIL Settings and can be found under the Control Panel in UMS Web.

===Write back webservice pincode===
Bruges til kommunikation med elevplan hvis fraværs beskeder skal sendes til dem

===Elevplan Institution number===
Det elevplans institutions nummer hvor data skal sendes hen.

===Elevplan keyord===
SMS keyword som UMS reagerer på når det sendes ind til UMS gateway. Når det står først i Sms’en vil den blive sendt videre til elevplan. Man vil modtage en SMS fra elevplan om at den er modtaget hvis ikke man får den indenfor 30 minutter, skal man gensende Sms’en.

===Company mail address for employees===
Det bruges når der laves en upload af data til STIL til unilogin generering (UNILogin Upload). Man kan bestemme den adresse man har ved uddannelses institutionen. Bruges f.eks. til SDBF systemet.

===Company mail address for students===
Det bruges når der laves en upload af data til STIL til unilogin generering (UNILogin Upload). Man kan bestemme den adresse man har ved uddannelses institutionen.

===Mail===
Lister felterne fra students tabellen hvis man lader den stå i <Not Used> vil den automatisk bruge brugernavnet som man har i AD.

===Mail Domain===
Her indtaster man f.eks. inlogic.dk

Hvis ikke man vælger at indtaste noget i feltet mail domain men kun sætter mail feltet vil mail feltet skulle indeholde hele mail adressen.

==UNI-Login Settings==
[[File:Stiluniloginsettings.png|none|thumb|569x569px]]

===Use UNI-Login===
Her sættes der op om denne template skal bruge UNI-Login

===Force update UNI-Login===
Hvis man ændrer UNI-Login skal det så slå igennem i UMS. Dette vil betyde at brugeren bliver nedlagt og en ny oprettet.

==Upload af data==
For at kunne uploade data som sendes til STIL skal man have et Onlinetjeneste-abonnement. Informationer om dette kan findes her.

http://www.stil.dk/It-og-administration/Brugere-og-adgangsstyring/Udbyder-UNILogin/Onlinetjenester

For at bestille skal man sende en mail til [[Mailto:uniloginudbyder@STIL.dk| uniloginudbyder@STIL.dk]] med teksten og bestillingsformularen.

===Bestillingsformular===
Vi vil gerne have en konto som har adgang til WS10 upload og WS17 download af UNI-Logins. inLogic løsning.
Oplysninger
IP:
Institutions numre:
Dette findes under Modules -> UNI-Sync
[[File:STIL UNISync setup.jpg|none|thumb|368x368px]]

===Activate UNI-Sync===
Skal vi sende/hente data fra STIL

===Institution numbers===
Indtast hvilke institutions numre der skal hentes fra

===Data provider settings (Onlinetjeneste-abonnement)===
Indstillinger som skal bruges til WS10 (Sende data) og WS17 (hente data)

http://www.stil.dk/~/media/STIL/Filer/PDF13_14/140521%20UNI%20Login%20Import%20WS10%20v31.pdf

http://www.stil.dk/~/media/STIL/Filer/Publikationer/Tekniske%20vejledninger/UNI-ogin%20Eksport%20WS17%20v1.3.pdf

===Username===
Username need to access webservice.

===Password===
Password need to access webservice.

===Password synchronization (UNI-Sync abonnement)===
For at kunne password synkroniserer med STIL skal man have et UNI-Sync abonnement. Informationer findes her

http://www.stil.dk/It-og-administration/Brugere-og-adgangsstyring/Institutioner-og-kommuner/UNISync

(Det er kun nødvendigt at sætte kryds ved punkt A3 =” Automatisk via en webservice (kræver kendskab til SOAP)”.)

===Username===
Username need to access webservice.

===Password===
Password need to access webservice.

==Opsætning på brugeradministrationen==
For at kunne hente fra STIL og sende data til STIL skal man give lov til det. Det sætter man op i <nowiki>https://ba.emu.dk</nowiki>

En vejledning for opsætningen af WS17 kan findes her.

<nowiki>http://www.stil.dk/~/media/STIL/Filer/PDF15/150714%2017ws%20afsend%20og%20godkend%20Dataforspoergsel%20til%20skoler.pdf</nowiki>

UMS vil hente alle WS10

===Pakke===
Man skal som minimum have adgang til en fuld eller mellem pakke. Specifikationerne for de enkelte pakker kan ses nedenunder.

Dataaftale for UNI-Login Eksport

(UNI-Login webservice ws17)

Udbydere med ws17 dataadgang kan trække nedenstående information afhængigt af den valgte pakke.
{| class="wikitable"
| colspan="8" | - Den fulde pakke: Alle data i skemaet - markeret F

- Mellem pakken: Data i skemaet, som er markeret M

- Den lille pakke: Data i skemaet, som er markeret L

Data om ansatte, elever, værger og andre kontaktpersoner
|-
| colspan="3" | - CPR-nummer
| colspan="2" |F
| colspan="2" |M
|
|-
| colspan="3" | - Fornavn(e)
| colspan="2" |F
| colspan="2" |M
|L
|-
| colspan="3" | - Efternavn
| colspan="2" |F
| colspan="2" |M
|L
|-
| colspan="3" | - Privatadresse (Se adresseinformation)
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Hjemmetelefon (Se telefonnummer-information)
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Arbejdstelefon (Se telefonnummer-information)
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Mobiltelefon (Se telefonnummer-information)
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - E-mail
| colspan="2" |F
| colspan="2" |M
|
|-
| colspan="3" | - Fødselsdag
| colspan="2" |F
| colspan="2" |M
|
|-
| colspan="3" | - Køn
| colspan="2" |F
| colspan="2" |M
|
|-
| colspan="3" | - PhotoId
| colspan="2" |F
| colspan="2" |M
|
|-
| colspan="3" |
| colspan="2" |
| colspan="2" |
|
|-
| colspan="3" |Adresseinformation:
| colspan="2" |
| colspan="2" |
|
|-
| colspan="3" | - Om adressen er beskyttet
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Adressens vejnavn, nr. og etage
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Postnummer
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - By
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Landekode
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Land
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Kommunekode
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Kommunenavn
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" |
| colspan="2" |
| colspan="2" |
|
|-
| colspan="3" |Telefonnummer-information:
| colspan="2" |
| colspan="2" |
|
|-
| colspan="3" | - Om telefonnummeret er beskyttet
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Telefonnummer
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" |
| colspan="2" |
| colspan="2" |
|
|-
| colspan="3" |Supplerende data om elever
| colspan="2" |
| colspan="2" |
|
|-
| colspan="3" | - Studietype (elev eller stud)
| colspan="2" |F
| colspan="2" |M
|L
|-
| colspan="3" | - Studienummer
| colspan="2" |F
| colspan="2" |M
|L
|-
| colspan="3" | - Elevens niveau (for grundskoleelever)
| colspan="2" |F
| colspan="2" |M
|L
|-
| colspan="3" | - Elevens hovedgruppe (klasse)
| colspan="2" |F
| colspan="2" |M
|L
|-
| colspan="3" | - Yderligere grupper elever er tilknyttet
| colspan="2" |F
| colspan="2" |M
|L
|-
| colspan="3" | - Kontaktlærer
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Kontaktperson(er)s relation (mor, far osv.)
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Om kontaktperson(er) har forældremyndighed
| colspan="2" |F
| colspan="2" |
|
|-
| colspan="3" | - Afdeling, bygning eller værelsesnummer på efterskoler
| colspan="2" |F
| colspan="2" |M
|L
|-
| colspan="3" | - ID i det lokale studieadministrative system
| colspan="2" |F
| colspan="2" |M
|L
|}
{| class="wikitable"
|Supplerende data om ansatte
|
|
|
|-
|<nowiki>- Ansættelsestype (lærer, tap, pæd eller gæst)</nowiki>
|F
|M
|L
|-
|<nowiki>- Initialer</nowiki>
|F
|M
|L
|-
|<nowiki>- Stilling</nowiki>
|F
|M
|L
|-
|<nowiki>- Afdeling, bygning eller værelsesnummer på efterskoler</nowiki>
|F
|M
|L
|-
|<nowiki>- Grupper medarbejderen er tilknyttet</nowiki>
|F
|M
|L
|-
|<nowiki>- ID i det lokale studieadministrative system</nowiki>
|F
|M
|
|-
|
|
|
|
|-
|Data om UNI-Login for ansatte og elever
|
|
|
|-
|<nowiki>- UNI-Login brugernavn (brugerID)</nowiki>
|F
|M
|L
|-
|<nowiki>- Initialpassword</nowiki>
|F
|M
|
|-
|<nowiki>- Om inititalpassword er gældende password</nowiki>
|F
|M
|
|-
|<nowiki>- Brugerens navn i UNI-Login</nowiki>
|F
|M
|
|-
|<nowiki>- SkoleKom-navn</nowiki>
|F
|M
|
|-
|<nowiki>- Brugerens selvvalgte email-adresse i UNI-Login</nowiki>
|F
|M
|
|-
|<nowiki>- Brugerens selvvalgte mobilnummer i UNI-Login</nowiki>
|F
|M
|
|-
|
|
|
|
|-
|Data om grupper på institutionen
|
|
|
|-
|<nowiki>- Gruppeid</nowiki>
|F
|M
|L
|-
|<nowiki>- Gruppenavn</nowiki>
|F
|M
|L
|-
|<nowiki>- Gruppetype</nowiki>
|F
|M
|L
|-
|<nowiki>- Niveau</nowiki>
|F
|M
|L
|-
|<nowiki>- Spor</nowiki>
|F
|M
|L
|-
|<nowiki>- Startdato</nowiki>
|F
|M
|L
|-
|<nowiki>- Slutdato</nowiki>
|F
|M
|L
|}

===Technical settings===

====17ws - forspørgsel til skoler====
Log ind på ba.emu.dk – tryk dataaftaler>tryk på webservice forespørgsler
[[File:Stil1.png|none|thumb|642x642px]]
[[File:Stil2.png|none|thumb|642x642px]]

Indtast en skoles institutionsnummer> tryk vis > Tryk opret
[[File:Stil3.png|none|thumb|642x642px]]
Set fra skolens side > klik på dataaftaler > godkend, dvs. tryk gem
[[File:Stil4.png|none|thumb|642x642px]]

==FAQ==

===Hvordan checker jeg om min IP er åbnet hos STIL?===
Man kan teste adgangen via denne url:

<nowiki>https://ws04.infotjeneste.uni-c.dk/infotjenesteunilogin-ws/ws?WSDL</nowiki>

Den skulle gerne returnere et xml. Dokument – hvis i får en Access denied, så er der ikke åbnet for jeres IP.

===Hvilke CPR numre sendes til STIL (Gammel ordning)===
Alle rigtige CPR numre

Alle Fiktive CPR numre begyndende med 6,7,8 eller 9 og som overholder modulus 11

===Hvilke CPR numre bliver ikke sendt til STIL (Gammel ordning)===
Alle CPR numre som ikke overholder modulus 11

Alle CPR numre som indeholder bogstaver

===Hvilke CPR numre sendes til STIL (Ny ordning)===
Numerisk værdi der overholder modulus 11

Hvis cpr numre indeholder bogstaver opretter UMS Uni-login på baggrund af SLI id.

===Hvis man skifter CPR nummer beholder man så sit UNI Login===
Ja

===Må der kører andre importer end den fra inLogic===
Nej, det vil ødelægge automatikken med at beholde sit unilogin hvis man skifter CPR.

===Kan man få generet UNI-Login’s med det samme===
Ikke helt, men næsten.

Det kræver 2 kørsler af GetStudents med en upload af data imellem (UNILogin Upload servicen skal have kørt). Inden man kører anden kørsel af GetStudents skal STIL have haft nok tid til at lægge data fra deres back end miljø ud til de webservice’s hvor man henter data. En tommel finger regel kunne være 20-30 minutter.

===Hvordan nulstiller jeg common secret (udregnes ved første synkronisering)===
Åbner den tabel der hedder PasswordSyncGeneralSettings og sletter indholdet af kollonen UniCCommonSecret

===Skal Easy-C jobs slåes fra (C001 og C002)===
Ja de må ikke køre sammen med vores

===Skal LUDUS jobs slåes fra===
Ja kun upload man kan stadig download til ludus

===Error fra stil på uni-sync/password sync===
11/5/2018 11:05:01 AM - (ChangeUNI_CPassword) Change password for user - XXX0016 Error = 'ClientIP=87.54.38.xxx', 'AdpCommkeyStatus=2', 'checkCryptParam: md5sumNotEqual', 'BadAuth', 'ul-front-db-prod1', 'ul-wls-db-prod6', '2 ms'

Error rettes ved at nulstille UniCCommonSecret i SQL database. (update PasswordSyncGeneralSettingsset UniCCommonSecret = <nowiki>''</nowiki>)

Efter nulstilling af UniCCommonSecret, skal passwordsync jobbet køre igen.

===InstitutionPerson ikke indlæst! Ikke forventet CPR til localPersonID - skal omidentificeres: LocalPersonId====
Read this [[STIL UNI Login#Create new UNI login when CPR changes]] 

=== Errors = Fejl 8: Gruppen blev sat til en anden GroupType end Hovedgruppe===
Errors = Fejl 8: Gruppen blev sat til en anden GroupType end Hovedgruppe, men der findes 1 Student med gruppen som MainGroupId fra en anden importkilde! Fjern f.rst alle elever fra hovedgruppen i den anden kilde: GroupId=20amu006

Fejlen rettes ved at sikre at der ikke køres nogen andre imports en fra UMS. Hvis der er oprettet/tilknyttet nogen brugere manuelt til institutionen skal de også slettes.

Attendance Registration

2020-01-22T15:14:08Z

Mej: /* What does the Absence Status code mean? */

Attendance Registration is a tool for the educational sector that makes it easy to register attendance. Through a simple and intuitive interface, the teacher can register who is present, who is late, and who is absent. Registering attendance can be done in a matter of seconds, simply by clicking the button with the student’s name and picture. The interface uses colour codes, which makes it easy to see what the individual students are registered as. You decide which attendance options you want to use - i.e. options for being late, for legal absence, and illegal absence - as well as which colours are used for the different options. When attendance is registered, UMS automatically writes back to the administrative system - if supported. The interface also supports the possibility to see if the student has sent a text message to the school or if the staff has written notes regarding the student’s attendance.

There are references to other UMS modules, e.g. SMS, in this guide. In case the mentioned modules are not present in your environment, you can ignore these settings.

In order to edit templates, it is also required to have a basic knowledge about the UMS configurator.

==Prerequisites==

===Supported administrative systems===

*Easy-C

*Ludus

*SIS

*Other systems where it is possible to retrieve a timetable for students and teachers

===Module requirements===

*[[UMS]]

*[[UMS Academic Web]]

===Testing after setup===
To start testing after setup, you must log in as a teacher. See if you have access to attendance registration on the front page of UMS portal.

Click on attendance registration and check that you can search for timetables for students, teachers, and classes.

Check that you can register individual students as absent.

===What is necessary to get started===
To get started, it is necessary to have a running [[UMS]] installation.

==Installation==
Install [[UMS]] and [[UMS Academic Web]]

==Technical settings==

===Settings for UMS Attendance Basic===
All settings for UMS Attendance Basic is set in the configurator. In the main menu under 'Settings/Services', it is necessary to set the 'Absence service' to run on a server. The service is responsible for sending text messages to students that are registered as absent. Please make sure the service has started and is running. See example of the set up below.
[[File:AbsenceServiceSetup.png|none|thumb|636x636px]]

===Global settings===
Global settings are settings that are valid for the entire school. For settings that can be altered per education, class, or similar, see 'Individual settings'.

The Global settings are:

*Attendance colours
*Design text messages sent to the students
*Granting access to teachers/employees and edit access to registration forward-looking
*Edit attendance types (late, approved, not approved)

====Attendance colours====
Settings are found under 'Modules\Absence\colors' in the main menu. Simply select the colours you want to use for each type of attendance. See example below.
[[File:Absencecolor.png|none|thumb|573x573px]]

====Designing text messages sent to the students====
It is possible to preset text messages that will be sent to students if they are registered as absent. The settings are found under 'Modules\Absence\SMS' in the main menu. The text messages can be set for each type of attendance both in Danish and English. It is also possible to create multiple text messages for each type of attendance. If you create multiple messages, the system will randomise these messages. Meaning, the system will send different messages to a student each time attendance is registered. See example below.
[[File:Absencesms.png|none|thumb|598x598px]]

When you edit a message, there are several variables that can be used to ensuaking the messages more personalised. See example below.
[[File:Absencesmsvariables.png|none|thumb|1009x1009px]]

====Granting access to teachers/employees and edit access to registration forward-looking====
Granting access to functions in the registration interface is done under 'Setup web access/Absence'. Attendance basic allows 'register access' and 'Future registration access'. Enter a group (nested groups are allowed) with the teacher/employees that are allowed to use the specific function. See example below.

The checkboxes have the following meaning:

*'Count too late on statistics' – Not used for Attendance basic
*'Show empty days' – Should the day ruler show or omit days with no planned timetable?
*'Show weekends' – Should the day ruler show or omit weekends?
*'Show legal' – Is legal attendance used on the school/is it shown in the protocol?
*'Show illegal' – Is illegal attendance used on the school/is it shown in the protocol?
*'Show too late' – Is too late attendance used on the school/is it shown in the protocol?

[[File:Absencewebsetup.png|none|thumb|828x828px]]

=====Edit attendance types=====
To edit letters and text used in the attendance module, choose the button 'Select' (see the window above).

Double-click on the row containing the settings you want to edit. See below.
[[File:Absenceselect.png|none|thumb|874x874px]]

===Individual settings===
Individual settings can be altered per education, class, or similar. For settings valid for the entire school, see 'Global settings'. If an individual setting for a specific group is needed, it is necessary to create the group with the students in question beforehand. These settings can be altered under Configurator\Templates\Edit\Absence\Manage\Add a new or edit an existing setting.
[[File:Template Absence Setting.jpg|none|thumb|784x784px]]
 

====SMS and App settings for notify absence====

*'SMS Sick Keyword' - The keyword set in this box will define which keyword the student sends in a text message to notify absence. E.g. the keyword 'Sick' means the student has to send a message containing 'sick' or 'sick %reason or message to the teacher%'. Both cases will be accepted by UMS. All text after the keyword will not be stored in UMS.
*'SMS absence Keyword' - The keyword set in this box will define which keyword the student sends in a text message to notify absence. E.g. the keyword 'Sick' means the student has to send a message containing 'sick' or 'sick %reason or message to the teacher%'. Both cases will be accepted by UMS. All text after the keyword will be stored in UMS.

*'Default incoming SMS status' - These are settings for which type of attendance the system should set as default when receiving a message from a student notifying absence. The teacher will see this status in the attendance registration interface. E.g. when the default type of attendance is 'Legal absence', students will be marked as 'Legal absence' when notifying absent
*'Ignore messages for today start/end' - In the set time span, it is not possible for a student to send a text message to notify absence. This means that if the message is received before the given start time, e.g. 10 a.m., the system will check the students schedule for timetable blocks that day and mark the blocks with the default attendance status, e.g. 'Legal absence'. The system will then send a reply confirming the student is marked absent. If the message is received between the start and end time, e.g. 10 a.m. and 3 p.m., the system will send the student a reply, saying it is not allowed to notify absence at this time. If the message is received after the given end time, e.g. 3.pm., the system will check the schedule for timetable blocks the following day and mark those with the default attendance status, e.g. 'Legal absence' If this feature is set to 00:00 - 00:00 students cannot register as absent. If you want an "Always register for the current day"-functionality, set it to 23:59 - 00:00
*'Require reason' - The school can require the students to give a reason when notifying absence. Check this box if students have to write a reason in order to register as absent

====Misc settings====

*'Use cards' - This enables students to register via their student ID's via Bianco. Check this box if the student is allowed to register via card
*'Show watermark at %' - If the school has a limitation for how high attendance percentage is allowed for a student, this can be set as visible. Check this box if it should be visible if the students are above the accepted limit
*'Days back' - This setting decides how many days backwards a teacher is allowed to register and edit attendance. Set the number of days that are allowed in the drop-down menu 'Days back'. Please note that this setting cannot exceed the number of days backwards in the global timetable block data job!
*'Too late' - This shows the number of minutes a late show should count. 'Too late' sets the number of minutes late attendance should count. If a student is late for class it will be registered as e.g. 10 minutes absence. Set the number of minutes that should count in this box
*'Show percent on studentstat' - Check this box, if students are allowed to see their attendance percent under 'My attendance'
*'Send SMS' - When a student is registered as absent, the system can reply with a text message. Check this box to enable the system to send a reply
*'Default calculation view' - Choose between "Display calculation in lessons" or "Display calculations in minutes"
*'Lesson length' - Number of minutes one lesson counts for
*'Time interval for calculation' - Select the time interval for the calculation of my absence
*'Show Course' - Check this box to show course view for students' 'My absence' in both web and app
*'Show Activity' - Check this box to show activity view for students' 'My absence' in both web and app
*'Show Grades' - Check this box to show grades in statistics

====Student reason settings====

*'Allow students to register absence reason' - This setting allows students to create an absence reason when they are registered as absent
*'Use Cutoff Day' - This setting changes the 'Register absence' feature from being reliant on a specific amount of days back, to instead be fixed to a specific amount of days into a month.
*'Cutoff day of month' - At this day of the month the absence gets "locked" for the previous month.
*'Days back' - This sets how many days backwards students are allowed to add an absence reason on a course. E.g. the student can register an absence reason 7 days backwards
*'Show Admin/teacher notes in app' - Changes whether the student can see administration and teacher-written notes on absence entries. They are presented in the app with a lock icon and cursive text.

[[File:Admin teacher app notes.jpg|border|frameless]]

==[[Attendance_Registration/WarningReports|Warning reports]]==

==FAQ==

====What to do when a teacher can't register absence X days back ?====
A specific day in the absence registration system has a green checkmark if the teacher is allowed to register according to "Days back" absence settings on the template in UMS Configurator.

Only members of the AD group configured in Websetup are allowed to register more days back than teachers.

 

====What to do when abscence can't be registrated due to double registration ?====
This error is due to double absence registration. Absence should be deleted in the administrativ program.

(UpdateEasyW031) Update Error Username = benj4896 - TimeStamp = 26-09-2018 10:14:55 - ErrorCode = 6 - ErrorText = elev. 2510015153, dato 26.09.2018, lektion: 2 eksisterende fravær kan ikke overskrives

====How can a teacher know that if a student has a pause?====
If a student has a pause, a small pause icon will be shown for that student.
Hovering with the mouse over the icon will show the pause interval. 
The system will automatically handle how much absence a student should have, if they don't show up, but they have a pause.

====What does the Absence Status code mean?====
When checking up on absence registration in the database each type of attendence will be substituted by a number as such: 

{| class="wikitable"
|-
! Status
! Attendance Type
|-
|0
|Attended
|-
|1
|Too Late
|-
|2
|Approved Absence
|-
|3
|Illegal Absence
|}

If there are made changes to which [[Attendance_Registration#Granting_access_to_teachers.2Femployees_and_edit_access_to_registration_forward-looking|attendance types that are shown]] and the definitions of [[Attendance_Registration#Edit_attendance_types|these attendance types]] in the web configurator, it will affect the Absence Status code ie. removing Approved absence will leave only Status code 0, 1 and 3 to be used.

Attendance Registration

2020-01-22T15:07:31Z

Mej: /* What does the Absence Status Code mean? */

Attendance Registration

2020-01-22T15:07:03Z

Mej: /* FAQ */

Attendance Registration is a tool for the educational sector that makes it easy to register attendance. Through a simple and intuitive interface, the teacher can register who is present, who is late, and who is absent. Registering attendance can be done in a matter of seconds, simply by clicking the button with the student’s name and picture. The interface uses colour codes, which makes it easy to see what the individual students are registered as. You decide which attendance options you want to use - i.e. options for being late, for legal absence, and illegal absence - as well as which colours are used for the different options. When attendance is registered, UMS automatically writes back to the administrative system - if supported. The interface also supports the possibility to see if the student has sent a text message to the school or if the staff has written notes regarding the student’s attendance.

There are references to other UMS modules, e.g. SMS, in this guide. In case the mentioned modules are not present in your environment, you can ignore these settings.

In order to edit templates, it is also required to have a basic knowledge about the UMS configurator.

==Prerequisites==

===Supported administrative systems===

*Easy-C

*Ludus

*SIS

*Other systems where it is possible to retrieve a timetable for students and teachers

===Module requirements===

*[[UMS]]

*[[UMS Academic Web]]

===Testing after setup===
To start testing after setup, you must log in as a teacher. See if you have access to attendance registration on the front page of UMS portal.

Click on attendance registration and check that you can search for timetables for students, teachers, and classes.

Check that you can register individual students as absent.

===What is necessary to get started===
To get started, it is necessary to have a running [[UMS]] installation.

==Installation==
Install [[UMS]] and [[UMS Academic Web]]

==Technical settings==

===Settings for UMS Attendance Basic===
All settings for UMS Attendance Basic is set in the configurator. In the main menu under 'Settings/Services', it is necessary to set the 'Absence service' to run on a server. The service is responsible for sending text messages to students that are registered as absent. Please make sure the service has started and is running. See example of the set up below.
[[File:AbsenceServiceSetup.png|none|thumb|636x636px]]

===Global settings===
Global settings are settings that are valid for the entire school. For settings that can be altered per education, class, or similar, see 'Individual settings'.

The Global settings are:

*Attendance colours
*Design text messages sent to the students
*Granting access to teachers/employees and edit access to registration forward-looking
*Edit attendance types (late, approved, not approved)

====Attendance colours====
Settings are found under 'Modules\Absence\colors' in the main menu. Simply select the colours you want to use for each type of attendance. See example below.
[[File:Absencecolor.png|none|thumb|573x573px]]

====Designing text messages sent to the students====
It is possible to preset text messages that will be sent to students if they are registered as absent. The settings are found under 'Modules\Absence\SMS' in the main menu. The text messages can be set for each type of attendance both in Danish and English. It is also possible to create multiple text messages for each type of attendance. If you create multiple messages, the system will randomise these messages. Meaning, the system will send different messages to a student each time attendance is registered. See example below.
[[File:Absencesms.png|none|thumb|598x598px]]

When you edit a message, there are several variables that can be used to ensuaking the messages more personalised. See example below.
[[File:Absencesmsvariables.png|none|thumb|1009x1009px]]

====Granting access to teachers/employees and edit access to registration forward-looking====
Granting access to functions in the registration interface is done under 'Setup web access/Absence'. Attendance basic allows 'register access' and 'Future registration access'. Enter a group (nested groups are allowed) with the teacher/employees that are allowed to use the specific function. See example below.

The checkboxes have the following meaning:

*'Count too late on statistics' – Not used for Attendance basic
*'Show empty days' – Should the day ruler show or omit days with no planned timetable?
*'Show weekends' – Should the day ruler show or omit weekends?
*'Show legal' – Is legal attendance used on the school/is it shown in the protocol?
*'Show illegal' – Is illegal attendance used on the school/is it shown in the protocol?
*'Show too late' – Is too late attendance used on the school/is it shown in the protocol?

[[File:Absencewebsetup.png|none|thumb|828x828px]]

=====Edit attendance types=====
To edit letters and text used in the attendance module, choose the button 'Select' (see the window above).

Double-click on the row containing the settings you want to edit. See below.
[[File:Absenceselect.png|none|thumb|874x874px]]

===Individual settings===
Individual settings can be altered per education, class, or similar. For settings valid for the entire school, see 'Global settings'. If an individual setting for a specific group is needed, it is necessary to create the group with the students in question beforehand. These settings can be altered under Configurator\Templates\Edit\Absence\Manage\Add a new or edit an existing setting.
[[File:Template Absence Setting.jpg|none|thumb|784x784px]]
 

====SMS and App settings for notify absence====

*'SMS Sick Keyword' - The keyword set in this box will define which keyword the student sends in a text message to notify absence. E.g. the keyword 'Sick' means the student has to send a message containing 'sick' or 'sick %reason or message to the teacher%'. Both cases will be accepted by UMS. All text after the keyword will not be stored in UMS.
*'SMS absence Keyword' - The keyword set in this box will define which keyword the student sends in a text message to notify absence. E.g. the keyword 'Sick' means the student has to send a message containing 'sick' or 'sick %reason or message to the teacher%'. Both cases will be accepted by UMS. All text after the keyword will be stored in UMS.

*'Default incoming SMS status' - These are settings for which type of attendance the system should set as default when receiving a message from a student notifying absence. The teacher will see this status in the attendance registration interface. E.g. when the default type of attendance is 'Legal absence', students will be marked as 'Legal absence' when notifying absent
*'Ignore messages for today start/end' - In the set time span, it is not possible for a student to send a text message to notify absence. This means that if the message is received before the given start time, e.g. 10 a.m., the system will check the students schedule for timetable blocks that day and mark the blocks with the default attendance status, e.g. 'Legal absence'. The system will then send a reply confirming the student is marked absent. If the message is received between the start and end time, e.g. 10 a.m. and 3 p.m., the system will send the student a reply, saying it is not allowed to notify absence at this time. If the message is received after the given end time, e.g. 3.pm., the system will check the schedule for timetable blocks the following day and mark those with the default attendance status, e.g. 'Legal absence' If this feature is set to 00:00 - 00:00 students cannot register as absent. If you want an "Always register for the current day"-functionality, set it to 23:59 - 00:00
*'Require reason' - The school can require the students to give a reason when notifying absence. Check this box if students have to write a reason in order to register as absent

====Misc settings====

*'Use cards' - This enables students to register via their student ID's via Bianco. Check this box if the student is allowed to register via card
*'Show watermark at %' - If the school has a limitation for how high attendance percentage is allowed for a student, this can be set as visible. Check this box if it should be visible if the students are above the accepted limit
*'Days back' - This setting decides how many days backwards a teacher is allowed to register and edit attendance. Set the number of days that are allowed in the drop-down menu 'Days back'. Please note that this setting cannot exceed the number of days backwards in the global timetable block data job!
*'Too late' - This shows the number of minutes a late show should count. 'Too late' sets the number of minutes late attendance should count. If a student is late for class it will be registered as e.g. 10 minutes absence. Set the number of minutes that should count in this box
*'Show percent on studentstat' - Check this box, if students are allowed to see their attendance percent under 'My attendance'
*'Send SMS' - When a student is registered as absent, the system can reply with a text message. Check this box to enable the system to send a reply
*'Default calculation view' - Choose between "Display calculation in lessons" or "Display calculations in minutes"
*'Lesson length' - Number of minutes one lesson counts for
*'Time interval for calculation' - Select the time interval for the calculation of my absence
*'Show Course' - Check this box to show course view for students' 'My absence' in both web and app
*'Show Activity' - Check this box to show activity view for students' 'My absence' in both web and app
*'Show Grades' - Check this box to show grades in statistics

====Student reason settings====

*'Allow students to register absence reason' - This setting allows students to create an absence reason when they are registered as absent
*'Use Cutoff Day' - This setting changes the 'Register absence' feature from being reliant on a specific amount of days back, to instead be fixed to a specific amount of days into a month.
*'Cutoff day of month' - At this day of the month the absence gets "locked" for the previous month.
*'Days back' - This sets how many days backwards students are allowed to add an absence reason on a course. E.g. the student can register an absence reason 7 days backwards
*'Show Admin/teacher notes in app' - Changes whether the student can see administration and teacher-written notes on absence entries. They are presented in the app with a lock icon and cursive text.

[[File:Admin teacher app notes.jpg|border|frameless]]

==[[Attendance_Registration/WarningReports|Warning reports]]==

==FAQ==

====What to do when a teacher can't register absence X days back ?====
A specific day in the absence registration system has a green checkmark if the teacher is allowed to register according to "Days back" absence settings on the template in UMS Configurator.

Only members of the AD group configured in Websetup are allowed to register more days back than teachers.

 

====What to do when abscence can't be registrated due to double registration ?====
This error is due to double absence registration. Absence should be deleted in the administrativ program.

(UpdateEasyW031) Update Error Username = benj4896 - TimeStamp = 26-09-2018 10:14:55 - ErrorCode = 6 - ErrorText = elev. 2510015153, dato 26.09.2018, lektion: 2 eksisterende fravær kan ikke overskrives

====How can a teacher know that if a student has a pause?====
If a student has a pause, a small pause icon will be shown for that student.
Hovering with the mouse over the icon will show the pause interval. 
The system will automatically handle how much absence a student should have, if they don't show up, but they have a pause.

====What does the Absence Status Code mean?====
When checking up on absence registration in the database each type of attendence will be substituted by a number as such: 

{| class="wikitable"
|-
! Status
! Attendance Type
|-
|0
|Attended
|-
|1
|Too Late
|-
|2
|Approved Absence
|-
|3
|Illegal Absence
|}

If there are made changes to which [[Attendance_Registration#Granting_access_to_teachers.2Femployees_and_edit_access_to_registration_forward-looking|attendance types that are shown]] and the definitions of [[Attendance_Registration#Edit_attendance_types|these attendance types]] in the web configurator, it will affect the Absence Status Code.

App

2019-08-27T11:08:33Z

Mej: /* Support */

[[File:UMS School App.png|frame]]
UMS School App is available for iPhone, Android and Windows Phone. It will be designed with the school’s own logo, color and style. The app gives the basic functionality to see:

*News
*Timetable
*Homework
*Grades
*User information

Additional licenses gives the ability to create, edit and see more information from various modules. For an overview of module requirement see "[http://wiki.inlogic.dk/index.php?title=App&section=6&wteswitched=1#Additional_functionality Additional functionality"]

==Support==
We provide regular support for the following and newer versions:

*Android version 7.0. We support the same versions as Google provide security updates for. Find an overview [[wikipedia:Android_version_history#Code_names|here]].

*iOS version 10

*Windows 10 Mobile (version 10)

Please note that it is possible to run older versions. If support for older versions is needed, we offer support at our hourly rate.

==Prerequisites==
===Supported administrative systems===

*Userinfo: Easy-A, SIS, LUDUS and Lectio (Only mobile number).
*Grades: Easy-A, Lectio and SIS
*Homework: Easy-A and SIS.
*Timetable: Easy-A and SIS
*Attendance registration: Timetable data is retrieved from Easy-A, SIS, LUDUS, Tabulex and Lectio. Howerver, absence is only registered to Easy-A

===Module requirements===

*UMS Web (contains and run all the webservice that is required for the app to receive information and communicate with the server)

===Additional functionality===
You get more functionality in the app by having the following modules, these are all optional:

*Attendance Registration: Gives “Your attendance”, which shows student statistics, the student are able to add absence reason and see their absence status in the timetable
*Attendance Registration for UMS School App: gives employee “attendance registration” and student the ability to "report absence"
*Homework: gives the employee the ability to create homework
*Link Collection: gives links/bookmarks the school can setup
*User info: gives “Your information” the ability to edit the information. This also adds the functionality for the user to upload a new profile image (a selfie) to be used in the student id card
*Student & Employee Id: Gives the students a “student id card” and the employees an “employee id card”. To update their student id card profile image you’ll need the “User info” module
*Parking: Parkzone & APCOA Integration. Gives the option to create and edit parking permits from Parkzone and APCOA
*User information (add/edit)

Note: All Attendance functionality requires Attendance Registration.

===Testing after setup===

The app will be tested internally at inLogic before release. The test requires access to a user with relevant data. You can either create a fictional student who is associated to a real course, or alternatively use a real student's account, if the person agrees that the account is being used for a system test of the school's APP.

===What to have ready===

*'''Important''': The UMS site needs to use HTTPS and be public available. It needs a valid SSL certificate.
*Materials that can be used for designing the app. For example: Logo, brochure, design guide line, etc.

*Optional: It is possible for the school to have its own account where the app is located. An account in the App Store cost $99 per year, while an account for Google Play costs a onetime fee of $25. The school self-manage these accounts.

===Physical hardware requirements===

Having a smartphone is a necessity, either an Android, iOS or a Windows 10 Mobile.

===Should third party be contacted===

If the school is using a dedicated hosting service, they have to be informed on how you wish the news feed should be setup.

==Installation and setup==
inLogic will publish and update the app.

If you want your own AppStore and Google Play store pages, you will need your own Apple Developer Account for the iOS version, this is a requirements from Apples Guidelines. [[App Store Connect|Please follow the guide App Store Connect]].

Android and Windows Phone can be published through inLogics account or your schools own account (if you have acquired one). If you have your own account inLogic needs to be informed as well. To publish the app, inLogic needs the following information:

*[[UMS Web]] url address- This is the address that you use wen you access UMS Web. (If you are running any kind of gateway (TMG, UAG etc.) you will need to create rules for the services on UMS Web, contact us for more information)
**''<nowiki>https://*****.dk/</nowiki>''

===My School App===
My school app (Danish: Min skole app) is the inLogic app that is hosted by inLogic, this lets your school get started using the app faster and cheaper, and also there is less maintenance for you.

======What does this mean?======
Pros:

*Lower start-up price.
*No need to set up an Apple Developer account.
*Upon contacting InLogic Support your app can be live within a few hours.
*You can change logo, images & colors after the app is deployed

Cons:

*The app will not be called your schools name on you phone and in AppStore/Google Play, but is instead called 'My school app' (danish: Min skole app), and its app icon cannot be customized.
*When students & teachers starts up the app for the first time, they will need to select their specific school before proceeding to login.

 

=====Setting up My school app=====
<blockquote>Configurator -> Web setup -> App -> Setting</blockquote>
[[File:App levitas settings.png|none|frame]]

Here you need to configure a Primary and Secondary color, as well as a Logo. The Login background and Menu background images are optional.

The first time you set this up, you will need to contact InLogic support, and provide the following:

*A 64x64 pixels version of your logo (this logo is used in the the login dropdown, it will make it easier for users to find your school)
*UMS Web url (See [[App#Installation and setup|Installation and Setup]])

==Styling==
To style the app following is needed:

*Primary color
*Secondary color
*Logo (.png, vector file: .psd, .ai etc.)
*Icon for app logo (.png, vector file: .psd, .ai etc.)

The primary color will mostly be used as the default background color. The secondary color is the highlight color, and will be used when something is active or being activated like a button.

Optional:

*Background image for login (size 1080x1920)
*Background image for top bar of menu (size 1080x480)

===Examples of styling===

*Primary and secondary colors

[[File:App - Timetable view.png|none|thumb|Example of primary and secondary colors used in the app.
The primary color is used in the Header navigation bar, and the secondary color as border on the selected Calendar date
]]

*The schools logo - Max. 1024x576

[[File:Branding-af-app-inLogic-logo.png|none|thumb|Example of the inLogic logo used in the Demo app]]

*App logo - 1024x1024. If not supplied, inLogic will generate an App logo based on the schools logo (does not apply to My School App)

[[File:Simulator Screen Shot - iPhone SE - 2018-05-15 at 12.57.23.png|none|thumb|Example of app logo in use]]

*Login background image - 1080x1920. If not supplied, a white background will be shown, with your logo on top

'''''NOTE: The app will place your logo on top of the background image. This means when you supply a background image, it needs to be without logo on it.'''''[[File:App - Login screen.png|none|thumb|Example of a background image used on the Demo app login screen.
The school logo will be displayed on top of the background image, as seen here
]]

*Menu top bar image - 1080x480. If not supplied, a white background will be shown

[[File:App - Sidebar menu.png|none|thumb|Example of an image used on the Demo app menu view]]

==Technical settings==

The following sections show how to configure the app. This information only applies to services that are directly connected to the app, i.e. how to set up schedule tasks in the app. The only exception is 'UMS RSS Feeds', which is a specific service for app. If a fully detailed setup guide is needed, please go to that specific module.

Some of the configurations are not set up specifically for app, i.e. ParkZone. If you cannot find the setup guide you are looking for, you can find it by searching or on the front page. Please note that some changes made in the configurator not only will affect the app but also UMS Web.

'''Important''' As many settings only loads once the website is initializing, most changes require an IIS reset on the server. The app retrieves settings from UMS once a day, which means that changes will be visible the next time you log in or the next day.

===Menu Settings===

You are able to set the order and which menu buttons should be shown per template for the users

#Open UMS Configurator
#Templates -> Edit -> select a template -> App
#Under Menu order select Manage -> Add
#Write a Description
#Drap and drop the menu you want

[[File:MeunOrderSettings.png|none|thumb|789x789px]]
Here three menubuttons will be visible to the users on that specific template.

===History===
Before version 2.0.917, you used to choose the modules displayed in the app via the Configurator -> Web Setup.

We have moved the menu order into the Configurator -> Template Editor -> App -> Menu order.
[[File:Menu settings history.png|none|thumb|1600x1600px]]
This change was made to allow a different menu items and orders on Templates.

===News===

----

This describes how to setup news for the app.

*App News created from UMS Web
*Add a RSS feed
*Add Facebook feed

It is possible to use all three setups together. Combine as you like and set difference feed for difference templates.

====Setup for App News from UMS Web====

You need to create or use an existing AD group. This group will have access to create and modify news in
App News on UMS Web.

#Open UMS Configurator
#Menu -> Web Setup -> Edit -> App
#Add the AD group for News Access group

[[File:App newsaccessgroup.png|none|thumb|767x767px]]

====Setup for RSS feed====
Add server name for the service for RSS feed in Menu -> Modules -> Settings -> RSS Feeds

[[File:App rssfeedservice.png|thumb|none|594x594px]]
To setup Rss feed you will need the url for the rss. (E.g. http://inlogic.dk/feed)

Menu -> Templates -> Edit -> select template -> Rss Feeds

Manage -> Add… -> Fill in description, feed url and access token
[[File:App rssfeedurl.png|none|thumb|920x920px]]
'''Note:''' You only need an access token if the feed is from Facebook

The RSS feed runs as a service called “UMS RSS Feeds”. Default running every 5 min.
[[File:App services.png|none|thumb|561x561px]]
Restart the service to test it and check the output in /UserManagement/RSSFeeds.Log
[[File:App rssfeedlog.png|none|thumb|944x944px]]

====Setup for Facebook news====

If you want to use a Facebook page news feed, you need two things:

*Facebook Page Url Feed
*Access Token

=====Facebook Page Url Feed=====

To create the feed url

#Get your facebook page url
#*E.g. https://www.facebook.com/inlogic.dk
#Copy the name. E.g. “inlogic.dk”
#*Note: this can also be a number “142642699097242”
#Replace “inlogic.dk” with your name in this url
#*<nowiki>https://graph.facebook.com/v3.0/inlogic.dk/</nowiki>

Your facebook page url feed should look something like this:

*<nowiki>https://graph.facebook.com/v3.0/schoolname/</nowiki>

This is your feed URL.

=====Create a facebook access token=====
The personal Facebook account that you use to register as a developer does not need to be associated in any way with the page or group whose posts you want to display. You cannot log in to the Developer site using a Facebook Page or Business account. You must use the username and password from your personal Facebook profile. Facebook doesn’t allow businesses to register as developers, only individuals.

Please follow [https://developers.facebook.com/docs/apps/register Facebook guide] to enable yourself as developer on facebook.

When you have a facebook developer account and created an app go to [https://developers.facebook.com/tools/explorer Facebook Graph Explorer]

#Select application
#Select “Get Token” and “Get App Token”
#Copy the Access Token

[[File:App facebookgettoken.png|none|thumb|968x968px]]
Now you have the access token you need to paste into the configurator.
[[File:App rssfeedurl.png|none|thumb|920x920px]]
Reload the service UMS Rss Feed in Services and look in the RSS Feed log to validate.

===Grades===

----

You can set the default view for grades, that filters the grades accordingly. The options are Course, Day and period.

Configurator -> Web Setup -> Edit -> App -> Default grade view
[[File:App gradesview.png|none|thumb|801x801px]]
To specific the period you can set how your terms are set with start and end day for each period.

Configurator -> Modules -> Grades -> Select the Datasource -> Edit -> Terms
[[File:App gradesterms.png|none|thumb|706x706px]]
Depending on which administration system you’re exporting grades from the columns can vary. You can set which grades column should be used and in which order.

Configurator -> Web Setup -> Edit -> App -> Select grade columns
[[File:App gradescolumns.png|none|thumb|709x709px]]
The grades view in the App will change accordingly to which columns chosen, a max of 4 columns will be shown in the App. The columns will be shown for each grade in order from 1 to 4.

If no grade columns settings is made the default columns will be selected in the following order:

*EducationDescription
*CourseDescription
*EvaluationFormDescription
*GradeValue

===Your information===

----

You can select which fields in user information that should be editable.

Configurator -> Web Setup -> Edit -> Userinfo
[[File:App userinfo.png|none|thumb|800x800px]]
You need to set permission before the users are able to upload their own student photo (a selfie).

Configurator -> Web Setup -> Edit -> UMS Photo -> Enable Selfie in App
[[File:App userinfoselfie.png|none|thumb|802x802px]]
This will enable selfie function.

===Student ID And Employee ID===

----<blockquote>''This content has been moved to [[Student / Employee ID]]''</blockquote>

===My Absence===
----The students are able to write an absence reason on an already registered subject. This can be enabled in the template editor.

Select the template -> Absence -> Manage -> Create a new settings or select an existing one -> Add/Edit

Check "Allow students to register absence reason"

[[File:Absence settings.png|none|thumb|570x570px]]

'''Allow students to register absence reason''' will allow the students to set an absence reason when a teacher has set the student as absent. The student can set an absence reason in "My absence".

'''Days back''' is the number of days back the students are allowed to set an absence reason.

'''Show Course''' will show the course view (this will effect both web and app).

'''Show Activity''' will show the activity view (this will effect both web and app).

===Push Notification===
----<blockquote>'''''Temporarily disabled'''''</blockquote>UMS can send push notifications when there are news, grades, or changes in your timetable. It is possible to receive a daily notification with your timetable for the day.

In addition the app can receive [[SMS Alert]] messages.

To set up push notifications go to Web Setup -> App -> Manage -> Add
[[File:AppPushNotificationSettings.png|none|thumb|526x526px]]

Set the description

FCM Server Api Key:

#Receive the key string from inLogic and paste it

Windows Phone:

#Receive the Package SID and Client secret from inLogic and paste the strings

====School account====
In case the school has it's own account do the following to retrieve the information

FCM Server Api Key:

#Open https://play.google.com/apps/publish
#Google Play Console -> Settings -> API Access -> Create linked project and open it -> Credentials
#Create API Key
#Select the API Key and make key restriction for Android
#Type in your package name and SHA-1 certificate fingerprint
#Copy the API key and paste it inside FCM Server API Key

Windows Phone:

#Open https://developer.microsoft.com/en-us/dashboard/apps/overview
#Select your app
#Services -> Push notification -> WNS/MPNS
#Select "Live Services site"
#Copy and paste the Package SID into the configurator
#Generate an Application Secret if none exist
#Copy and paste the Application Secret into the configurator (This is the Client Secret)

===Links===
----[[UMS Links]] can be used by both UMS Web and UMS App. Check the [[UMS Links|guide]].

===Homework===
----See [[UMS Homework]]

===Parking===
----See [[Parking]]

===Notify absence===
----See [[Attendance Registration#SMS and App settings for notify absence|App settings for notify absence in attendance registration]]

===Sms Alert===
----See [[SMS Alert]]

===Privacy Policy===
----To add your own privary policy in the app go to Web Setup -> App

Insert into "Privacy Policy Url:"

If left empty it will default to inLogic's privacy policy "https://www.inlogic.dk/om-inlogic/privacy-policy/"
[[File:App privacypolicyurl.png|none|thumb|792x792px]]

To add it to the App Store login

#https://appstoreconnect.apple.com/
#My Apps
#Select the app
#Select the top menu App Store
#Select App Information in the left menu
#Add your privacy policy url to "Privacy Policy URL"

[[File:App appstore privacypolicy.png|none|thumb|955x955px]] 
===Force language setting===
----Should you wish to, you have the option to force the language of the app to use a specific language, rather than the phones default language.

This is changed via the 'Forced language' feature in the Configurator.
[[File:Forced language.png|none|frame]]
The list of languages will expand over time, as UMS adds support for new languages.
 

==FAQ==

===Untrusted Certificate Error on Android===
'''''We do not recommend using Comodo certificates since they have been known to cause these issues.'''''

Can't login on some Android devices? This could be due to an untrusted Comodo SSL Certificate. We were able to reproduced it on Android version 4.1, 4.4.2, 5.0.1 and 8.1.0, but it may be present on any number of versions.

You can test your SSL certificate on https://sslanalyzer.comodoca.com/

Do the following on the server

#Delete the Comodo RSA Certification Authority issued by Comodo RSA Certification Authority with an expiration date of January 18, 2038.
#Enable automatic root certificate updates on the server

Please checkout the Comodo support site: https://support.comodo.com/index.php?/Knowledgebase/Article/View/1019/38/untrusted-certificate-error-on-android

For future conservation:<blockquote>Certificate is not installed correctly; the certificate needs to be chained back to the Addtrust root certificate in order to be trusted on the Android.</blockquote><blockquote>The issue is that the Windows server is not presenting the complete certificate chain; clients which do not have the complete certificate chain will result in this error as encountered on the Android phone. In order to resolve this, on the server which this certificate is installed on, please open the MMC (Microsoft Management Console), and add the certificate snap-in for the computer account on the local computer.</blockquote><blockquote>In the Intermediate Certification Authorities folder, verify if the Comodo RSA Domain Validation Secure Server CA and Comodo RSA Certification Authority(issued to Comodo RSA Certification Authority, issued by AddTrustExternal CA Root) are installed in this certificate store.</blockquote><blockquote>In the Trusted Root Certification Authorities folder verify if the AddTrustExternal CA Root is installed. Also, if you see the Comodo RSA Certification Authority (issued to and issued by Comodo RSA Certification Authority with an expiration date of January 18, 2038) is present, if it is please delete this certificate.</blockquote><blockquote>If any of these certificates are missing the intermediate and root certificates were provided to you in the .zip file when the certificate was issued, or are available via this support article - <nowiki>https://support.comodo.com/index.php?/Default/Knowledgebase/Article/View/979/108/domain-validation-sha-2</nowiki> .</blockquote><blockquote>If you had to delete the Comodo RSA Certification Authority from the Trusted Root Authorities folder, you will also need to disable automatic root certificate updates on the server - https://support.comodo.com/index.php?/Default/Knowledgebase/Article/View/769/17/turn-off-automatic-root-certificates-updates-server-2008</blockquote><blockquote>If you have performed these steps and the certificate chain has not updated on the server, to force IIS to update the certificate chain you will need to either change the certificate binding in IIS to another certificate, and then switch the certificate bindings to the correct certificate. Alternately, you will need to restart the server.</blockquote>Conservation for https://support.comodo.com/index.php?/Default/Knowledgebase/Article/View/769/17/turn-off-automatic-root-certificates-updates-server-2008<blockquote>To perform this procedure, you must be a member of the local Administrators group, or you must have been delegated the appropriate authority.</blockquote><blockquote>To turn off Automatic Root Certificates Update:</blockquote><blockquote>1. Click Start, and then click Run.</blockquote><blockquote>2. Type gpedit.msc, and then click OK.</blockquote><blockquote>3. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.</blockquote><blockquote>4. Double-click Administrative Templates, double-click System, double-click Internet Communication Management, and then click Internet Communication settings.</blockquote><blockquote>5. Double-click Turn off Automatic Root Certificates Update, click Enabled, and then click OK.</blockquote><blockquote>6. Close the Local Group Policy Editor.</blockquote><blockquote>Note: You can use Group Policy to set policy settings that apply across a given site, domain, or organizational unit in Active Directory Domain Services.</blockquote>

===Issues with the app===
If you're facing issues with the app, please perform the following steps before contacting support:

*Check the AppStore/GooglePlay for app updates and install any present
*Shut down the app completely, and start it back up
*Restart the phone
*Uninstall the app, and redownload it from AppStore/GooglePlay

Moodle

2019-06-21T12:57:11Z

Mej: /* Course */

Our Moodle integration is developed for schools, which 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===
The integration makes it possible to upload pictures of the users to Moodle, making it easy for teachers and students to see whom they are interacting with. If these pictures are replaced in UMS, they are automatically updated in Moodle. Last, but not least, the module can integrate with the AD. This allows users to log into Moodle with the same password they use to access the school’s IT-system. The Moodle 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, who can focus on other tasks instead.

If you want to make it easy for students and teachers to keep track of their timetables, you can embed our Web Timetable module in Moodle as an iframe. By doing this, users can access homework and notes that are registered on the various timetable blocks in the timetable. Please note: To embed Web Time Table, the Web Timetable and SSO modules are required. In order to see homework, the Homework module is required.

==Prerequisites==

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

===What to have ready===
Moodle

==Installation==
Open UMS Configurator and go to Modules > Moodle > Organization settings
[[File:Image.png|none|thumb|537x537px]]

Click Add.
[[File:Moodleorganizationsettings.png|none|thumb|535x535px]]

==Organization settings==
[[File:Moodle organization settings2.png|none|thumb|508x508px]]

'''Description'''

Give your Organization setting a name.

'''DatabaseServer'''

Name of database server hosting the Moodle database.

'''DatabaseName'''

Name of Moodle database.

'''Database TablesPrefix'''

Table prefix set when installing Moodle.

'''UserName'''

UserName of the user that can access the database.

'''Password'''

Password of the user that can access the database.

'''URL'''

URL for your Moodle installation ex. <nowiki>http://moodle.inlogic.dk</nowiki>

'''Webservice Token'''

Token created in Moodle siteadministration. [https://docs.moodle.org/24/en/Using_web_services Guide to create access and token] ( Remember: When adding functions to webservice, add all functions )

'''DataPath'''

Moodle data path ex. \\moodle.inlogic.dk\c$\Moodle\server\moodledata\filedir.

The user running moodle exe must have access to this path.

'''DatabaseType'''

Choose Database type used for Moodle. can only be one in the list below. The selected SQL database, the port number must be open in the firewall, since UMS communicates on the database level

*Microsoft SQL (1433)
*MySQL (3306)
*Oracle SQL (1521)

==Moodle Site settings==
From Configurator, Edit existing template > Moodle > Manage > Add or Configurator > Modules > Moodle > Site Settings > Add
[[File:Moodle Settings.png|none|thumb|824x824px]]
'''Description:'''

Give the Site settings a name.

'''Organization settings'''

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

'''Default country'''

Choose default country. This is used when creating users.

'''Authentication method'''

Login method for the users

'''Mail domain for new students'''

The address appended to their username in moodle to give them an email address

'''Mail domain for new employees'''

The address appended to their username in moodle to give them an email address

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

*Address
*Phone (Phone1)
*Mobile Phone (Phone 2)
*Mail

===Picture library===
Upload pictures of students

See [[Configurator/Picture_libraries|Picture libraries]]

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

*Address
*Phone (Phone1)
*Mobile Phone (Phone 2)
*Mail

===Picture library===
Upload pictures of employees

See [[Configurator/Picture_libraries|Picture libraries]]

===Course===

[[File:Moodle Course Settings.png|none|thumb|732x732px]]

See [[LMS Settings]] for options not descriped below

'''Language'''

The language set on a site when is it created.

'''Course category'''

The category the course is put on when the site is created. The course category is case sensitive and needs to match a category created in Moodle.

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

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

===Cohort===

[[File:Moodle Cohort Settings.png|none|thumb|733x733px]]

See [[LMS Settings]] for options not descriped below
====Activity sites====
See [[Site selection settings]]

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

==Template Settings==
You need to attach a cohort setting to a template. This will tell UMS that cohorts will be created from this template.
[[File:Moodle Template Cohort Settings.png|none|thumb|675x675px]]

'''Description'''

Enter a description for this setting

'''Cohort category'''

Enter a category that will be attached to the cohorts when they are created

'''SQL Groups'''

See [[LMS Settings]] for this option

==FAQ==

Timetable

2019-05-13T10:39:03Z

Mej: /* How do I find timetable blocks with SQL statements ? */

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

[[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]]===

==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'''
[[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
|}

Timetable

2019-05-13T09:51:39Z

Mej:

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

[[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]]===

==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'''
[[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= '159873')

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

Order By RealStartDateTime
|}

Timetable

2019-05-13T09:50:46Z

Mej: /* FAQ */

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

Google Apps(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]]===

==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'''
[[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= '159873')

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

Order By RealStartDateTime
|}

Timetable

2019-05-13T09:49:00Z

Mej: /* Mail: */

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

Google Apps(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]]===

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T09:48:39Z

Mej: /* Parameters */

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

Google Apps(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]]===

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T09:45:30Z

Mej: /* Usage */

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

Google Apps(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.

Activitiesonly - This parameter is used if the [action] parameter needs to only affect a given activity.

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

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T09:44:43Z

Mej: /* Usage */

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

Google Apps(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.

Activitiesonly - This parameter is used if the [action] parameter needs to only affect a given activity.

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

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T09:44:14Z

Mej: /* Mail: */

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

Google Apps(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

Activitiesonly - This parameter is used if the [action] parameter needs to only affect a given activity

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

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T09:40:09Z

Mej: /* Mail: */

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

Google Apps(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 giving physical Classroom

Activitiesonly -

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

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T09:39:11Z

Mej: /* Mail: */

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

Google Apps(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 - Parameter used if the [action] parameter needs to affect a specific user

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

Studentsonly - 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 giving physical Classroom

Activitiesonly -

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

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T09:30:44Z

Mej: /* Parameters */

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

Google Apps(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 - Parameter used if the [action] parameter needs to affect a specific user

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

Studentsonly - 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 giving physical Classroom

Activitiesonly -

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

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T09:30:00Z

Mej: /* Parameters */

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

Google Apps(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 that are associated with the given [mail] parameter

 

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

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

Studentsonly - 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 giving physical Classroom

Activitiesonly -

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

==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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T08:31:32Z

Mej: /* Parameters */

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

Google Apps(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 that are associated with the given [mail] parameter

 

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

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

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

Roomsonly -

Activitiesonly -

===== StartDate: =====
dd-mm-yyyy

 

===== EndDate: =====
dd-mm-yyyy

 

===== Type: =====
UMS

NonUMS

All

==External systems==

===[[Timetable/itslearning|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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-05-13T08:29:27Z

Mej: /* Parameters */

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

Google Apps(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 that are associated with the given [mail] parameter

Mail:

mail/UPN - Parameter used if the [action] parameter needs to affect a specific user

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

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

Roomsonly -

Activitiesonly -

StartDate:

dd-mm-yyyy

EndDate:

dd-mm-yyyy

Type:

UMS

NonUMS

All

==External systems==

===[[Timetable/itslearning|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]
Example:
{| 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'''
[[File:Skemabrikkerlog.png|none|thumb|864x864px]]

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 ?====
{| 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
|}

Timetable

2019-04-17T13:08:37Z

Mej: /* FAQ */

Skemabrikker.exe

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

Timetable

2019-04-17T13:08:15Z

Mej:

Skemabrikker.exe

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

Timetable

2019-04-17T13:01:16Z

Mej:

Skemabrikker.exe

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

Timetable

2019-04-17T12:40:59Z

Mej: /* Parameters */

Skemabrikker.exe

=== Parameters ===

== FAQ ==

Timetable

2019-04-17T12:39:58Z

Mej:

Skemabrikker.exe

== Parameters ==

== FAQ ==