how to merge two custom fields

[Consulente Atlassian]

As you can see from the picture, I have two custom fields that are practically the same thing, one is mapped to one project and the other to another project. I would like to know if there is a way to merge two custom fields into one and remove the duplicate.

[Paul O · Accepted solution]

If you have admin permissions, you could consider exporting the issues that need to be merged into a CSV, merging in Excel and re-importing using JIRA Settings > System > External System Import.

See: https://community.atlassian.com/t5/Jira-questions/Whether-Jira-supports-updating-existing-issues-using-CSV-import/qaq-p/1008434 for a full explanation

I'd recommend testing the update carefully (either in a dev environment or with a batch size of 1) before applying it to a large number of issues

[Nic Brough -Adaptavist-]

There is no automatic way to do it, you have to do it manually in plain Jira.

1. Select which field you want to keep and which one is to go - from your screenshot, lets say we're going to keep "Account" (as it is a global field, it's going to be less work to keep that and merge the other one in), and lose "permesso"
2. Make sure "Account" is on the edit screen for the project "permesso" is in
3. Run a search for "permesso is not empty", and include both fields in the report.
4. You now need to edit each issue, copying the date from permesso into Account
5. Now you can delete permesso

If you have batches of the same dates, you can use bulk-edit to do this, but I suspect with date fields, you will have loads of different ones.

There are apps that can help you or even do the whole "merge" for you - scriptrunner can easily support scripts to copy data across fields, there are some housekeeping  apps that can do merges, and even the tools for migrating between systems can do it

[Fabian Lim]

Hi @Consulente Atlassian

If you just want to do it once, get a free trial of the configuration manager from botron and there is a feature to merge customfields. Once you are done, you can uninstall it.

Link: https://marketplace.atlassian.com/apps/1211611/configuration-manager-for-jira?tab=overview&hosting=datacenter

[Oleg Pechkovskiy]

ScriptRunner built-in script allows to copy values from field to field within JQL scope, this can be helpful for merging fields.

https://docs.adaptavist.com/sr4js/6.31.0/features/built-in-scripts/copy-field-values