Splicecom Maximiser. 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 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 (4001 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.

TCP Client Mode - Splicecom

192.168.1.220

4001

192.168.1.220:4001

Changing the Call Logging Password

The Call Logging Password configurable in PBX can be used to protect access:

  1. From the Management information list select System
  2. Beside the Call Logging Password field click on Change
  3. In the Script Prompt enter the password required
  4. Select OK
  5. Re-enter your password to confirm the change
  6. Select OK
  7. Submit the change

No logging output will occur without the Call Logging password being sent Advanced PBX Data Logger. So, you should activate the data query plugin and specify the password (fig. 2,3)

Figure 2

Figure 3

Data items

DescriptionData typeColumn name
Call timedatetimeCALL_TIME
Cost centre (user or department)stringFLAG1
Trunk (B)stringTRUNK_B
Trunk (A)stringTRUNK_A
Call typestringDIRECTION
TrunkstringTRUNK
ExtensionstringEXT
Caller numberstringCALLER_PHONE
Caller namestringFLAG3
Dialed number (A)stringDIALED_PHONE
On behalf of (B)stringONBEHALFOF_B
Name (B)stringNAME_B
Number (B)stringNUMBER_B
Call duration (s)integerCALL_DURATION_S
Call durationdatetimeCALL_DURATION
Connected time (s)integerCONNECTED_TIME
Ring durationdatetimeRING
Account namestringACC
Account numberstringFLAG5
Connected statusstringFLAG6
Informational Field (B)stringREM_B
Original cost centrestringORIG_COST_CENTRE
Call Record GUIDstringFLAG2
Secondary transferred callstringTRANSFERED_CALL
Transferred call GUIDstringTRANSFER_CALL_GUID
Queuing timestringQUEUING_TIME
Distributing timestringDISTRIBUTING_TIME
Agent ringingstringAGENT_RINGING
Call timedatetimeCALL_TIME_GMT
Dialed number (B)stringDIALED_B
Outgoing call (B)stringOUT_B
Cost centre (B)stringCOST_CENTRE_B
Informational Field (A)stringREM_A
On behalf of (A)stringONBEHALFOF_A
Remote name (A)stringREMOTE_NAME_A
Remote name (B)stringREMOTE_NAME_B
Customer IDstringCUSTOMER_ID
Tariff IDstringTARIFF_ID
Reason code (A)stringREASON_CODE_A
Reason code (B)stringREASON_CODE_B
On behalf of number (A)stringONBEHALFOF_NUMBER_A
On behalf of number (B)stringONBEHALFOF_NUMBER_B

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.