3CX. 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.

Enable CDR

To enable CDR, access the 3CX Management console. Go to "Settings → CDR", choose "Generate CDR". Select the "Active Socket" output type.

CDR settings

Configuring the CDR fields

Our software is configured for the following STRUCTURE and the position of the CDR data

historyid
callid
duration
time-start
time-answered
time-end
reason-terminated
from-no
to-no
from-dn
to-dn
dial-no
reason-changed
final-number
final-dn
bill-code
bill-rate
bill-cost
bill-name
chain
from-type
to-type
final-type
from-dispname
to-dispname
final-dispname

More info about the CDR format and settings you may find here.

Configuring Advanced PBX Data Logger as a TCP server

Advanced PBX Data Logger should be configured to the TCP server mode and listen on 0.0.0.0:2002 (see below). The IP address 0.0.0.0 allows receiving data from all network connections on your computer. The port number should match the value from the SMDR settings in your 3CX.

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 Server Mode for 3CX

2002

2002

Selecting the correct parser for 3CX

Parser Selection For (none)

3CX

3CX

Data items

DescriptionData typeColumn name
Record NostringFLAG4
Call IDstringFLAG1
Call durationdatetimeCALL_DURATION
Call duration (s)integerCALL_DURATION_S
Call timedatetimeCALL_TIME
RingdatetimeRING
TerminatedstringFLAG5
Call typestringDIRECTION
ExtensionstringEXT
TrunkstringTRUNK
Called phonestringCALLER_PHONE
Extension namestringEXT_NAME
Dialed phonestringDIALED_PHONE
Call chargefloatCOST
Caller namestringFLAG2
Change reasonstringFLAG6
Chain (full)stringCHAIN
ChainstringFLAG3
Display name (from)stringDISPNAME_FROM
Display name (to)stringDISPNAME_TO
Display name (final)stringDISPNAME_FINAL
Missed queue callsstringMISSED_QUEUE

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.