Manually sending individual or bulk SMS messages - Revision history

Catriona: Marked this version for translation

2014-09-01T10:58:51Z

Marked this version for translation

Catriona at 10:58, 1 September 2014

2014-09-01T10:58:30Z

Angus: /* Web site interface */

2014-07-22T09:13:16Z

‎Web site interface

Angus at 09:11, 22 July 2014

2014-07-22T09:11:38Z

Angus: Created page with "=Sending SMS messages= There are two possible ways to send SMS messages from the server (either to an individual, or to a group of users): using the Web site interface in the ..."

2014-07-22T03:11:27Z

Created page with "=Sending SMS messages= There are two possible ways to send SMS messages from the server (either to an individual, or to a group of users): using the Web site interface in the ..."

Halaman baru

=Sending SMS messages=
There are two possible ways to send SMS messages from the server (either to an individual, or to a group of users): using the Web site interface in the Administration section, or using a direct SQL connection to the database.

==Web site interface==
* Log in to iSIKHNAS as an administrative user
* Go to Administration | SMS metadata | Send SMS Message(s)

@@ Baris 1: / Baris 1: @@
 <languages/>
 <translate>
-=Sending SMS messages=
+=Sending SMS messages= <!--T:1-->
 There are two possible ways to send SMS messages from the server (either to an individual, or to a group of users): using the Web site interface in the Administration section, or using a direct SQL connection to the database.
-==Web site interface==
+==Web site interface== <!--T:2-->
 * Log in to iSIKHNAS as an administrative user
 * Go to Administration | SMS metadata | Send SMS Message(s)
@@ Baris 20: / Baris 20: @@
 ** Click send
-==Manual sending via direct database insert==
+==Manual sending via direct database insert== <!--T:3-->
 Administrators with appropriate database privileges can send messages by directly inserting them into the SMS outbox table on the database, using a message id of '0'. The table is checked periodically for any messages with an ID of zero, which are then automatically sent.
 To insert messages into the table, use the following generic SQL structure:
-  insert into outbox (phone, message, msgid, createdby)
+  <!--T:5-->
   select
      phone,
@@ Baris 38: / Baris 40: @@
   -- and groupid = 4 -- filter for a specific user group
 '''Be very careful of this approach as poorly formed SQL can accidentally generate very large numbers of messages.'''
 </translate>

@@ Baris 1: / Baris 1: @@
 =Sending SMS messages=
 There are two possible ways to send SMS messages from the server (either to an individual, or to a group of users): using the Web site interface in the Administration section, or using a direct SQL connection to the database.
@@ Baris 36: / Baris 38: @@
   -- and groupid = 4 -- filter for a specific user group
-Be very careful of this approach as poorly formed SQL can accidentally generate very large numbers of messages.
+'''Be very careful of this approach as poorly formed SQL can accidentally generate very large numbers of messages.'''

← Revisi sebelumnya		Revisi per 22 Juli 2014 09.11
Baris 5:		Baris 5:
	* Log in to iSIKHNAS as an administrative user		* Log in to iSIKHNAS as an administrative user
	* Go to Administration \| SMS metadata \| Send SMS Message(s)		* Go to Administration \| SMS metadata \| Send SMS Message(s)
		+
		+	==Manual sending via direct database insert==
		+	Administrators with appropriate database privileges can send messages by directly inserting them into the SMS outbox table on the database, using a message id of '0'. The table is checked periodically for any messages with an ID of zero, which are then automatically sent.
		+
		+	To insert messages into the table, use the following generic SQL structure:
		+
		+	insert into outbox (phone, message, msgid, createdby)
		+	select
		+	phone,
		+	'Message to send',
		+	0,
		+	2 -- id of the current user (person creating the messages)
		+	from users u
		+	where not u.del
		+	and phone is not null
		+	and left(phone,2) = '62' -- only numbers in Indonesia
		+	-- add any other filters here. For example
		+	-- and groupid = 4 -- filter for a specific user group
		+
		+	Be very careful of this approach as poorly formed SQL can accidentally generate very large numbers of messages.