Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

MessageOut Insert WITH SMPP
sp_NewPost Add Reply sp_NewTopic Add Topic
March 19, 2020
3:19 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Adolfo,

The MessageOut database table in the SQL Connector of Diafaan SMS Server is intended for messages than need to be sent out, it is not used to store messages that are sent or received by Diafaan SMS Server.

If you want to store outbound messages from the SMPP Connector or inbound messages from the SMPP Gateway in a database you can use 3 methods:

1. Use one of the SQL Connectors to store all messages in Diafaan SMS Server by setting the option 'Log all messages to SQL Connector ...' in the 'Advanced' page of the general options. This stores the outbound messages in the MessageLog table and the inbound messages in the MessageIn table. With most SQL databases you can use a database trigger to copy specific records from the MessageLog database table to the MessageOut table when you require this for your application.

2. Use the Scripting Gateway with a customized script to store outbound messages from the SMPP Connector in a database and/or use the Scripting Connector with a customized script to store inbound messages from the SMPP Gateway in a database.

3. Use the HTTP callback functionality of Diafaan SMS Server with a custom (PHP) script to store the messages in a database.

Regards, Henk

March 19, 2020
3:58 am

All arrivals via SMPP can be forced into the table MessageOut

this is with the effect of generating actions when the message arrives.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502