Page 1 of 1
Automated Reports feature
Posted:
Sun Mar 12, 2017 9:23 pmby dspaan
I saw in svn trunk this new feature to automate reports. I tried it out.
question:
Can i use an URL like this to send an export of calls?
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
Re: Automated Reports feature
Posted:
Sun Mar 12, 2017 9:25 pmby mflorell
It should work, it worked in our tests
Re: Automated Reports feature
Posted:
Sun Mar 12, 2017 9:31 pmby dspaan
I'm not receiving any email. In which log could i check for errors?
Re: Automated Reports feature
Posted:
Mon Mar 13, 2017 5:49 amby mflorell
That's usually caused by the receiving email server flagging the messages as spam because it's not coming from a named email server.
Try sending them to/from gmail.com addresses and see if they go through.
The logs for email by default are in the /var/log/mail file.
Some of our clients have had to set up reverse DNS lookups on the IP addresses of the servers sending out these emails to be able to receive them.
Re: Automated Reports feature
Posted:
Mon Mar 13, 2017 2:55 pmby dspaan
I had specified a name in the sender field instead of an e-mail address. After i changed that it worked like a charm!
Re: Automated Reports feature
Posted:
Wed Sep 05, 2018 11:13 amby dspaan
Hi Matt,
I tried using the automated reports with some reports that had set HTML as display format (graphs), the email i get is a .html file but it has no graphs, is this a bug or by design?
Re: Automated Reports feature
Posted:
Thu Sep 06, 2018 3:51 pmby mflorell
Automated Reports is not designed to work with the dynamic graphical elements that are generated with the HTML reports. It was designed only to work with TEXT formatted reports.
Re: Automated Reports feature
Posted:
Fri Feb 12, 2021 4:32 pmby eyeofefil
I tried this argument, I get my emails with an attached csv file just fine, my only problem is the csv file is blank, has anybody experienced this issue of mine?
https://servername/vicidial/AST_agent_status_detail.php?query_date=--A--today--B--&end_date=--A--today--B--&group[]=ADMIN&user_group[]=ADMIN&shift=ALL&search_archived_data=&show_defunct_users=&report_display_type=TEXT&DB=&stage=&file_download=1
VERSION: 2.14-692a
BUILD: 180927-0018
© 2018 ViciDial Group
Re: Automated Reports feature
Posted:
Fri Feb 12, 2021 4:36 pmby eyeofefil
Quick update: I removed the "s" in https and it worked perfectly!
http://servername/vicidial/AST_agent_status_detail.php?query_date=--A--today--B--&end_date=--A--today--B--&group[]=ADMIN&user_group[]=ADMIN&shift=ALL&search_archived_data=&show_defunct_users=&report_display_type=TEXT&DB=&stage=&file_download=1
VERSION: 2.14-692a
BUILD: 180927-0018
© 2018 ViciDial Group