Asterisk (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.

Selecting the correct parser for Asterisk (CSV)

Asterisk (CSV)

Data items

Description	Data type	Column name
Account number	string	ACC
Direction	string	DIRECTION
Caller phone	string	CALLER_PHONE
Ext	string	EXT
Dialed phone	string	DIALED_PHONE
Destination context	string	CALL_TYPE
Caller ID name	string	FLAG1
Channel	string	FLAG2
Destination channel	string	FLAG3
Call time	datetime	CALL_TIME
Total duration (s)	integer	TOTAL_DURATION_S
Call duration (s)	integer	CALL_DURATION_S
Ring duration (s)	integer	RING_S
Call duration	datetime	CALL_DURATION
Ring duration	datetime	RING
Disposition	string	FLAG5
Flags	string	FLAG6
User data	string	USER_DATA

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.