Automated Reports feature

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Automated Reports feature

Postby dspaan » Sun Mar 12, 2017 9:23 pm

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
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1374
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Automated Reports feature

Postby mflorell » Sun Mar 12, 2017 9:25 pm

It should work, it worked in our tests :)
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Automated Reports feature

Postby dspaan » Sun Mar 12, 2017 9:31 pm

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

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1374
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Automated Reports feature

Postby mflorell » Mon Mar 13, 2017 5:49 am

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Automated Reports feature

Postby dspaan » Mon Mar 13, 2017 2:55 pm

I had specified a name in the sender field instead of an e-mail address. After i changed that it worked like a charm!
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1374
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Automated Reports feature

Postby dspaan » Wed Sep 05, 2018 11:13 am

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?
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1374
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Automated Reports feature

Postby mflorell » Thu Sep 06, 2018 3:51 pm

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Automated Reports feature

Postby eyeofefil » Fri Feb 12, 2021 4:32 pm

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
 
Posts: 21
Joined: Thu Feb 15, 2018 2:45 pm

Re: Automated Reports feature

Postby eyeofefil » Fri Feb 12, 2021 4:36 pm

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
eyeofefil
 
Posts: 21
Joined: Thu Feb 15, 2018 2:45 pm


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 100 guests