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

This widget could not be displayed.

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

Yes...

 

you need to do some replacements as per valid syntaxes.

like "wget -O <Output Filename>" is the actual syntax for wget -O&lt;frienldly_name&gt;.xls

so, with this URL it'll be written as:

 

wget -O Output.xls --ignore-length=on "http://jira.xyz.com/sr/jira.issueviews:searchrequest-excel-all-fields/..... and so on.

 

Frank Bell I'm New Here Saturday

None of these answers seem to work correctly.  Can someone provide a full example that actually still works today.

This widget could not be displayed.

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

This widget could not be displayed.

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.

This widget could not be displayed.

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! ;)

This widget could not be displayed.

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? 

This widget could not be displayed.

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.

This widget could not be displayed.

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 ?

This widget could not be displayed.

put quotes before http and at the end

This widget could not be displayed.

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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

269 views 5 0
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