Jump to content

DigitalPost: Difference between revisions

From UmsWiki
No edit summary
Line 8: Line 8:
Choose the admin server created here [[AdminServers/DigitalPost|Adminservers/DigitalPost]]
Choose the admin server created here [[AdminServers/DigitalPost|Adminservers/DigitalPost]]


===Providers===
===Template welcome settings===
This setting is only used when running user creation in AD.


'''Confidential'''
As the SMS contains sensitive data, you can choose not to show the setting on UMS Web's SMS log. Check the box if the information should be kept confidential.
'''Text message'''
Enter the welcome message that will be sent to the user.
'''Days before start'''
Please select how many days before a user should receive the message. The sending date will be calculated from the '''Current Education StartDate'''. if '''Current Education StartDate''' does not exist then start date of the users first activity will be used.
You can find the start date it calculates from by using the SQL statement below in SQL Server Management Studio. Remember to replace 'Username' with the user.
<nowiki>-----------------------------------------------------------------------------------------------</nowiki>
Select DateAdd(Day, 0, IsNull(
(Select Top 1 Current_Education_StartDate
From Students
Where
(studienr = '<Username>')
And (Current_Education_StartDate Is Not Null)
Order By convert(datetime, EnrollmentDate, 105) ASC),
(Select Top 1 Convert(datetime, StartDato, 105)
From Students
Where
(studienr = '<Username>')
And (IsNull(Startdato, '') <> '')
Order By convert(datetime, startdato, 105) ASC
))) As SendStartTime
<nowiki>-----------------------------------------------------------------------------------------------</nowiki>
'''At creation'''
Check this box if the SMS should be sent when a user is created in Active Directory.
'''Variables'''
This shows a subset of the variables you can use in a setting. You can use any field from the 'Students table'. Please remember the column name is case sensitive.
[[File:SMS Welcome Variables.png|none|thumb|410x410px|SMS variables
]]
==FAQ==
==FAQ==

Revision as of 10:43, 26 March 2026

UMS Configurator settings

Description

Insert a name or description for the setting

Admin servers

Choose the admin server created here Adminservers/DigitalPost

Template welcome settings

This setting is only used when running user creation in AD.

Confidential

As the SMS contains sensitive data, you can choose not to show the setting on UMS Web's SMS log. Check the box if the information should be kept confidential.

Text message

Enter the welcome message that will be sent to the user.

Days before start

Please select how many days before a user should receive the message. The sending date will be calculated from the Current Education StartDate. if Current Education StartDate does not exist then start date of the users first activity will be used.

You can find the start date it calculates from by using the SQL statement below in SQL Server Management Studio. Remember to replace 'Username' with the user.

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

Select DateAdd(Day, 0, IsNull(
(Select Top 1 Current_Education_StartDate
From Students
Where 
(studienr = '<Username>')
And (Current_Education_StartDate Is Not Null)
Order By convert(datetime, EnrollmentDate, 105) ASC),
(Select Top 1 Convert(datetime, StartDato, 105)
From Students
Where 
(studienr = '<Username>')
And (IsNull(Startdato, ) <> )
Order By convert(datetime, startdato, 105) ASC
))) As SendStartTime

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

At creation

Check this box if the SMS should be sent when a user is created in Active Directory.

Variables

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

SMS variables

FAQ