Agile scheduled report export
The first part, “schedule a report”, yes. The auto export part, no. Scheduled reports are saved in Agile–I believe in the file vault. There is not a feature to save them elsewhere. You would be looking at a custom report to do that.
Steve,
Thanks for the reply. What do you mean “a custom report”? Does “personal report” count as “custom report”?
Thanks!
Helen
Agile User
Answered on October 13, 2017.
A custom report, meaning… custom developed report…. programing. Agile has a Java library that can be used by a program to pull data out of Agile and put into a report.
Hi Helen,
I do it a little bit more old school.
I run a scheduled job (shortly after I know the scheduled report had executed) on a windows server to call a BAT file (BAT file 1)
The BAT file will execute an SQL query. The query will get the filename and location in the vault of the last saved scheduled report for a specified scheduled report and spool the formatted copy statement to another BAT file (BAT file 2).
BAT file 1 then executes BAT file 2 to copy the file to a new name in a different location.
Here is the core of the query:
select ‘copy \vault_root 00′ || substr(file_id,1,3) || ” || substr(file_id,4,3) || ‘agile’ || file_id || ‘.xls NEW DESTINATION AND NAME.xls’ from attachment_map am, report r where r.name = ‘AGILE SCHEDULED REPORT NAME HERE’ and r.id = am.parent_id and am.created = (select max(am2.created) from attachment_map am2 where am2.parent_id = am.parent_id);
Contact me if interested in more details or to exchange solutions.
Regards,
Jonathan
