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.
192.168.1.220
180
192.168.1.220:180
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.