So I am trying to put together an application for a client where I need to associate calls as they come through Voicemail with calls in the SMDR file generated by Delta Server. I want to link everything in a database by the Call ID column in the SMDR output, which corresponds with the $CID variable in VM Pro. Basically, I will have the VM Pro database interface entering information, and I will need to associate it with the SMDR records as well for additional information about the call.
Here is the problem, when you reboot the switch, the Call ID resets back to 1. So basically, if you were to reset the switch multiple times in 1 day for whatever reason, you could have multiple Call ID and date matches for different calls. Not to mention the fact that if you execute a transfer, it sets the Continuation bit and another duplicate Call ID is created. So I am banging my head off the wall trying to figure out a fullproof way of associating these records. There has to be a way because Call Accounting systems don't seem to suffer from switch resets, at least not that I have noticed. How do I keep each call record grouped together properly, any ideas?
Here is the problem, when you reboot the switch, the Call ID resets back to 1. So basically, if you were to reset the switch multiple times in 1 day for whatever reason, you could have multiple Call ID and date matches for different calls. Not to mention the fact that if you execute a transfer, it sets the Continuation bit and another duplicate Call ID is created. So I am banging my head off the wall trying to figure out a fullproof way of associating these records. There has to be a way because Call Accounting systems don't seem to suffer from switch resets, at least not that I have noticed. How do I keep each call record grouped together properly, any ideas?