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 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 a new "File" data source.
2. Click "Actions → Add...".
3. Select "FTP" and configure connection with your FTP server.
4. Adjust read options.
/var/log/asterisk/cdr-custom/
Data items
Description | Data type | Column name |
Caller name | string | FLAG1 |
Caller phone | string | CALLER_PHONE |
Source | string | FLAG2 |
Destination | string | FLAG3 |
Direction | string | DIRECTION |
Ext | string | EXT |
Trunk | string | TRUNK |
Destination context | string | FLAG4 |
Call type | string | CALL_TYPE |
Call time | datetime | CALL_TIME |
Call duration (s) | integer | CALL_DURATION_S |
Call duration | datetime | CALL_DURATION |
Ring | datetime | RING |
Desposition | string | FLAG5 |
AMA flags | string | FLAG6 |
Account code | string | ACC |
Call ID | string | FLAG7 |
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.