Support forum
Add Reply
Add Topic10:22 am
May 28, 2013
Offline
QuoteYou have to fill in your own MessageGUID or MessageInfo value when you add the message to the database. These
values are not automatically generated by Diafaan SMS Server.
Also, make sure that the fields names are added in the advanced settings of the SQL Connector. Otherwise Diafaan SMS Server will not pick up the value from the MessageOut table and insert them in the MessageLog table. For the 'MessageGUID' field you have to fill in 'MessageGUID' in both the 'SMSOutMessageGuid' and 'SMSLogMessageGuid' settings.
Regards, Henk
9:51 pm
Thanks for the reply... but that is not possible.
MessageGuid and MessageInfo in MessageOut are NULL.
MessageGuid and MessageInfo in MessageLog are empty.
There is a MessageID in MessageLog, but that does not exist in MessageOut.
ie:
MessageOut:
Id MessageTo MessageFrom MessageText MessageType Gateway UserId UserInfo MessageGuid MessageInfo Priority Scheduled ValidityPeriod TLVList IsRead IsSent
13749 1XXXXXXXXXX +1YYYYYYYYYY Dude in Buffalo, let me know you can see this please? sms.automatic BANDWIDTH NULL NULL NULL NULL NULL 2025-05-25 12:28:48.140 NULL NULL 0 1
MesageLog:
Id SendTime ReceiveTime StatusCode StatusText MessageTo MessageFrom MessageText MessageType MessageId ErrorCode ErrorText Gateway MessageParts MessagePDU UserId UserInfo MessageGuid MessageInfo Connector
13888 2025-05-25 12:28:50.513 2025-05-25 16:28:00.000 201 Success: Message received on handset. 1XXXXXXXXXX +1YYYYYYYYYY Dude in Buffalo, let me know you can see this please? sms.automatic 775905c4-0e10-46cd-abb8-453daf0f7cd1 BANDWIDTH 1 0000006C0000000400000000000003350001013133303238303335323434000101313731363634373633303700000000000001000000354475646520696E2042756666616C6F2C206C6574206D65206B6E6F7720796F752063616E20736565207468697320706C656173653F MSSQL Connector
3:20 pm
May 28, 2013
Offline
Hello Hunter,
You can add a custom unique message ID to the messages in the MessageOut table to link the records to the MessageLog table. The best options are either the 'MessageGUID' or the 'MessageInfo' fields. These two fields are not used by Diafaan SMS Server but are copied without change from the MessageOut to the MessageLog table.
Regards, Henk
2:13 am
Hello,
We are trying to obtain the send status of messages, but are unable to find anyway to link MessageOut and MessageLog.
The details are clearly shown in the GUI, but I can find no field possible to link the log entries to the mesage sent.
Assistance is appreciated.
1 Guest(s)