SMS Welcome

From UmsWiki
Revision as of 15:40, 22 February 2018 by Kia (talk | contribs)
Jump to navigation Jump to search

The automatically sends a SMS to users when they are created in Active Directory.

If the phone number is international or there is no number, it will send a mail to the users private mail address found in UMS.

No notification will be send if there is no phone number and no private mail.

The phone number is found during Active Directory creation while the mail is found when it tries to send it.

The notification is send by the SMS Server program.

Prerequisites

Module requirements

UMS

What to have ready

An inLogic SMS Modem

Installation

Template Setting

Create a welcome setting than will be attached to a template. Only users on this template will recieve a welcome notice.

Select manage and add a setting.

Display name

Description for this setting

Confidential

Wether or not this setting can be seen on UMS Web SMS log. Since this contains sensitive data.

Text message

Enter the message to send to the user.

Days before start

Send the message to the user x days before their first active activity. This is calculated from the startdate of the user on an activity.

You can find the start date it calculates from using this SQL statement in SQL Server Management Studio. Remember to replace username in the text below.

-----------------------------------------------------------------------------------------------

Select Top 1 Convert(Datetime, StartDato, 105) As StartDate

From Students

Where

Action = 'Add'

And StartDato Is Not Null

And Convert(Datetime, StartDato, 105) >= Convert(Date, GetDate())

And StudieNr = '<Username>'

Order By Convert(Datetime, StartDato, 105)

-----------------------------------------------------------------------------------------------

At creation

The SMS will be send at time of Active Directory creation

Variables

This shows a subset of the variables you can use on a setting. You can use any field from the Students table. Just remember the column name is case sensitive

Test

Send a test message from the configurator program to a number. The variables will not be replaced.