Hi AllAgain i am very new to Asterisk so please don`t ridicule me for asking stupid questions. I have a new installation of Asterisk 11 ,i need to export the CDR records in a .csv format to an external SFTP/FTP server. Is this possible ? Could anyone perhaps assist me with some steps or maybe even a reference to a document ?ThanksRynard
Most Welcome @rcoetzee,
I think you need to create PHP Script with follwoing steps:
Hope this to be helpful.
Hi AhmedThanks for the reply. As far as i can tell there is a way to generate the CDR files in .csv format. It is stored in /var/log/asterisk/cdr-csv/master.csv. So i guess my first question is if Asterisk will store it here by default or if i need to edit some conf file. Secondly i need to create some script that will copy this master.csv file into a custom.csv file every "XX" seconds and then that file needs to be copied to External FTP server using scp or equivalent.
HI @rcoetzee, Very good to know,
For second part I think you can but scp in bash file and use watch to run it periodically:
watch -n 10 path/to/script.sh
It depends on how you configure your CDR.
The CSV and Custom Backends both will write to csv files on the host asterisk is running on.