| Database Interface |  Search
|
|
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through September 15, 2003 ⬆ |
◄ ► |
| Author | Message | |||
| Rajesh |
Hi I have database of my Consumers Mobile numbers in SQLServer tables , i need to send Customized SMS to them . How can i do this ? Regards Rajesh | |||
| Bryce Norwood - NowSMS Support (Bryce) |
Rajesh, We don't have a generic type of database interface. But typically you can use a scripting language of your choice to extract the numbers from your database, and then from your script, you would issue HTTP GET (web) requests to the NowSMS gateway to send the messages. -bn | |||
| Tony |
its easy , so if u whant i can help you Tony | |||
| mcongosto |
Can you post an example of this? I was thinking using framesets, but HHTP GET sounds like a more elegant solution. Of course the objective is to avoid users to see the actual URL, giving them full control of the gateway. Thats makes my think if the gateway shouldn't be more secure. Regards an thanks. | |||
| Eugene |
I would like some assistance regarding the SMS text manipulation. I intend to use NowSms so that i am able to update my database and send some status report to the senders mobile phone. Could anyone confirm to me that using the NowSms utility i am able to have control over the received message and use it withing my database like oracle or Ms Access?. | |||
| Bryce Norwood - NowSMS Support (Bryce) |
Eugene, Typically the way that this works is that on the "2-way" page of the NowSMS configuration dialog, you would define a command that processes received messages. While you can create an executable command that runs on the NowSMS gateway itself, I find it easier to define an HTTP command instead ... so the command to execute would look something like this: http://192.168.1.100/receivesms.asp?Sender=@@Sender@@&Recip=@@Recip@@&Message=@@FullSMS@@ When NowSMS receives a message, it would connect to the web server at "192.168.1.100", and it would issue a request for "receivesms.asp", and that request would include the phone number of the sender, the phone number of the recipient (recipient phone number is something of interest mainly in environments with multiple GSM modems or with an SMSC connection), and the text of the SMS message. To send a response back to the received message, you have several choices of how to do this: 1.) If every message that you receive will get a response, then check the option for "Command returns response text", and your script should return a response using the content type "text/plain". 2.) If only some messages will receive a response, then you may want to use the approach described at the following link: 2-Way SMS Returning a Non-Text Response 3.) As an alternative to using the redirect responses described in #2, you can also issue your own HTTP requests directly. A link to another message here on this board talks about some considerations for doing this from ASP: Now SMS API Discussion -bn | |||
