SMPP Support Needed: Troubleshooting & Configuration

Job ID: 38208442

Budget: $30 – $250 USD

I am looking for Kannel SMPP expert for configuration changes and on-going support.
We already have a working kannel-smpp setup. Messages are being delivered and DLRs also tracked. We have SQL Box setup.

Current process:
- We write messages in a sms_queue table with all details (default)
- SQL Box reads messages from sms_queue table and writes the data in sent_sms_queue table.
- DLRs are also saved in separate rows in sent_sms_queue table.

Problem:
We have multiple admin accounts from which we are sending sms into sms_queue table. In the current default setup, we are not able to track the campaign/ account id for reporting purposes.

Proposed Solution:
- If we can add a custom identifier(client/ account id) for who has sent the sms in sms_queue table.
- if the same identifier can be displayed for sent messages and delivery reports in sent_sms_queue table.

OR if you have a better solution wherein we can effectively track the accounts from which the SMS are sent and delivered/ failed etc.


Other than this work, we also need regular support including but not limiting to:
- Setup Kannel SMPP so our clients can send us sms via SMPP directly and we can route it to Telco's SMPP. All DLRs etc should be reflected too.
- Some process where we can monitor how many sms are sent via which SMPP, success rate/ failures etc.
- May be have the daily summary in another table (our main DB) for monthly/ weekly/ daily summary.

We have wasted some time already working with Novice developers and those who can only do the default configurations. I am trying to connect to a developer who has expertise in optimizing and configuring custom setups within Kannel's SMPP scope.

Thanks, Bipul