Bulk copy Jira field values from one work item to another
プラットフォームについて: Cloud のみ - この記事は クラウド プラットフォームのアトラシアン製品に適用されます。
要約
Jira's built-in bulk editor doesn't allow for copying values between two fields on a work item. However, we can work around this limitation and copy field values in two ways.
In this example, I want to bulk update all issues that have a value in the field called "Legacy Description." I want the Legacy Description value copied to the "Description" system field.
We'll refer to the Source and Target fields as follows:
- Source: "Legacy Description" custom field
- Target: "Description" system field
- It is highly recommended that you create and download a Jira backup before performing any bulk operations in case you need to roll back any unintended changes. Atlassian Support will not be able to recover any data that is lost due to an accidental update.
- In all the following options, if the target field has an existing value in it, it will be wiped and replaced with the value of the source field.
Export and import field data via CSV
We'll export the issues with a value in the Legacy Description field, update the field data in an external CSV editor, then re-import to Jira.
- Perform a JQL issue search to return the issues you wish to update
- Here is an example query to return all issues where the source field has a value:
"Legacy Description[Short text]" is not EMPTY
- Change the columns on your search results to only the mandatory fields (Issue Key and Summary) plus the ones you wish to edit (Legacy Description and Description)
- Select Export > Export CSV (my defaults)
- Modify the CSV file using a text editor to copy the values from the source field's column into the target field's column
- Navigate to
Settings > System > External system import
- Import the CSV file and map the following fields:
- Summary (always mandatory)
- Issue key (if you don't map this, a new issue will be created instead of the existing one being updated)
- The target field (so that it is updated with the new value)
The import will perform the update on all issues in the CSV file. You can find details on this procedure in our documentation: Import data from a CSV file
Copy field data with workflow transitions
For issues in company-managed projects you can use a workflow transition to bulk update the target fields.
- Create a new transition in the workflow
- Add the post function Copy Value From Other Field
- ワークフローを公開します
- Search for all work items that you want to update
例:
"Legacy Description[Short text]" is not EMPTY
Bulk change all returned work items
In the bulk editor, bulk transition the work items selecting the transition you created in step 1
As the transition is performed, the post function added in step 2 will copy the field data for all affected issues.