CDR formats for IP Office?

[jruiter]

Greetings,

I've configured my IP Office 412 system to dump CDR's to a linux box. Where can I find an explanation of the various CDR formats, so I can make some sense of the data? I've looked through the IP Office documentation and found some info regarding the various fields in the "enhanced" detail record, but it doesn't say much about field placement, delimiters, etc.

Thanks
Jason

 

[mlinman]

If you go into help on IP Office Manager, at the bottom in the appendix is a section on CDR record formats.

 

[ProviderReborn]

http://marketingtools.avaya.com/kno...edProjects/manager/cdr/cdr_record_formats.htm

Does this help at all

ACA - IP Office Implement
ACA - IP Telephony
ACS - IP Office Implement (Aug 30th)

 

[ProviderReborn]

Some more info:

he following list describes the fields which, depending on the selected report format and options, may be included in the CDR records.

Those fields shown in italics are not supported by IP Office CDR. Where the report format includes such a field, the data is replaced by a space or spaces. Similarly fields not appropriate to the call type are replaced by a space or spaces as appropriate.

*

Access Code Dialed
The access code the user dialed to place an outgoing call. On IP Office this will be the digit used to trigger secondary dial tone if used.
*

Access Code Used
The number of the line used for an outgoing call.

*

Account Code
This field may contain a number to associate call information with projects or account numbers. For some formats, a long account code overwrites spaces on the record that are assigned to other fields.
*

Attendant Console - Not supported by IP Office CDR.
*

Authorization Code - Not supported by IP Office CDR.
*

Bandwidth - Not supported by IP Office CDR.
*

BCC (Bearer Capability Class)
This field identifies the type of ISDN call. Any one of the following may appear in this field.
*
o

0 = Voice Grade Data and Voice.
o

1 = Mode 1 (56 Kbps synchronous data).
o

2 = Mode 2 (less than 19.2 Kbps synchronous or asynchronous data).
o

3 = Mode 3 (64 Kbps data for LDAP protocol).
o

4 = Mode 0 (64 Kbps data clear).
*

Calling Number
For outgoing or intra-switch calls, this field contains the extension number of the originating telephone user. For incoming and tandem calls, this field contains the trunk access code in standard formats. The fifth digit is the first digit of a 5-digit dialing plan. In formats where the field is less than 7 digits, this also shows the trunk access code of the incoming call.

This field shows the calling party number in Unformatted or Expanded records. If the calling party number is not available, this field is blank for both formats.

*

Calling Number/Incoming Trunk Access Code
For incoming calls this field contains the incoming trunk access code. For outgoing calls, this field contains the calling extension.
*

Carriage Return
The ASCII carriage return character followed by a line feed indicates the end of a call record.
*

Condition Code
The condition code indicates what type of call the record describes. For example, condition code C indicates a conference call, 7 indicates an ARS call, etc. The table below shows condition codes for most record formats. The 59-character format uses different condition codes from those used for other record types.

Code


59


Description

0


-


Identifies an outgoing intra-switch call (a call that originates and terminates on the switch).

9


I


Identifies an incoming external call.

A


-


Identifies an outgoing external call.

C


L


Identifies a conference call.

E


N


An incomplete external call, due to all trunks being busy or out of service. Incoming trunk calls to a busy terminal do not generate a CDR record.

G


-


Indicates a call terminating to a ringing station.

H


-


Indicates that a ringing call that was then abandoned.

I


-


Indicates a call attempt to a busy station.

CDR can also record the ring time to answer or abandon for incoming calls originated by the trunk group. In addition, CDR indicates if the incoming destination is busy. This record is separate from the normal call duration record printed for an answered call. This information is indicated by the condition code.

When an incoming call is terminated to an internal destination, the call is tracked from the time ringing feedback is given to the originator. If the call is answered, a CDR record is printed with the condition code G and the duration reflects the time between the start of ringing and the answer of the call. If the call is abandoned before being answered, the system prints a record with the condition code H and the duration reflects the time between the start of ringing and the time the call was abandoned. If the destination is busy, a CDR record is printed with the condition code I and a duration of 0.

*

Dialed Number
This field contains the number dialed. If it is an outgoing call, the field contains the number dialed by a system user. If it is an incoming call, the field contains the extension that was dialed. If more than 18 digits are dialed, the least significant digits (starting from the right) are truncated.

*

Duration
This is the duration of the call or call segment. It is recorded in hours, minutes and tenths of minutes. 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.
*

Feature Flag
1 for a data call, 0 for voice calls.

*

Format Code - Not supported by IP Office CDR.
*

FRL - Not supported by IP Office CDR.

*

Incoming Circuit Id.
This field identifies the trunk used for an incoming call. For outgoing calls this field is blank.
*

Incoming Trunk Access Code
This field contains the access code of the incoming trunk group.
*

ISDN Network Service - Not supported by IP Office CDR.

*

ISDN CC - Not supported by IP Office CDR.
*

IXC (Interexchange Carrier Code) - Not supported by IP Office CDR.

*

Line Feed
The ASCII line feed character follows a carriage return to terminate CDR records.
*

MA-UUI (Message Associated User-to-User Signaling) - Not supported by IP Office CDR.
*

Node Number - Not supported by IP Office CDR.
*

Null
Used to terminate and divide CDR Records (usually in triplets) when needed.
*

Outgoing Circuit Id.
For outgoing calls, this field identifies the trunk used.
*

Packet Count - Not supported by IP Office CDR.
*

PPM (Periodic Pulse Metering) - Not supported by IP Office CDR.
*

Resource Flag - Not supported by IP Office CDR.
*

Space
The ASCII space character separates other CDR fields or fills unused record locations.
*

TSC Flag - Not supported by IP Office CDR.

*

Time
This fields contains the time that the call ended, or the time that a user dropped from a multi-party call.




ACA - IP Office Implement
ACA - IP Telephony
ACS - IP Office Implement (Aug 30th)

 

[jruiter]

That's what I found in the documentation. what it doesn't tell me is what fields I can expect to find this info in, what the field lengths are, and how I can tell everything apart.

The documentation mentions several other CDR formats (LSU, TeleSeer, etc), but I have been unable to find any detailed information about the format or how to parse it.

Thanks

 

[mlinman]

Open up IP Office Manager
Click Help
Click Contents
Open Appendix CDR Records
Open Record Formats
It will list all of the CDR formats, open one and it will display a field list and what char postion the field is at.

This is how I found them for my custom app.