CDR Duration

[sjc]

Hi all,
I have written a simple CDR capture Win32 service program which is capturing data very nicely and putting it into our SQL server. I'm concerned though with the call duration data. If I make a call of say 20 seconds and hang up the CDR spits out the data and says the duration was for 7 seconds. Why is this so far out ? It's impossible to gauge real time costs based on incorrect call durations. Does anyone know of why this is happening and how to get it more accurate ?

TIA
sjc

 

[kmerck]

Would you consider making your program public so that other users might test it?

 

[mverkruijssen]

Dit you try capturing the data in Hyper terminal?
This is normally accurate. Our company has a CDR programm based on the output of the Definity.

Could be your programm confuses the positions of the data?

Michel.

 

[sjc]

kmerck - not sure about making it public. I wrote it but it would be owned by my company so it's not as simple as just getting it out there unfortunately.

mverkruijssen - Yes I've tested with a basic comms program to make sure data was coming out correctly and the duration in the CDR is defintiely less than the true duration of the call. No I don't think there is any confusion as the data is exceptionally simple. So you're output is 100% accurate on call lengths ?

 

[europe]

The definity has two output fields, duration and sec-duration.

sec-duration is in seconds, the other output you have to multiply by 6 seconds.

The following info is from the DEFINITY ECS Release 10 Administrator’s Guide:

Duration (duration or sec-dur) — 4 digits
This is the duration of the call, recorded in hours (0–9), minutes (00–59), and to tenths of minutes (0–9). Calls are rounded down in 6-second increments. Therefore, a call of 5-second duration will be indicated as 0 duration. If 9999 appears in this field, this call was in progress when a time change was made in the switch.

You can use the customized record format to have the duration reported in hours/minutes/seconds. This field is called sec_dur.
Please let me know if the information that was provided is helpfull.
Edwin Plat
A.K.A. Europe

 

[mverkruijssen]

It is like my colleque says. I've tested it one more time to be sure, but our programm is 100% accurate.

Good luck with getting it fixed!

Michel.

 

[sjc]

Europe - Your answer pretty much sums up what I'm seeing. if I cnaged to sec-dur it works perfectly. I just picked the wrong duration colunm..doh

Thanks for your help...I now have a valid Call logger

 

[koukouroukou]

i have made a similar program but i dont seem to get login and log out results.Do you know how can i get them?

 

[sjc]

Do you mean the call start and finish times ?

 

[koukouroukou]

no i mean how can i get the login and the log out times of the agent.

 

[arenine]

There is a shareware ($19.95) TGL PortLog - Serial Data Logger that will capture CDR.

I send the CDR (59 char) data to a SQL database and created some ASP to run queries on the data.

Works Nicely

http://www.tglmicro.com/Portlog.htm

arenine