Does anyone have a smdr to sql interface

[bigjerms]

Does anyone have an existing smdr to sql interface.

I use mysql for my database and am trying to get call duration information for some reports I'm doing.

I don't think IP office will write to a database when a call is lost or hung up so I figure I'll have to get the info from the smdr or delta server.

Does anyone have any good ideas on how to do this.

Is there a way to have the smdr record go directly into an sql database, with a little code? Any applications that will do this?

 

[mattKnight]

The delta server creates a CSV file, so you should be able to do an import of that using DTS (part of SQL) on a scheduled basis

Take Care

Matt
If at first you don't succeed, skydiving is not for you.

 

[jmansford]

We wrote a quick .NET service application that connects to the IP Office Delta Server on the SMDR Port interface.
This is very simple to use, to get an idea telnet on to the interface using something like "telnet IPOFFICE 8082" you will see you get the same format as the SMDR except it pumps a row at the end of every call.

We also log to a CSV file and use that if the service stops for any reason. You have a unique rowID which you can use to decide if you have enterred it already or not.

I will see if we are able to release the source code, if so let me know how I can get it to you. I'm happy to post it here if there is a way of doing it!

 

[bigjerms]

Apparently Tek-Tips doesn't like us giving out email or phone info. So I don't know how I'm supposed to give you my info for getting the source code?

Any good ideas on how to do this?

---bigjerms