| Recieve SMS trough SMPP, store it to local SQL |  Search
|
|
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through October 31, 2007 ⬆ |
◄ ► |
| Author | Message | |||
| Stian Skoglund New member Username: Tepose Post Number: 1 Registered: 07-2007 |
This might be newbie question, but here it goes  I want my customers be able to connect, and send their SMS to us trough SMPP. All messages received should be stored in a local MSSQL database. is this possible. If yes, how/or what is the best solution. | |||
| Bryce Norwood - NowSMS Support Board Administrator Username: Bryce Post Number: 7348 Registered: 10-2002 |
Hi, Actually, that's a good question. However, it's a bit tricky to answer, because it depends somewhat on the specifics. I'm assuming that you are going to be relaying SMS for your customers. My assumption is that you want to accept the message from them via SMPP, log it to an MSSQL database, and then relay the message for actual delivery. I should explain that NowSMS does not have any direct integration links into MSSQL or any other databases. However, NowSMS provides a very flexible callback interface that allows you to provide the glue to interface to your database. Basically, you can configure an HTTP script callback to be called every time one of your users submits a message. You can use whatever web server and scripting language that you are familiar with to interface this information with your database. We call this the "accounting callback" interface, and it is described here: http://www.nowsms.com/support/bulletins/tb-nowsms-001.htm That document is a little outdated (it is over 4 years old and could use an update). The basic information in the document is correct, however the document does not mention additional parameters that are also included in the accounting callback. The SMSSendAccounting callback contains additional parameters beyond those mentioned: Binary (1 if binary), PID, DCS, UDH, Data and Text (Data contains a hex string of the message if binary, otherwise Text contains the text of the message). -bn | |||
