Storing SMPP Message id details within ACM Delivery Logs

[richac96395021]

Hi team,

Can we store the Message ID generated from the SMS Vendor within ACM Delivery receipt/Delivery Logs. Currently we are using SMPP Protocol to send the SMS.from ACM.  We are getting the DLR from the SMS Vendor in following format:-

2019-03-25|14:06:31|SRC:9180012386035|DST:VK-XYZUVW|SMS:id:29892980123001E3  sub:001 dlvrd:001 submit date:1903251405 done date:1903251406 stat:DELIVRD err:000

But within Delivery Logs we only get the delivery status message as follows:-

SR Generic DELIVRD 000|#MESSAGE#

Can the Delivery Status Message store the message id

with regards,

Richa Chaubey

[Adhiyan · Accepted solution]

Hello Richa,

This message ID from the provider is stored in the table nms:providerMsgId.

The part before the _1530925964 is the provider message ID.

Regards,

Adhiyan

[richac96395021]

Hi Adhiyan,

Thanks for the update, In case of Hybrid Implementation nms:providerMsgId schema is not populated in marketing instance, can this data be synced to on-premise Marketing instance from mid-sourcing.

with regards,

Richa Chaubey