Call index on CDR (DEFINITY G3 system)

[Eliav]

Hi all
I have a problem, after I mange to produce CDR from our switch I can't find a field as call index (or number) - I’m looking for a unique field that will help me distinguish between deferent calls and to determine what record belongs to each call

Thanks for your help
Eliav

 

[edgarrc]

I don't know the Avaya's solution for using CDR, but what we did was a Data Transformation Service in MS SQLServer 2000 that captures the cdr information and inserts it in a table that have an auto-increment field (index), then delete the CDR file.

You may develop this with any database, including ACCESS, using Macros for example.

I don't know if I helped, but I think that your solution is more than a "change sys cdr" configuration. I know that these CDR files are not good to be readed.

Edgar

 

[Eliav]

Hi Edgar
Thanks for your replay.
As you said, I already did this solution but in that case when two different calls enter the switch and one call is ended the DB will not be able to determine to which call the ending event is associated.
The problem is that we don't have the dialed number (it is an international number and the switch does not show it)
Any other ideas?
Eliav

 

[edgarrc]

I don't receive two records for the same call here, from different events. All I have is a CDR.in file that contains information about the call when it's was started and it's duration (with other informations like calling number). Of course, this information in avaiable only when the call was ended, so, it's not "real time".

Are you working with cdr.in cdr.out files? Or are you receiving the cdr data directly from a tcp/ip connection? (or something like that).

Edgar

 

[Eliav]

Hi Edgar
We change the switch configuration (in order to receive data about abandoned calls) so we get an event when the call is answer and another event when the call is ended.
And we are capturing the CDR from COM1 to our parser.
Eliav

 

[edgarrc]

Considering that you have records with information about abandoned calls, I have no idea on how to help you. If the call was answered then you may use the station number (or any other information) to exclude other records and make some reference.

If there is any data item that repeat on these events, with the same value, and are unique for that specific time, you may try to relat these records (like a station that can't handle multiple calls on the same time. If you receive an event with information that a call was released then you may to consider that the previous event, answer, on that station, was for the same call of the released, even if there's no called num or calling num).

My english is not very good to say what I'm thinking, but I hope you find a better solution.

Edgar

 

[Bobg1]

Eliav
On your trunk group forms do you have
CDR Reports set to y?

 

[Eliav]

Hi
As i said before - in order to get the abandoned call event we change the CDR report field to "r" - this allows us to get the abandoned call event.
Eliav