CDR to SQL

[sllimr]

Hi,

I've been hunting around looking for a product or application that can take the CDR data from an IP Office and dump it real time to an SQL server. All i've managed to find so far is that somebody a long time back wrote one (found it on google groups) but the link is dead and the yahoo group gets me nowhere...

Any chance anyone on here knows of anything in the market?

Thanks

Rupert

 

[bigjerms]

you looking for smdr data to sql.

I also would like something like this.

Someone posted that their company had one written in vb.net, but never posted it.

You might try contacting some of the companies that make call accounting software such as tapit.

 

[sllimr]

Thanks, what i'm really trying to do is find something that can update a database with the current status of each phone so that I can build a simple display window that when queried will show me who is on the phone, how long for etc etc.

I'll look into the smdr data.

Rupert

 

[mattKnight]

so that I can build a simple display window that when queried will show me who is on the phone

It won't ever work as SMDR is only generated at the end of the call; by the time you get the SMDR they are no longer on the phone...

3rd Party TAPI gives you real time information, if you insist on writing you own system. You might look at CCC (ok I know £££) or CBC (£)

Take Care

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

 

[intrigrant]

If you can write your own software then try this:

Create a user named "DTEDefault", no extensionnumber or anything and put the following as a trustednumber "AT%CCID=5"
Reboot IP Office and connect your PC to the DTE port of the IP Office, .
Start Hyperterminal with the settings "38400,8,N,1" and the IPO will output all events to the serial port like this :
CALL: 5.1.1 State=0 Cut=1 Music=0.0 Aend="Line 5" (2.1) Bend="" [] (0.0) CalledNum=123456789 ()CallingNum=0987654321 () Internal=0 Time=0 AState=0

The Aend is the user dialling a number or a incoming trunk and the Bend is the outgoing trunk or receiving user.

Maybe its what you need.

 

[latitude12]

Sounds like you should just use Call Status

 

[Francis999]

Using tftp you can get the call status data every x seconds the only thing is that you need to get the encrypted password using a packet sniffer....

The other way is to use devlink.dll.. there is some sample codes for C++ and Delphi available in the documentation. Take a look at this PDF

http://support.avaya.com/elmodocs2/ip_office/R3.1/devlinken.pdf

 

[spotless]

Or you can try RSI's Visual Rapport that uses TAPI for employee statuses (

http://www.telecost.com/avaya).

This product does screen pops using scripting. Thetefore, you can adapt it to your application.

Regards,
S16