Avaya IP Office 500 (CSV). SMDR/CDR data format and connection settings
This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not applicable for other software titles.
Configuring Avaya IP Office

Replacing Avaya Delta Server
Recently Avaya have stripped off Delta Sever application which used to serve as SMDR. Our PBX Data Logger allows to replace this application and is very user friendly.
Configuring PBX Data Logger as a TCP client
Our software should work in the TCP client mode. It means that our software will initiate connection with the PBX and the PBX will work as a server. Add one or several PBX IP addresses here (the IP address of the (none)). The port number should match the port that you have defined within the PBX (180 in the example below).
1. Add a new configuration with the TCP data source (if you didn't it before).

2. Configure the TCP settings as shown below.
Selecting the correct parser for Avaya IP Office 500 (CSV)
Avaya IP Office 500 (CSV)
Avaya IP Office 500 (CSV)
Data items
Description | Data type | Column name |
Call time | datetime | CALL_TIME |
Call data | datetime | CALL_DATE |
Call time only | datetime | CALL_TIME_ONLY |
Call duration | datetime | CALL_DURATION |
Call duration (s) | integer | CALL_DURATION_S |
Ring duration (s) | integer | RING_S |
Ring duration | datetime | RING |
Call type | string | CALL_TYPE |
Direction | string | DIRECTION |
Is internal | string | FLAG1 |
Caller phone | string | CALLER_PHONE |
DNIS | string | DNIS |
Source | string | FLAG4 |
Destination | string | FLAG5 |
Extension | string | EXT |
Dialed phone | string | DIALED_PHONE |
Account | string | ACC |
Call ID | integer | CALL_ID |
Continuation | string | FLAG6 |
Party1 device | string | PARTY1_DEVICE |
Party1 name | string | PARTY1_NAME |
Party2 device | string | PARTY2_DEVICE |
Trunk | string | TRUNK |
Party2 name | string | PARTY2_NAME |
Line | string | LINE |
CO | string | CO |
Party1 name | string | FLAG2 |
Party2 name | string | FLAG3 |
Hold time | integer | HOLD_TIME |
Park time | integer | PARK_TIME |
Auth valid | integer | AUTH_VALID |
Auth code | string | AUTH |
User charged | string | USER_CHARGED |
Call charge | float | COST |
Call charge | string | CURRENCY |
Amount at last user change | float | AMOUNT_LAST_USER_CHANGE |
Call units | string | CALL_UNITS |
Units at last user change | string | UNITS_LAST_USER_CHANGE |
Cost per unit | float | COST_PER_UNIT |
Mark up | string | MARK_UP |
External targeting cause | string | EXT_TARGET_CAUSE |
External targeter ID | string | EXT_TARGET_ID |
External targeter number | string | EXT_TARGET_NUM |
Server IP address of the caller extension | string | CALLER_SERVER_IP |
Unique call id for the caller extension | string | CALLER_CALL_ID |
Server IP address of the called extension | string | CALLED_SERVER_IP |
Unique call id for the called extension | string | CALLED_CALL_ID |
Call time (UTC) | datetime | CALL_TIME_UTC |
Interested in reports for PBX usage?
We offer the PBX Reports utility with various manual, scheduled and email reports, built-in web-server, and other features. Look here
Want PBX call logs in a database?
This is the standard feature. The logger captures exports SMDR or CDR data in real-time to your database. Follow this link
Note: Products and companies mentioned here are used only for definition and identification purposes and can be trademarks and/or registered trademarks of the respective companies.