[sipx-users] automated export cdr

2012-04-05 Thread Henry Dogger
Hi, Is it possible to make an automated export csv file of the cdrs from the day? I would like to export the cdr data every day into a csv file, like I can do by hand. Kind regards, Henry Dogger Telecats BV ___ sipx-users mailing list

Re: [sipx-users] automated export cdr

2012-04-05 Thread Michael Picher
Anything is possible! It's software! On Thu, Apr 5, 2012 at 4:45 AM, Henry Dogger h.dog...@telecats.nl wrote: Hi, ** ** Is it possible to make an automated export csv file of the cdrs from the day? I would like to export the cdr data every day into a csv file, like I can do by

Re: [sipx-users] automated export cdr

2012-04-05 Thread Tony Graziano
I would imagine if you can export by hand, then you can script it and run via a cron job. If you need this done daily, you might consider setting up an odbc database connection to postgres cdr db from whatever system is processing your csv file instead and getting it directly though. On Thu, Apr

Re: [sipx-users] automated export cdr

2012-04-05 Thread Cyril Constantin
Hi, I wrote a bash script which is doing postgresql request and extract data that I need to export to csv file and then convert is to XLS with column width set (perl script): For example you can set a crontab with value below: 00 03 * * 2-5 /usr/local/sbin/extractcdrperday.sh 05 0 * * 1