Asterisk Fonality (CSV). Параметры соединения и формат данных SMDR/CDR


Данные ниже соответствуют только программе Advanced PBX Data Logger и могут быть не применимы для других программных продуктов.

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.

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

Asterisk Fonality [CSV]. Data source selection dialog.

Asterisk Fonality [CSV]. Folders and files.

Asterisk Fonality [CSV]


Configuring FTP connection to Asterisk Fonality [CSV]

192.168.0.254

21

/var/log/asterisk/cdr-custom/

Master*.csv


Adjusting read options for Asterisk Fonality [CSV]

Данные, извлекаемые PBX Data Logger

ОписаниеТип данныхИмя колонки
Caller namestringFLAG1
Вызывающий телефонstringCALLER_PHONE
ИсходныйstringFLAG2
КонечныйstringFLAG3
НаправлениеstringDIRECTION
РасширениеstringEXT
ЛинияstringTRUNK
Конечный contРасширениеstringFLAG4
Тип звонкаstringCALL_TYPE
Время звонкаdatetimeCALL_TIME
Длительность звонка (с)integerCALL_DURATION_S
Длительность звонкаdatetimeCALL_DURATION
Ожидания ответаdatetimeRING
DespositionstringFLAG5
AMA ПризнакsstringFLAG6
Код абонентаstringACC
Идентификатор вызоваstringFLAG7

Замечание: Продукты и компании, указанные здесь используются только для обозначение и идентификации и могут быть торговыми и/или зарегистрированными марками соответствующих компаний.