Howto merge customFieldId over multiple projects

[Frank Litjens]

Hello,

We recently started using JIRA for our projects, instead Bugzilla. We imported 5 projects into from Bugzilla into JIRA but did not set a global Field Id for our custom fields, mistake! Now we have for example 5 different customFieldId identifying the same Field, e.g. when I check my custom fields I see 5 times BoardId, with different Id's. They are all text types and now I would like to merge them into a single field ID. How can I easilly do this. I do not want to reimport the projects since we already use these projects for a couple of months within JIRA.

Custom Field CustomFieldID Context #Issues
BoardID 10018 projectA 392
BoardID 10053 projectB 33
BoardID 10113 projectC 14
BoardID 10113 projectD 6
BoardID 10113 projectE 120

They are all Text-type issues and I would like to have them all under 10018 and delete the unused BoardID id's

Is there an easy way to manage this?

Kind regards,

Frank Litjens

[Frank Litjens · Accepted solution]

Problem is perfectly solved via the Script Runner plugin.

[Frank Litjens]

Problem is perfectly solved via the Script Runner plugin.

[JK]

I would try to do the following:

- make sure field #10018 is valid for all projects

- add a global workflow transition to the other projects, which copies the value from the "old" fields to field #10018. Transition should not change the issues status, I think (--> target status '-1'), make sure only you can make that transition

- do a bulkedit and move issuesthrough that transition (that will be shown in issues changehistory and lastupdated values)

- make sure the transition was successful, then remove the obsolete fields and the global transition in your workflows.

[Frank Litjens]

Hello Jochen,

Thanks for your quick response. Do you mean creating a transition which does not change the state but only copy a value from one field to the other?

[JK]

Hello Frank,

yes, that is what I wanted to say.