Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

How to check the SMS Count
sp_NewPost Add Reply sp_NewTopic Add Topic
August 28, 2013
11:53 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Sarfaraz,

The number of message parts is logged in the internal send log of Diafaan SMS Server but unfortunately this information is not forwarded to the SQL Connector. If you right-click on the send log and select "Export to file", one of the fields is labeled "MessageParts" and this contains the actual amount of SMS message parts sent for each exported message.

However, the MessageLog table in the SQL Connector does have an (optional) field named "MessagePDU". This field contains all message parts (PDUs) sent by Diafaan SMS Server for that message, separated by comma's. If you count all PDUs in this field you have the number of message parts sent by Diafaan SMS Server.

Regards, Henk

August 28, 2013
6:04 pm

Hello Henk,

How you are good. I have a small query regarding the SMS Count. When we are pushing the SMS to the Gateway if the message is more than 160 characters or above in the MessageLog the full SMS content is been added as one record which is very good but to tally the SMS count it becomes a little difficult so is there any method to store or know that this SMS was of 2 or 3 parts.

Please let me know.

Sarfaraz Kasmani

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
14 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 678

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3929

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502