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).
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).
1080
1080
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 |
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.
