Integrating database app with SMS

Integrating database app with SMS SearchSearch
Author Message
Olaf
Unregistered guest
Posted on Wednesday, January 28, 2004 - 10:25 am:   

Potential customer want to do the following, and want to know the best/easiest way to do it:

1. Database app. selects a number of recipients and a message text and sends this message as sms to the selected recipient's phone numbers.

2. Recipients are requested to respond to the sms by a return sms message. These return messages, identified by the sender's phone number should be picked up by the application and put into the database with the phone numbers as the keys.

Hope someone could suggest good ways to do this.

Thanks.
Bryce Norwood - NowSMS Support
Board Administrator
Username: Bryce

Post Number: 1740
Registered: 10-2002
Posted on Wednesday, January 28, 2004 - 07:13 pm:   

Olaf,

It's going to take some scripting to interface with the database.

Basically for #1, the database app needs to trigger an HTTP request to send an SMS message through the gateway.

For #2, the gateway is going to call a configurable HTTP script (or it could be an executable command line program) when it receives an SMS message. The senders phone number, and the text of the message are passed as parameters in the message. So the HTTP script (or command line program) could update the database accordingly.

The specifics do depend on the scripting language that is used. (We do have some PHP examples ... http://support.nowsms.com/discus/messages/1/867.html is a simple one for sending SMS.)

For receiving SMS, there is a command line example in the following thread: http://support.nowsms.com/discus/messages/1/333.html

And the documentation is at http://www.nowsms.com/documentation/ProductDocumentation/2_way_sms_support.htm.