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

Advanced PBX Data Logger should be configured to the TCP server mode and listen on 0.0.0.0:2002 (see below). The port number should match the value from the SMDR settings in 3CX.

TCP Server Mode for 3CX

2002

2002

Data items

DescriptionData typeColumn name
Record NostringFLAG4
Call IDstringFLAG1
Call timedatetimeCALL_TIME
Call durationdatetimeCALL_DURATION
Call duration (s)integerCALL_DURATION_S
RingdatetimeRING
TerminatedstringFLAG5
Call typestringDIRECTION
ExtensionstringEXT
TrunkstringTRUNK
Called phonestringCALLER_PHONE
Dialed phonestringDIALED_PHONE
Call chargefloatCOST
Change reasonstringFLAG6
ChainstringFLAG3
NamestringFLAG2

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.