Possible to schedule reports?

[Patrik Bredin]

Hello!

We frequently generate reports to Excel sheets. Is it possible to schedule these reports so that they are generated automatically (e.g. twice per week) and then saved on a server?

I have looked in JIRA, searched your documentation and looked at plug-ins etc. but I have not found anything related to this subject.

Regards

Patrik

[Patrik Bredin · Accepted solution]

Thanks, this information is very helpful

/Patrik

[Midori]

This is now possible with the Excel Automation Plugin!

You can use the CRON trigger to flexibly define your preferred schedule and then use the "Save PDF" action to save the generated XLSX spreadsheet to a file system path.

See the tutorial

[Teck-En]

Previous post with wget is a good read for other that looking for the same feature: https://answers.atlassian.com/questions/546/how-can-i-schedule-automate-excel-reports-in-jira

[Nic Brough -Adaptavist-]

No, there's nothing to do this internally. The call to grab some excel is a request generated by users.

Simple answer would be to put the report's url into a curl command and bung that on a scheduler. It does require a machine to issue the request (could be the Jira server, but you need to think about file access as well as running it). I've done almost exactly this for a client - they've got a Raspberry Pi running a file-server, and adding a cron-job to that means their regular extracts are made immediately available on the share whenever the cron finishes running.