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 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 Alcatel 4400 P

Alcatel 4400 P. Data source selection dialog.

Alcatel 4400 P. Folders and files.

Configuring FTP connection to Alcatel 4400 P

192.168.0.254

21

/usr4/account

TAXA*.DAT

ftp_inst


Adjusting read options for Alcatel 4400 P

Selecting the correct parser for 3COM NBX (XML, v6)

Parser Selection For PBX Data Logger

3COM NBX (XML, v6)

3COM NBX (XML, v6)

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.