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

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

TCP Client Mode - Splicecom
4001
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 name (B)stringTRUNK_NAME_B
Caller namestringFLAG3
Caller numberstringEXT
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
Trunk (A)stringTRUNK
Informational Field (B)stringREM_B
Original cost centrestringORIG_COST_CENTRE
Call Record GUIDstringFLAG7
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
Dialed number (A)stringDIALED_PHONE
Call type (A)stringCALL_TYPE
DirectionstringDIRECTION
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

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.