PBX Info :: Your Free PBX, PABX and Telephone Information Resource - View Single Post - How do I export raw SMDR data into SQL on Inter-tel 5000?
Thread: How do I export raw SMDR data into SQL on Inter-tel 5000?
View Single Post
Old 11-24-2007, 10:25 PM   #3 (permalink)
woody
Junior Member

Activity Longevity
0/20 4/20
Today Posts
0/0 ssssssss6
Location: Upstate New York
Rep Power: 0woody is an unknown quantity at this point
Gender:
Country:
I think the easiest way for you to accomplish your goal is to use the diagnostic monitor software inter-tel provides for the 5000. It can capture smdr data to a log file. If you have an in house developer, you could have him code a job to bulk import the logfile a set intervals. This should take a code pounder about 10 minutes to code. You can also bulk import a flat logfile into SQL with the bcp command line utility or the import wizard in SQL management studio (I am assumming microsoft SQL). If not using the diagnostic monitor you can use a terminal program but the 5000 requires a certain hand shake before transmitting smdr, "#0#0#0#32" as I recall. I will look have to check my notes for that.
Last edited by woody; 11-24-2007 at 10:33 PM.
woody is offline   sendpm.gif Reply With Quote