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

Asterisk it is an open-source software PBX licensed under the GPL license.

Asterisk configuration

For this to work you do need to have loaded. show modules or module show entered at the CLI will tell you if it has been loaded. If not: Type load in the CLI. You'll also want to add that load command to /etc/asterisk/modules.conf if Asterisk didn't automatically include this module at startup.

You also need to edit cdr.conf. The file is located in the /etc/asterisk/ directory.


; Define whether or not to use CDR logging.  Setting this to "no" will override
; any loading of backend CDR modules.  Default is "yes".
unanswered=yes (or no)

Then cdr_custom.conf


Master.csv => "${CDR(clid)}","${CDR(src)}","${CDR(dst)}","${CDR(dcontext)}","${CDR(channel)}","${CDR(dstchannel)}","${CDR(lastapp)}","${CDR(lastdata)}","${CDR(start)}","${CDR(answer)}","${CDR(end)}","${CDR(duration)}","${CDR(billsec)}","${CDR(disposition)}","${CDR(amaflags)}","${CDR(accountcode)}","${CDR(uniqueid)}","${CDR(userfield)}","${CDR(sequence)}"

How to check the CDR service status

CLI> cdr show status
Call Detail Record (CDR) settings
  Logging:                    Enabled
  Log unanswered calls:       Yes
  Log congestion:             No

* Registered Backends

Configuring PBX Data Logger

1. Create the new "File" data source.
2. Click "Actions → Add...".
3. Select the "FTP" file transfer protocol and configure connection with a FTP server on your PBX.
4. Adjust read options.

Adding a new file data source for Asterisk Fonality [CSV]

Asterisk Fonality [CSV]. Data source selection dialog.

Asterisk Fonality [CSV]. Folders and files.

Configuring FTP connection to Asterisk Fonality [CSV]





Adjusting read options for Asterisk Fonality [CSV]

Selecting the correct parser for Asterisk Fonality (CSV)

Parser Selection For Asterisk Fonality (CSV) - SMDR/CDR call logging & accounting

Asterisk Fonality (CSV)

Asterisk Fonality (CSV)

Data items

DescriptionData typeColumn name
Caller namestringFLAG1
Caller phonestringCALLER_PHONE
Destination contextstringFLAG4
Call typestringCALL_TYPE
Call timedatetimeCALL_TIME
Call duration (s)integerCALL_DURATION_S
Call durationdatetimeCALL_DURATION
AMA flagsstringFLAG6
Account codestringACC
Call IDstringFLAG7

Interested in reports for PBX usage?

The PBX Reports utility we offer includes multiple report types—manual, scheduled, and via email—a built-in web server, and additional features. Easily implement your call accounting system for Asterisk Fonality (CSV). Look here

Want PBX call logs in a database?

In real-time, the logger captures and exports SMDR or CDR data to your database as a standard feature.. 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.