Automated Reports feature

[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

[mflorell]

It should work, it worked in our tests

[dspaan]

I'm not receiving any email. In which log could i check for errors?

[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.

[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!

[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?

[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.

[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

[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