Export More Than 1000 Results to Excel (ON demand subscription)

How can i export more than 1000 rows on JIRA cloud instanse?

 

I have read the article below; but the managers who is using this system wants too many reports. I dont have much time to export 1000 rows and consolidate them at the end. I need a permanent solution, can't you customize my cloud instance export limit to 20000? 

 

https://confluence.atlassian.com/display/CLOUDKB/Export+More+than+1000+Issues+to+Excel+from+Issue+Navigator+in+JIRA+Cloud

 

2 answers

1 accepted

Well the problem here is that you don't know what your managers want. Nobody will look at list with 20000 issues. They will filter these list again to get what ever shorter list. And this is what you need to find out. Talk to them in order to get their real requirements.

Show them what you can do with dashboards and all available gadgets. Point out all the benefit they would have to see everything in one single dashboard. I bet for any requirements from your managers you can find a solution. So you will save your time and the managers as well.

the problem is that i am preparing a report form huge amount of data via using excel (dashboards are not meet with my reqs.). So i need to export these datas to excel which are over 1000 rows.

Can you suggest a solution?

No, there is no solution in order to export more then 1000 issue. As stated in your KB-link it is not allowed for JIRA Cloud.

there must be a solution this is waste of time for me!

There are two ways you can get this out: 1. Break up your query into smaller parts (a pain to run many downloads and stitch them together) 2. Download the xml and parse it for the issues you need (a pain to parse out your issues) A far better approach is to reexamine your reporting requirements. Reports based on 20,000 issues are almost universally useless, you want summaries, not the issues, and those summaries are mostly available in JIRA. Perhaps if you explained them to us, we could point you at something that you can do.

XML is also limited to 1,000. Not a solution.

No, not the export, the xml backup of your whole system.

It is still going to take you a lot longer to deal with than examining the reasons you think you want a functionally useless 20k download.

You can use getIssueList from JIRA Command Line Interface (CLI) to produce a CSV file which can be imported into Excel. The data is retrieved in small chunks, so it avoids the JIRA limit. For very large queries, you just need to make sure the client JVM has sufficient memory.

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,042 views 13 18
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