Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,465,122
Community Members
 
Community Events
176
Community Groups

Exporting more than 1000 requirements

Hi!

I have more than 1000 requirements and need to export them in CSV or Excel for further analysis/consolidation.

I have checked this link https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html but options 1 and 2 didnt work for me.

I can also use REST API but could not find any relevant methods for exporting.

Does anyone has any advise on how to do it? 

 

Thanks

Kostas

1 answer

1 accepted

3 votes
Answer accepted

Hi @Konstantinos Antonakopoulos

regarding the REST API, I don't think there's a specific API for exporting; you'd have to call the search endpoint, use the pagination parameters to load batches of 100 issues each (that's the maximum number you can retrieve in one call, IIRC), and then perform some kind of processing on the results of these calls to get your data.

The easier option may actually be to check out one of the export-related apps from the Atlassian Marketplace. Just to provide an example: I myself work on an app named JXL for Jira that - among many other things - allows exporting up to 10000 issues in one go (to Excel or CSV):

export-to-excel.gif

As said before - there's actually a number of apps that are focused on exports. You may already know that you can trial any app for free for 1 month, and depending on the size of your site, it may be free forever. So perhaps try out some and see which one works best for you.

Hope this helps,

Best,

Hannes

Thanks @Hannes Obweger - Fine Software - JXL

Will give it a try with the free version and let you know. 

Free forever will probably not work as we are over 100 people on the project.

 

cheers

Kostas

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events