SMS Welcome - Revision history

Kia at 09:32, 2 July 2020

2020-07-02T09:32:29Z

← Older revision		Revision as of 09:32, 2 July 2020
Line 35:		Line 35:
	'''Days before start'''		'''Days before start'''

	Please select how many days before a user should receive the message. The sending date will be calculated from the start date ~~for~~ the ~~user or their~~ first activity.		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.		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.

Kia at 09:30, 2 July 2020

2020-07-02T09:30:55Z

← Older revision		Revision as of 09:30, 2 July 2020
Line 9:		Line 9:
	The notification is sent through the SMS Server program.		The notification is sent through the SMS Server program.

	== Prerequisites ==		==Prerequisites==

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

	=== What to have ready ===		===What to have ready===
	An inLogic SMS Modem		An inLogic SMS Modem

	== Installation ==		==Installation==

	=== Template settings ===		===Template settings===
	To get started, you must create a welcome setting that will be connected to a template. Select manage and add a setting, as shown below. Please note that only users registered on this template will receive the welcome notice.		To get started, you must create a welcome setting that will be connected to a template. Select manage and add a setting, as shown below. Please note that only users registered on this template will receive the welcome notice.
	[[File:Configurator SMS Welcome.png\|none\|thumb\|791x791px\|Configurator SMS Welcome]]The SMS template editor will now open.[[File:SMS Welcome.png\|none\|thumb\|807x807px\|SMS template settings, SMS Welcome]]'''Display name'''		[[File:Configurator SMS Welcome.png\|none\|thumb\|791x791px\|Configurator SMS Welcome]]The SMS template editor will now open.[[File:SMS Welcome.png\|none\|thumb\|807x807px\|SMS template settings, SMS Welcome]]'''Display name'''
