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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Not able to export all tickets

Hi Team,

When we export all the tickets the search query shows 12,376 issues. Attached Screenshot.

However the export only gives us 1000 rows.

We are trying to migrate our tickets from current portal to Jira service desk and in this activity we figured out that some of the tickets got migrated twice. This we need to identify using our custom field (TS_ID) which can be done once we have the export dump.

Kindly let us know how we can get the dump or any other method to get duplicate field values for a custom field.Capture.PNG


3 answers

1 vote
Jack Community Leader Oct 30, 2019

yep you must export 1K at a time. :-(

you can then combine into single CSV/excel

That will be a very tedious job. Is there a way you can provide us the dump?

No, we have less access to your cloud system than you do.

You could download a backup of your system though - this would give you everything in an xml file.

Jack Community Leader Oct 30, 2019

Hi @ddeka , to be clear I do not work for Atlassian. I'm a user/customer like yourself. Given you have 12,376 issues this will require 13 exports. Yes tedious but not horrendous, maybe 30m of work at most. Here is more info on how this is done along w/ background - export-over-1000-results-to-excel-from-jira-cloud . Note that the KB is dated as it refers to Excel but CSV is the way to go here anyway.

You might also find this article of value - merge-two-different-jira-cloud-sites 

You might also look into migration addons - Marketplace export 

Thanks Jack.

Let me get someone from Atlassian who can help us with this. 

Jack Community Leader Oct 30, 2019

no problem glad to help. If you get any info from Atlassian that you think would be useful to others please include here.


Hi Team,

Please provide us an update on this. We are stuck on our migration activity.

You can also treat this as more of a programming challenge. 

Using a add on like Power Scripts for jira you can write a script that can iterate through your issues and report on duplicates. It would not be a difficult script to write. 

You could also just use the API to query jira for the data, and write the script in whatever language you want.

Hi Andrew,

Currently, approached the problem with custom script. But would have been easier if someone from Atlassian could help us out here.

Suggest an answer

Log in or Sign up to answer
Community showcase
Asked in Jira Service Desk

Calling all Insight users, we need your help!

Hello Insight users,  As part of our (Mindville's) acquisition by Atlassian, our training team is looking to build some new Insight training materials. It would really helpful if you can ...

96 views 1 0
View question

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you