Automatic billing reports

[cessariuss]

Dear community good day.

Could someone please guide me to program monthly reports of calls in such a way that they are triggered in an email to a recipient.

Thank you so much!

 

[cessariuss]

hello good afternoon, does anyone have an idea?

 

[gflow]

What details do you want in the report?

 

[cessariuss]

What details do you want in the report?

hello, thanks for your answer.

Calls made and received by an extension, answered and not answered, time and duration of the call. That's all
I need it to be generated automatically at the end of each month.

 

[Lim00n]

I would imagine a script running in cron would be best suited for this.

 

[gflow]

I have modified the xml_cdr.php page for reporting.

You can perform a search on that page and then schedule reports to be emailed out in either PDF or CSV format for a specific period of time (ie. Previous day, Last 7 days, Last Month etc) and you can also select the Timezone for that period. We use this to send CDR billing information to partners/clients and generic scheduled reports.

 

[elkato]

Like gflow mention, or directly query v_xml_cdr table on DB as you wish, then script whatever you need to send the report.

 

[cessariuss]

I have modified the xml_cdr.php page for reporting.

You can perform a search on that page and then schedule reports to be emailed out in either PDF or CSV format for a specific period of time (ie. Previous day, Last 7 days, Last Month etc) and you can also select the Timezone for that period. We use this to send CDR billing information to partners/clients and generic scheduled reports.

great, thank you very much

 

[cessariuss]

Like gflow mention, or directly query v_xml_cdr table on DB as you wish, then script whatever you need to send the report.

Thank you very much, I will try what you suggest