 How do I export raw SMDR data into SQL on Inter-tel 5000?
Our company is upgrading from Inter-tel Axxess to the 5000. The problem is the 5000 no longer supports serial communication. We currently use a program called Serial Logger Service (you can Google for that if you want to see it) to capture data in real time over the serial port and export each SMDR line into a SQL database via an ODBC connection as well as create a text log file. This was an inexpensive program that was designed to do nothing else but this. We already have our own custom in-house call accounting application so we don't to buy software to do anything else except export the SMDR to a database.
Unfortunately we have not yet found any similar software to export SMDR logs out of an IP-based PBX system into a database. The closest I found was one that will create a text file of the logs, but not send it to a database. Does anyone have any suggestions on a piece of software to use or any other alternatives?
We have also considered finding an application that could export the IP data to a virtual serial port, after which our current logger can take over. Unfortunately most applications only seem to convert data from serial to IP, not the other way around. One potential one we tested simply didn't seem to work correctly at all.
Any help would be appreciated. |