How do I export Jira items for a Ketryx migration?

Permanently deleted user
Permanently deleted user
  • Updated

A key thing to understand about exporting Jira items for a Ketryx migration is that each CSV has to contain fewer than 1000 items. This is typically achieved by using JQL to pull the entirety or a subset of the Jira issue types.

 

For example, you could use this to determine the number of issues for a project with Jira Key "ABC": 

project = ABC ORDER BY assignee DESC, created DESC

 

If you have less than 1000 items, click Export > Export CSV (all fields). You're done!

 

If you have more than 1000 Jira issues, read on...

Using either the BASIC interface or JQL, create exclusive, non-overlapping groups of less than 1000 issues. 

Screenshot 2025-03-28 at 5.53.25 PM.png

 

This pulls out the items of type Story:

project = ABC AND type = Story ORDER BY created DESC

 

If you need to subdivide an issue type (for example Story), one good way can be by assignee. 

project = ABC
AND type IN Story
AND assignee IN (empty, XXXXX, YYYYY)
ORDER BY assignee DESC, created DESC
project = ABC
AND type IN Story
AND assignee NOT IN (XXXXX, YYYYY)
ORDER BY created DESC

Note: the "empty" is critical to account for in the first one. Otherwise you could be off the correct count by the number of unassigned issues. The XXXXX and YYYYY refer to specific user IDs - find those by selecting the people in the Jira GUI and copy the JQL. 

 

This pulls out everything except for Story and Sub-Tasks:

project = ABC AND type NOT IN (Story, subTaskIssueTypes()) ORDER BY assignee DESC, created DESC

 

For each of the sub-1000 issue groups, click Export > Export CSV (all fields).

 

As a sanity check, always confirm that the final number of rows is consistent with the expected number of issues from the original.

 

The final step is to combine the CSV files in such a way that preserves all of the column headers, which may vary by CSV file. This can be done with python (using pandas for example), C, go-lang, or your favorite language. Reach out to the Client Operations team with questions. 

 

Finally, you use the External System Import tool in Jira to bring your issues into the new project. 

 

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.