It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Possible to schedule reports?

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

4 answers

1 accepted

0 votes
Answer accepted

Thanks, this information is very helpful

/Patrik

0 votes

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.

0 votes
TeckEn Atlassian Team Feb 26, 2013

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

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you