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

Description	Data type	Column name
Dialed phone	string	DIALED_PHONE
Ext	string	EXT
Direction	string	DIRECTION
Call duration (s)	integer	CALL_DURATION_S
Call duration	datetime	CALL_DURATION
Status	string	FLAG1
Call time	datetime	CALL_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.