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 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

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 Aastra Intelligate). The port number should match the port that you have defined within the PBX (1080 in the example below).

TCP Client Mode - Aastra Intelligate
1080
1080

Data items

DescriptionData typeColumn name
Ticked IDintegerTICKED_ID
Serial IDintegerSERIAL_ID
Sequence IDintegerSEQUNCE_ID
PBX IDintegerPBX_ID
User IDintegerUSER_ID
SubscriberstringSUBSCRIBER
NamestringNAME
AccountstringACC
DirectionstringDIRECTION
DestinationintegerDEST
Destination namestringDEST_NAME
Call typestringCALL_TYPE
Call type namestringCALL_TYPE_NAME
HandlingintegerHANDLING
Handling namestringHANDLING_NAME
Call datedatetimeCALL_DATE
Call timedatetimeCALL_TIME_ONLY
Call date and timedatetimeCALL_TIME
Ring (sec)integerRING_S
RingdatetimeRING
Call duration (sec)integerCALL_DURATION_S
Call durationdatetimeCALL_DURATION
CostfloatCOST
PulsesintegerPULSES
PBXstringFLAG1
Node IDstringFLAG2
BoardstringFLAG3
PortstringFLAG4
ExtensionstringEXT
Channel groupintegerFLAG5
Caller phonestringCALLER_PHONE
Caller phone 2stringCALLER_PHONE2
Dialed phone 1stringDIALED_PHONE1
Dialed phonestringDIALED_PHONE
PBX hopsintegerPBX_HOPS
Orig subscriberstringFLAG6
Orig user IDintegerORIG_USER_ID
TicketsintegerTICKETS
CompleteintegerCOMPLETE

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.