Export issues for custom fields when migrating to cloud

[Jeremiah Roth]

I'm working through a trial migration of Jira Server (8.6.0) to Jira Cloud, and the documentation ( https://confluence.atlassian.com/cloud/what-gets-migrated-with-the-jira-cloud-migration-assistant-993925216.html under "Adding Additional Entities with CSV" ) says to export issues to CSV in order to import the custom fields into Jira Cloud.

Almost all issues we have are going to have custom fields, so my empty search returns all 22,000 issues we have. However, Jira only allows 1000 issues to be exported at a time. I suppose that's fine, I can concatenate 22 CSVs, I just don't know how to export them in 1000 issue segments. Is this possible, or is there some other way I should be handling it?

[Gonchik Tsymzhitov · Accepted solution]

Hi @Jeremiah Roth ,

Why do you need tp put an additional entities, please?

The exist custom field data will be in backup in xml as part of backup in previous steps of migration step

[Jeremiah Roth]

Sorry, I should've mentioned I'm using the migration assistant. And some custom fields aren't supported in migration https://confluence.atlassian.com/cloud/what-gets-migrated-with-the-jira-cloud-migration-assistant-993925216.html

[Gonchik Tsymzhitov]

Hello, 

There is a workaround. Kindly have a look at this page

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

it's the same idea. 

Or you can use the rest api to fetch data and generate own csv. 

Or review xml and generate csv data

Or sql queries to get the exact fields data (many joins :) ). 

Or Extend limits for search and export  https://confluence.atlassian.com/jirakb/how-to-increase-the-jira-search-results-limit-on-the-issue-navigator-357696242.html

[Jeremiah Roth]

Good to know there's a pager. It looks like the number of columns will vary based on what's returned by the 1000 rows in a page, which is a pain to merge, but at least it's possible. If it's too much of a pain I can always try your other suggestions. Thank you!