bg

Asterisk (Master CSV) - 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)

[cdr]
;usegmtime=yes ;log date/time in GMT (disabled)
loguniqueid=yes ;log uniqueid (enabled)
;loguserfield=yes ;log user field (disabled)

Out of the box, Asterisk will update: /var/log/asterisk/cdr-custom/Master.csv

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 [Master CSV]

Asterisk [Master CSV]. Data source selection dialog.

Asterisk [Master CSV]. Folders and files.

Configuring FTP connection to Asterisk [Master CSV]

192.168.0.254

21

/var/log/asterisk/cdr-custom/

Master*.csv

admin


Adjusting read options for Asterisk [Master CSV]

Selecting the correct parser for Asterisk (Master CSV)

Parser Selection For PBX Data Logger

Asterisk (Master CSV)

Asterisk (Master CSV)

Data items

DescriptionData typeColumn name
Caller namestringFLAG1
Caller phonestringCALLER_PHONE
Account codestringACC
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
Call IDstringFLAG7

Interested in reports for PBX usage?

We provide the PBX Reports utility, featuring a range of manual, scheduled, and email reports, a built-in web server, among other features. Implement your call accounting system for Asterisk (Master CSV). Check our PBX Reports utility.

Want PBX call logs in a database?

This standard feature allows the logger to capture and export SMDR or CDR data in real-time directly to your database. Check our article about call logging to a database.

Asterisk related connection settings

Asterisk (CSV)
Asterisk (AMI interface)
Asterisk Fonality (CSV)
AudioCodes Gateway (Extended)

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.