Recieve SMS trough SMPP, store it to local SQL

Recieve SMS trough SMPP, store it to local SQL SearchSearch

SMS & MMS Technical Forum » NowSMS Support - SMS Issues (Product Support Only) » Archive through October 31, 2007 » Recieve SMS trough SMPP, store it to local SQL « Previous || Next »
Author Message
Stian Skoglund
New member
Username: Tepose

Post Number: 1
Registered: 07-2007
Posted on Wednesday, July 04, 2007 - 01:03 pm:   

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
Posted on Wednesday, July 11, 2007 - 05:54 pm:   

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

Login Login / Register Logout Logout Search Last 30 Days Topics Topics