Page 1 of 1

Reports and sending them via email schedually

PostPosted: Thu Apr 16, 2020 8:55 pm
by bghayad
Hello;

vicibox 8.1.2, vicidial 2.14-714a, Build 190628-1511, asterisk 13.24.1-vici, Single Machine

There are some reports, we need it daily or weekly, so is it possible to run it automatically and send the results as attachment by email?
Example: Exporting the CDR calls for last 24 hours and sending it via email.

Regards
Bilal

Re: Reports and sending them via email schedually

PostPosted: Fri Apr 17, 2020 7:15 am
by Kabis
Yes, You run the CDR DB to be stored in Excel and send that excel via email using postfix or mailx.
Or using this following link.

http://myserverip/vicidial/call_report_export.php?DB=&run_export=1&ivr_export=&query_date=--A--today--B--&end_date=--A--today--B--&date_field=call_date&header_row=YES&rec_fields=NONE&custom_fields=YES&call_notes=NO&export_fields=STANDARD&campaign%5B%5D=NDPROS&group%5B%5D=NDSALESIN&list_id%5B%5D=---ALL---&status%5B%5D=ABSALE&user_group%5B%5D=---ALL---&SUBMIT=SUBMIT

Regards.
KABIS Technical team
Email: kabisforu@gmail.com
Skype: kabisforu

Re: Reports and sending them via email schedually

PostPosted: Fri Apr 17, 2020 7:25 am
by mflorell
You could also try "Enable Automated Reports" in System Settings, then set up the "Admin -> Automated Reports" to export the "Export Calls Report" every night and send it through email.