Line 41:		Line 41:
	<nowiki>-----------------------------------------------------------------------------------------------</nowiki>		<nowiki>-----------------------------------------------------------------------------------------------</nowiki>

	Select DateAdd(Day, ~~-{SMSWelcomeDaysBeforeStart}~~, IsNull(		Select DateAdd(Day, 0, IsNull(
	(Select Top 1 Current_Education_StartDate		(Select Top 1 Current_Education_StartDate
	From Students		From Students

Kia at 09:29, 2 July 2020

2020-07-02T09:29:40Z

← Older revision		Revision as of 09:29, 2 July 2020
Line 41:		Line 41:
	<nowiki>-----------------------------------------------------------------------------------------------</nowiki>		<nowiki>-----------------------------------------------------------------------------------------------</nowiki>

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

	<nowiki>-----------------------------------------------------------------------------------------------</nowiki>		<nowiki>-----------------------------------------------------------------------------------------------</nowiki>

Kia at 09:29, 2 July 2020

2020-07-02T09:29:14Z

← Older revision		Revision as of 09:29, 2 July 2020
Line 41:		Line 41:
	<nowiki>-----------------------------------------------------------------------------------------------</nowiki>		<nowiki>-----------------------------------------------------------------------------------------------</nowiki>

	Select ~~Top 1 Convert~~(~~Datetime~~, ~~StartDato~~, ~~105) As StartDate~~		Select DateAdd(Day, -{SMSWelcomeDaysBeforeStart}, IsNull(
			(Select Top 1 Current_Education_StartDate
	From Students		From Students
			Where
	Where		(studienr = '<Username>')
			And (Current_Education_StartDate Is Not Null)
	~~Action~~ = '~~Add~~'		Order By convert(datetime, EnrollmentDate, 105) ASC),
			(Select Top 1 Convert(datetime, StartDato, 105)
	And ~~StartDato~~ Is Not Null		From Students
			Where
	~~And Convert~~(~~Datetime~~, ~~StartDato~~, 105) >= Convert(~~Date~~, ~~GetDate()~~)		(studienr = '<Username>')
			And (IsNull(Startdato, '') <> '')
	~~And StudieNr~~ = '<Username>'		Order By convert(datetime, startdato, 105) ASC
			))) As SendStartTime
	Order By ~~Convert~~(~~Datetime~~, ~~StartDato~~, 105)

	<nowiki>-----------------------------------------------------------------------------------------------</nowiki>		<nowiki>-----------------------------------------------------------------------------------------------</nowiki>

Mmh at 09:20, 12 March 2018

2018-03-12T09:20:37Z

← Older revision		Revision as of 09:20, 12 March 2018
Line 19:		Line 19:
	== Installation ==		== Installation ==

	=== Template ~~Setting~~ ===		=== Template settings ===
	To get started, you must create a welcome setting that will be connected to a template. ~~Only~~ users registered on this template will receive the welcome notice~~. Select manage and add a setting, as shown below~~.		To get started, you must create a welcome setting that will be connected to a template. Select manage and add a setting, as shown below. Please note that only users registered on this template will receive the welcome notice.
	[[File:Configurator SMS Welcome.png\|none\|thumb\|791x791px\|Configurator SMS Welcome]]'''Display name'''		[[File:Configurator SMS Welcome.png\|none\|thumb\|791x791px\|Configurator SMS Welcome]]The SMS template editor will now open.[[File:SMS Welcome.png\|none\|thumb\|807x807px\|SMS template settings, SMS Welcome]]'''Display name'''

	Please enter the name or a description of the setting, i.e. Welcome.		Please enter the name or a description of the setting, i.e. Welcome.
Line 70:		Line 70:
	'''Test'''		'''Test'''

	You can send a test message from the configurator program to a selected number. Please notice that the variables will not be replaced in the test message.~~[[File:SMS Welcome.png\|none\|thumb\|807x807px\|SMS template settings, SMS Welcome]]~~		You can send a test message from the configurator program to a selected number. Please notice that the variables will not be replaced in the test message.

Mmh at 09:12, 12 March 2018

2018-03-12T09:12:57Z

← Older revision		Revision as of 09:12, 12 March 2018
Line 1:		Line 1:
	The automatically sends a SMS to users when they are created in Active Directory.		The system automatically sends an SMS notification 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.		If the user has an international phone number or there is no number, the system will send an e-mail to the registered e-mail address in UMS.

	~~No notification~~ will be ~~send~~ if ~~there is no~~ phone number ~~and no private~~ mail.		There will not be sent any notification, if neither phone number nor e-mail address is registered.

	~~The~~ phone number is found during Active Directory creation ~~while~~ the mail is found when ~~it tries~~ to send it.		While the phone number is found during Active Directory creation, the e-mail address is found when attempting to send an SMS.

	The notification is ~~send by~~ the SMS Server program.		The notification is sent through the SMS Server program.

	== Prerequisites ==		== Prerequisites ==
Line 20:		Line 20:

	=== Template Setting ===		=== Template Setting ===
	~~Create~~ a welcome setting ~~than~~ will be ~~attached~~ to a template. Only users on this template will ~~recieve a~~ welcome notice.		To get started, you must create a welcome setting that will be connected to a template. Only users registered on this template will receive the welcome notice. Select manage and add a setting, as shown below.
	~~[[File:Configurator SMS Welcome.png\|none\|thumb\|791x791px]]~~Select manage and add a setting.[[File:SMS Welcome.png\|none\|thumb\|~~807x807px~~]]'''Display name'''		[[File:Configurator SMS Welcome.png\|none\|thumb\|791x791px\|Configurator SMS Welcome]]'''Display name'''

	~~Description for this~~ setting		Please enter the name or a description of the setting, i.e. Welcome.

	'''Confidential'''		'''Confidential'''

	~~Wether or~~ not ~~this~~ setting ~~can be seen~~ on UMS Web SMS log. ~~Since this contains sensitive data~~.		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'''		'''Text message'''

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

	'''Days before start'''		'''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.		Please select how many days before a user should receive the message. The sending date will be calculated from the start date for the user or their first 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~~.		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>		<nowiki>-----------------------------------------------------------------------------------------------</nowiki>
Line 61:		Line 61:
	'''At creation'''		'''At creation'''

	~~The~~ SMS ~~will~~ be ~~send at time of~~ Active Directory ~~creation~~		Check this box if the SMS should be sent when a user is created in Active Directory.

	'''Variables'''		'''Variables'''
	~~[[File:SMS Welcome Variables.png\|none\|thumb\|410x410px\|~~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		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
	]]		]]
	'''Test'''		'''Test'''

	~~Send~~ a test message from the configurator program to a number. ~~The~~ variables will not be replaced.		You can send a test message from the configurator program to a selected number. Please notice that the variables will not be replaced in the test message.[[File:SMS Welcome.png\|none\|thumb\|807x807px\|SMS template settings, SMS Welcome]]

Kia at 15:40, 22 February 2018

2018-02-22T15:40:40Z

← Older revision		Revision as of 15:40, 22 February 2018
Line 1:		Line 1:
	The automatically sends a SMS to users when they are created in Active Directory.		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 ==		== Prerequisites ==

Kia at 15:35, 22 February 2018

2018-02-22T15:35:27Z

@@ Line 12: / Line 12: @@
 === Template Setting ===
-Create a welcome setting than will be attached to a template.
+Create a welcome setting than will be attached to a template. Only users on this template will recieve a welcome notice.
-[[File:Configurator SMS Welcome.png|none|thumb|791x791px]]
+[[File:Configurator SMS Welcome.png|none|thumb|791x791px]]Select manage and add a setting.[[File:SMS Welcome.png|none|thumb|807x807px]]'''Display name'''
-[[File:SMS Welcome.png|none|thumb|807x807px]]
+Description for this setting
-== Technical settings ==
+'''Confidential'''
-== FAQ ==
+Wether or not this setting can be seen on UMS Web SMS log. Since this contains sensitive data.

Kia at 14:44, 22 February 2018

2018-02-22T14:44:09Z

← Older revision		Revision as of 14:44, 22 February 2018
Line 1:		Line 1:
	The ~~integration~~ automatically ~~creates and maintains the school's~~ users in ~~BOSS~~. ~~BOSS is a barcode / RFID based registration system that links all loans directly to the individual student to the library. The BOSS integration allows BOSS to retrieve data from the UMS web server~~		The automatically sends a SMS to users when they are created in Active Directory.

	== Prerequisites ==		== Prerequisites ==
Line 7:		Line 7:

	=== What to have ready ===		=== What to have ready ===
	An ~~opened firewall directly into the UMS. Typically port 80 or 443~~		An inLogic SMS Modem

	== Installation ==		== Installation ==
	~~See [[Configurator/Webservice]]~~
	=== Template Setting ===		=== Template Setting ===
	Create a ~~BOSS~~ setting than will be attached to a template~~. BOSS can only retrieve data from the templates that have an option attached~~.		Create a welcome setting than will be attached to a template.
	[[File:~~Boss templateeditor~~.png\|none\|thumb]]		[[File:Configurator SMS Welcome.png\|none\|thumb\|791x791px]]

	~~UMS will generate a department code when pressing Generate. department code must be used in BOSS to retrieve data~~.		[[File:SMS Welcome.png\|none\|thumb\|807x807px]]

	== Technical settings ==		== Technical settings ==

	== FAQ ==		== FAQ ==

Kia: Created page with "The integration automatically creates and maintains the school's users in BOSS. BOSS is a barcode / RFID based registration system that links all loans directly to the individ..."

2018-02-22T14:35:30Z

Created page with "The integration automatically creates and maintains the school's users in BOSS. BOSS is a barcode / RFID based registration system that links all loans directly to the individ..."

New page

The integration automatically creates and maintains the school's users in BOSS. BOSS is a barcode / RFID based registration system that links all loans directly to the individual student to the library. The BOSS integration allows BOSS to retrieve data from the UMS web server

== Prerequisites ==

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

=== What to have ready ===
An opened firewall directly into the UMS. Typically port 80 or 443

== Installation ==
See [[Configurator/Webservice]]
=== Template Setting ===
Create a BOSS setting than will be attached to a template. BOSS can only retrieve data from the templates that have an option attached.
[[File:Boss templateeditor.png|none|thumb]]

UMS will generate a department code when pressing Generate. department code must be used in BOSS to retrieve data.

== Technical settings ==

== FAQ ==