Report extract from JIRA more than 1000 entries

[Naveen JS]

Being part of operations team need support to extract report that has more than 1000 entries.

I have 6000+ entries and extracting report multiple times is a loss of productivity for a simple task

Also problem with multiple extracts is - there is change in columns in various extracts that makes it difficult to merge.

Regards

Naveen JS 

[Rilwan Ahmed · Accepted solution]

Hi @Naveen JS ,

Welcome to the community !!

If you are using Jira cloud, your jira admins need to perform steps mentioned in https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html to get results with more than 1000 rows.

If you  are using data center or Server jira version, then refer https://confluence.atlassian.com/jirakb/filter-export-only-contains-1000-issues-in-jira-server-191500982.html for workaround. 

[Suresh Mantrala]

@Rilwan Ahmed Cloud steps mentioned are not efficient and optimal. Probably wrong too. For example

When first set of 1000 records are exported, it will be it's own set of multiple columns on Comments, Attachments, Labels - depending up on the number values in each of those 1000 records. For example Row 1 could have 10 comments, 10 attachments and 10 labels. Row 2 could have 15 comments, 15 attachments and 2 labels. Hence export will have 10 attachment columns and 15 comments columns and 10 labels columns

The second set of 1000 rows could have it's own set of columns against comments, attachments and labels etc.

Manually merging them is a herculean task and humanly excruciating. I would say near to impossible. Any other better way to merge both files. 

[Rilwan Ahmed]

Hi @Suresh Mantrala ,

The steps described in the official links are not wrong. May be it is not efficient and optimal for your case. 

If you want same columns in all rows, then you should export using selected columns and by not selecting attachments and comments in it. 

[Prince Nyeche]

You could use API by creating a simple script that can help you export the data you need in a single file. Check out this article which shows you how you can do such via API.

[Hannes Obweger - JXL for Jira]

Hi @Naveen JS

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you'll find apps that work around Jira's 1000 issues limit. E.g., I myself happen to work on an app that allows viewing and exporting any number of issues, JXL for Jira. 

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, ranging from many so-called "smart columns" that aren't natively available (like, for example, time in status), to support for issue hierarchies, issue grouping, sum-ups, and conditional formatting. With these, you can build powerful, interactive reports, like for example this one:

You can also export your issues to Excel or CSV in just one click.

As said above, there may be other apps that can help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Hope this helps,

Best,

Hannes

[Naveen JS]

Hi Hannes

thanks for the update 

but since JXL is an external app -  I cannot use.

Regards

Naveen JS