Aastra Intelligate (tab). 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.

OIP server

The call data is stored as a file on the OIP server if so selected during the user-defined installation of the OIP server. In the standard settings a new file is written daily in the directory ...\aastra\oip\tax. The files are created in .csv format. The file name is taxdata-jjjj-mm-dd.tax, with <jjjj-mm-dd> representing year-month-day. The Call Logging settings can be made in the OIP service Call Logging Driver.

In this case you can create the "File" data source in our software and process "tax" files.

Call logging over IP

The PBX can send the SMDR directly to the Advanced PBX Data Logger. Look at the settings below (Aims, AMS for Aastra 400).

Aastra Intelligate Settings

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 (1080 in the example below).

1. Add a new configuration with the TCP data source (if you didn't it before).

TCP/IP Data Interface

2. Configure the TCP settings as shown below.

192.168.1.220

1080

192.168.1.220:1080

Selecting the correct parser for Aastra Intelligate (tab)

Aastra Intelligate (tab)

Data items

Description	Data type	Column name
Ticked ID	integer	TICKED_ID
Serial ID	integer	SERIAL_ID
Sequence ID	integer	SEQUNCE_ID
PBX ID	integer	PBX_ID
User ID	integer	USER_ID
Subscriber	string	SUBSCRIBER
Name	string	NAME
Account	string	ACC
Direction	string	DIRECTION
Destination	integer	DEST
Destination name	string	DEST_NAME
Call type	string	CALL_TYPE
Call type name	string	CALL_TYPE_NAME
Handling	integer	HANDLING
Handling name	string	HANDLING_NAME
Call date	datetime	CALL_DATE
Call time	datetime	CALL_TIME_ONLY
Call date and time	datetime	CALL_TIME
Ring (sec)	integer	RING_S
Ring	datetime	RING
Call duration (sec)	integer	CALL_DURATION_S
Call duration	datetime	CALL_DURATION
Cost	float	COST
Pulses	integer	PULSES
PBX	string	FLAG1
Node ID	string	FLAG2
Board	string	FLAG3
Port	string	FLAG4
Extension	string	EXT
Channel group	integer	FLAG5
Caller phone	string	CALLER_PHONE
Caller phone 2	string	CALLER_PHONE2
Dialed phone 1	string	DIALED_PHONE1
Dialed phone	string	DIALED_PHONE
PBX hops	integer	PBX_HOPS
Orig subscriber	string	FLAG6
Orig user ID	integer	ORIG_USER_ID
Tickets	integer	TICKETS
Complete	integer	COMPLETE

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.