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

[Prakash Bhandari]

I followed the https://confluence.atlassian.com/jirakb/export-more-than-1000-issues-to-excel-from-issue-navigator-in-jira-cloud-779160811.html.  

Appending the &pager/start=1000 didn't work for me.  It simply redirects me to the result set that i got from the beginning.  This occurs in both Safari and Chrome. 

Any ideas on how to fix this issue? 

[Nic Brough -Adaptavist-]

You don't.  It is deliberately locked down on Cloud to avoid people overloading your system.

You will have to do what it says in that document - download in blocks of 1,000.  Or, better, examine why you are trying to download an amount of issues and do whatever it is in a better way.

[Prakash Bhandari]

Well, there is a very good reason for doing what i am trying to do.  So, its not a stupid user scenario. If I want to download all issues, then i want to download all issues.  You guys should be supporting the users on what THEY want to do. 

What the document telling me as a workaround does NOT work. It defaults to the same 1000 issues. So, currently there is no way to do what I need to do. 

[Nic Brough -Adaptavist-]

Ok, we never said there was not a good reason or that it was a stupid user scenario.

What I said was that it is locked down to prevent you taking down your system and potentially damaging your data.

A better solution than downloading vast amounts of data is almost certainly going to be to look at why you're doing it and do that better.

"I want to download all the data" is not a useful definition of the task.  Why do you want to download it all?  What's the use?  What question(s) are you trying to answer?

As for the workaround, I'm afraid it works fine for me.  So what are you doing differently to what is in the doc?

[James Robison]

Hi Nic,

Every response from the community leaders is why do need to do this? I need a snap shot off all my data of a certain type every week. We load it into excel then connect it to a visualization tool to look at trends. It is very useful to pull all the data.

It is a real pain to export in 1000s then connect it all together. Is there a ticket to fix this?

[Nic Brough -Adaptavist-]

A lot of the other answers you've seen also question "I need a snapshot" - that usually means "I'm doing reporting which, because it's based on an extract, is obsolete as soon as it's extracted, and often 'manipulated' to show what people want, not what is happening".  You'll also have seen mention of archiving and feeds to other systems.

Issues have been opened to try to get Atlassian to increase the limits, and shut down by them for much those reasons.  It's better to look at why you're doing snapshots and fix that properly, not rely on extracts, or, if you still need an extract-like solution, come up with a proper one - synchronise, project archiving, feeds directly to the systems that want duplicate data, reporting tools in Jira and so-on.