bg

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

This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not be 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 cdr_csv.so loaded. show modules or module show entered at the CLI will tell you if it has been loaded. If not: Type load cdr_csv.so 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.

[general]

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

Then cdr_custom.conf

[mappings]

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
  -------------------
    csv

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]

192.168.0.254

21

/var/log/asterisk/cdr-custom/

Master*.csv

admin


Adjusting read options for Asterisk Fonality [CSV]

Selecting the correct parser for Asterisk Fonality (CSV)

Parser Selection For PBX Data Logger

Asterisk Fonality (CSV)

Asterisk Fonality (CSV)

Data items

DescriptionData typeColumn name
Caller namestringFLAG1
Caller phonestringCALLER_PHONE
SourcestringFLAG2
DestinationstringFLAG3
DirectionstringDIRECTION
ExtstringEXT
TrunkstringTRUNK
Destination contextstringFLAG4
Call typestringCALL_TYPE
Call timedatetimeCALL_TIME
Call duration (s)integerCALL_DURATION_S
Call durationdatetimeCALL_DURATION
RingdatetimeRING
DespositionstringFLAG5
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, built-in web server, and additional features. Easily implement your call accounting system for Asterisk Fonality (CSV). Check our PBX Reports utility.

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. Check our article about call logging to a database.

Asterisk Fonality related connection settings

Asterisk (Master CSV)
Asterisk (CSV)
AudioCodes Gateway (Extended)
AudioCodes Mediant 1000

Quick jump to the connection settings for other PBXs or connection formats ↴

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.