How can I schedule/automate Excel reports in Jira

I have a requirement to produce a regular excel report from Jira. I see how I can manually export to excel from a filter and I see how I can schedule a filter to run regularly and email a text report to selected users. Is there a way to automate the filter to generate an excel report daily or weekly?

9 answers

1 accepted

Something like this should work:

wget -O <friendly_name>.xls --ignore-length=on "http://<jira_server>/sr/jira.issueviews:searchrequest-excel-all-fields/<filter_id>/SearchRequest-<filter_id>.xls?tempMax=1000&os_username=<username>&os_password=<password>"

where do you run this command? is there any pre-requisites?

Could you please answer Naresh's question? Thank you very much!

Hello @Justin Downing , could you please tell me where do you run this command?

@Hariz Ad You can run this anywhere that has access to JIRA via HTTP

@naresh veeragoni You need to run it from the command-line on a Linux or Mac OS X machine. The "wget" command simply downloads a file from the Internet.

@Justin Downing Can you please help me replace the command with proper details:

like my jira url is : http://ontrack-internal-uat.com 

filter id:40040

username: dsahu

password: abc123

 

I have made below command with my details:

wget -O <friendly_name>.xls --ignore-length=on
"http://<ontrack-internal-uat.amd.com>/sr/jira.issueviews:searchrequest-excel-all-fields/<40040>/SearchRequest-<40040>.xls?tempMax=1000&
os_username=<dsahu>&os_password=<Deba#2015>

but unfortunately it is not working.

Hi,

 

Do you mean replacing these values by your owns ?

&lt;friendly_name&gt  by <friendly_name>

&lt;ontrack-internal-uat.amd.com&gt by <;ontrack-internal-uat.amd.com>

and so on ?

 

BR

Excel Automation Plugin for JIRA makes automatically generating Excel exports from JIRA easy.

The idea is that it integrates the super-awesome Automation Plugin (a visual automation framework) and Better Excel Plugin (a customizable Excel generator for JIRA), enabling to define simple if-this-happens-then-generate-email-or-save-an-Excel-spreadsheet type of rules. (See the screenshot below about configuring a rule.)

See this article for a tutorial.

jira-excel-automatic.png

You can use eazyBI reporting application with JIRA integration which will perform regular JIRA import into eazyBI and then you can create reports, charts and dashboards from JIRA issues data. eazyBI provides also results export in Excel format.

Is this possible to export all issues from JIRA to excel sheet at regular intervals using eazyBI?

No, currently it is not possible to do automated exports at regular intervals. The main purpose of eazyBI is to create reports and charts for end-users, Excel export is just as add-on feature in some cases when you would like to use selected data for other needs.

Perhaps, create some wget/curl scripts? Some examples here.

Thanks so much for the wget posts! That worked perfect for me.

link to examples is not working, can you please update?

Link to example doesn't show anything. Please update the link.

Update the link please

 

and the link updated??? where is it??

Thanks! ;)

JIRA Command Line Interface has a getIssueList action that produces a csv file of issues from a filter or JQL query. The command can be added to any scheduler or automation you like. Excel will handle a csv file.

Don't you need to be an admin to use this if the issue contains custom fields? (output 999)

Hello Bob,

I am able to produce a csv file using getIssueList action. Can you please elaborate more on how to use this command so that I can automate it andmfiles are produced on a regular basis? 

Out of the box, JIRA offers email subscriptions. You can set email subscriptions on defined filters to send the results to designated email accounts at scheduled periods.

When i execute this from command prompt in wget, i get this error message :

-O 1111.xls http://fffff.ffff.fffff.lcl/sr/jira.issueviews:searchrequest-excel-current-fields/15860/SearchRequest-12345.xls?tempMax=1000&os_username=xxxx.xxx@ssss.com&os_password=password

'os_username' is not recognized as an internal or external command,

operable program or batch file.

'os_password' is not recognized as an internal or external command,

operable program or batch file.

ANY HELP PLEASE ?

put quotes before http and at the end

You could consider using Google Spreadsheets, that could also allow you to do the emailing automatically.

http://www.littlebluemonkey.com/blog/automatically-import-jira-backlog-into-google-spreadsheet

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,296 views 14 20
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot