Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozeki.hu
Tel.: +36 1 371 0150
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

4.4 E-mail to SMS Contents | Search5.1 Performance

Home > Product Manual > FAQ > 4.5 Autoreply database

SMS Gateway SMS Gateway Home

Solutions:

If you are insterested in how to setup automated SMS notifications, you should apply one of the following configurations:

SMS through HTTP requests
SMS from E-mail
SMS from the command line
SMS using txt files


If you are a software developer you can proceed to adding SMS functionality to your source code by clicking on one of the following links:

PHP SMS example
C# SMS example
ASP SMS example
SQL SMS example
Delphi SMS example

If you would like to send and receive SMS messages from MS Office applications, please check out the following links:

Send SMS from MS Excel
Send SMS from MS Outlook
Check out Ozeki SMS Client

 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

Autoreply database

Can I return a random row from a database table when an SMS comes in?
 

Yes, you have to create a query in the autoreply SMS script file that returns a random row.

You can return a random row using the ORDER BY part of the SQL selec that is used to query the response. Each database server provides random ordering, but each requires different SQL syntax. Here is the syntax you can use:

Select a random row with MySQL:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Select a random row with PostgreSQL:
SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Select a random row with Microsoft SQL Server:
SELECT TOP 1 column FROM table
ORDER BY NEWID()

Select a random row with IBM DB2
SELECT column, RAND() as IDX
FROM table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY

Select a random record with Oracle:
SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1

Can I execute more then one SQL statements if an SMS comes in?

 

Yes, you can put multiple SQL commands into the Autoreply script.

The autoreply script can execute several SQL statements when an SMS comes in. Each SQL statement must be written on a single line. You can use this functionality to update data inside your database based on the contents of an incoming message, and then you can execute a SELECT query to return the results in a response SMS message.



Contents at a Glance:

1.1 SMS basics, Introduction to SMS messaging
1.2 Why is SMS so successful?
1.3 Example applications of SMS messaging
1.4 SMS number formats used in sending and receiving
1.5 What kind of messages can I send to a mobile device?
1.6 What is a Short Message Service Center (SMSC) or an SMS message center?
1.7 What is an SMS Gateway or an SMS application gateway?
1.8 What is a two way SMS system?
2.1 What are the prerequisites for setting up an SMS gateway?
2.2 What are the network requirements of an SMS gateway?
2.3 General Information about Ozeki NG SMS Gateway
2.4 How can I setup SMS routing for incoming and outgoing SMS messages?
2.5 What kind of message types can I use?
2.6 What kind of SMS Delivery reports are returned for submitted SMS messages?
3.1 How can I send and receive SMS messages through a GSM modem or GSM phone connected to a PC?
3.2 What is the Short Message Peer to Peer Protocol (SMPP)?
3.3 What is the Computer Interface Message Distribution Protocol (CIMD2)?
3.4 What is the Universal Computer Protocol / External Machine Interface (UCP/EMI)?
3.5 SMS messaging over the HTTP protocol
3.6 How can I send SMS messages through SMTP?
4.1 What kind of SMS APIs are there?
4.2 Is sending SMS from SQL possible?
4.3 How can I setup an HTTP to SMS configuration?
4.4 How can I setup an E-mail to SMS solution?
4.5 Can I send automatic SMS reply from a database?
5.1 How can I configure an SMS gateway for best performance?
5.2 What kind of logs are maintaned in the SMS gateway?
5.3 What kind of errors do I have to perepare for in the SMS gateway?
5.4 Can I setup reporting and cost control in the SMS gateway?
6.1 Is there a trial version available? What are the limitations?
6.2 What kind of licensing options do I have?




Next page: 5.1 Performance