ESI v3 (csv). 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.

SMDR formats

Advanced PBX Data Logger supports: CSV and Extended SMDR formats.

Capturing SMDR data over Ethernet

The NSP1 can be used to output SMDR data over an IP network. The TCP can be xx003 (default value is 59003). For more information about PBX settings, see NSP Installation Made Simple (ESI # 0450-0669).

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

TCP Client Mode - ESI

Capturing SMDR data through RS-232 port

Use an RS-232C cable to connect a PC's serial port to the system's Maintenance/SMDR port. If necessary, consult the ESI-50L Hardware Installation Manual. SMDR data will be stored temporarily if a laptop is connected for programming (5-15 minutes). The buffered SMDR data will resume output to the serial port.

Data items

DescriptionData typeColumn name
Call typestringCALL_TYPE
Call timedatetimeCALL_TIME
Call durationdatetimeCALL_DURATION
Call duration (s)integerCALL_DURATION_S
Caller ID namestringCALLER_PHONE
Esi-Link home location numberstringFLAG1
Esi-Link remote location numberstringFLAG2
Line numberstringTRUNK

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.