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 GPL license.

Asterisk configuration for Smartcall

If you are using smartcall.ro (NETMASTER SRL) you should make the following settings in asterisk. These settings were imported from original document on http://smartcall.ro/resources/docs/asterisk.pdf but the PDF had become outdated over time so you should use this one.

[general]
context=default
recordhistory=yes
bindaddr = 0.0.0.0
bindport = 5060
disallow=all
allow=gsm
allow=ulaw
allow=alaw
progressinband = yes
canreinvite = no
useragent=asterisk
qualify = yes
;register test accounts
register => 4021569XXXX:parola dvs de voip@sip.netmaster.ro/4021569XXXX
 
[smc]
disallow=all
allow=gsm
allow=ulaw
type = friend
insecure = very
username = 4021569XXXX
fromuser = 4021569XXXX
secret = parola dvs de voip
host = sip.netmaster.ro
fromdomain = netmaster.ro
canreinvite = yes
qualify = no
context = default
#In fisierul extensions.conf:
# Pentru a putea suna de pe o extensie:
exten => _9.,1,SetCallerID(4021569XXXX)
exten => _9.,2,Dial(SIP/${EXTEN:1}@smc,120,TW)
exten => _9.,3,Hangup
 
# Pentru a putea primi apeluri pe o extensie(cum ar fi de exemplu 100):
exten => 4021569XXXX,1,Dial(SIP/100,20)
exten => 4021569XXXX,2,Hangup

Data items

DescriptionData typeColumn name
Dialed phonestringDIALED_PHONE
ExtstringEXT
DirectionstringDIRECTION
Call duration (s)integerCALL_DURATION_S
Call durationdatetimeCALL_DURATION
StatusstringFLAG1
Call timedatetimeCALL_TIME

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.