NO JOY Scheduled cdr reports with cronjob

[balefireeyed]

Every month I need to create cdr records from the previous month's 14th through the current month's 13th. Is there a way to filter cdr reports as a csv file the same way that this can be done in the freepbx module? Then can this be run every 14th as a cronjob?

I found a transnexus article in which they setup a way to have their clients do something similar: http://www.transnexus.com/index.php/how-to-push-cdr-files-from-asterisk-to-sdreporter

Is that working because they change the date on which the master.csv file is rotated? I'd be afraid to mess with that without direction and help from the community.

 

[balefireeyed]

Anyone have any ideas? I found the post at http://pbxinaflash.com/community/index.php?threads/email-incoming-cdr-report-daily.12907/ but as the user notes "In theory I could output it to a CSV file but meh"... That's exactly what I'm looking to do, only the previous month instead of the previous day... how would I go about doing that?

 

[balefireeyed]

I got this answered at the freepbx.org board in case runs across this and needs the same thing.

 

[PBX@Home]

Care to share a link or the answer?

 

[balefireeyed]

freepbx.org/forum/general-help/scheduled-cdr-reports-with-cronjob

I ran a cronjob on the day that I needed the file created to test it out, and it worked like a charm.