duplicate custom fields in Jira after import from bugzilla

bugzilla1.PNGbugzilla.PNGHi

I want to know how to solve it. It's really difficult to use that, I have script Runner installed but dont work .

Any Suggestions ?

 

2 answers

0 votes

It can do that if you mess up the import mappings.  The question is what you actually want to end up with, and where your data currently is?  For example, if you imported data into a field called "Penguin species" and that's duplicated "Penguin Species", do you now have all the data in one field or the other, or is it scattered across both?

I want to join it or something similar. Look at the pictures.

Sorry, you need to explain where your data is before I can answer that. Do you now have all the data in one field, or is it scattered across all four?

It is Result after importing from Bugzilla, I have now 3 or more this same custom fields with others Projects. You can see that on the pictures. for exampel. (External issue ID ), I tried to use Runner script with option "Copy custom field values " but don't work. I can't do again import. I want only one ( External issue ID ) with Projects

Sorry, I'm lost. Do you now have all the data in one field, or is it scattered across all four?

Now it is scattered across all four but I want to have in one field

Ok, there's a few steps here. First, establish the current problem and see if we've got the structures that can help us fix it. Your four fields are global in your screenshot, so that simplifies things, and your last comment clears up the goal Second, look at the scale of the problem. I'd use Jira to do this internally, but we do need to make a few tweaks * Rename your duplicate fields - we need to be able to tell them apart easily. I'd just add 1/2/3/4 to the end of their names * Run a simple search for each one - ** "External issue id 1" is not empty ** "External issue id 2" is not empty and so-on. Note down the numbers from each one Note, at this point, if any of the numbers returned are 0, you can simply delete the field. Third, plan how to fix it - can't really do this until we've got some idea of scale

Please could you give me email adress. I can't right now insert pictures. I have changed Field (External issue ID 1 .... External issue ID 6), and tryed to find but i had only result " There were no matching issues found" I used quick find

Ok, don't use quick find, it's useful, but not for this. We need specifiec queries, entered exactly, Please go to Issues -> Search for issues -> New Search and then put it in "advanced" mode so you can enter the JQL text of each of your six searches. Then, run "External issue ID 1" is not empty "External issue ID 2" is not empty and so on. We're not interested in the result so much as thesummary where it says "found 54 issues" or whatever.

Ok, I had done . I have for example External issue ID 6 - cf[10421], ID 5 - cf[10410, ID 4 - cf[10324, ID 3 - cf[10313, ID 2 - cf[10210, I guess "cf" = custom field number ?, for ID 1 - don't exist .

That's not what I asked. What numbers do you get from the filters I've asked you to run twice now?

I know. I wrote External ....... Is not empty and i had immediatly CF ...... . i dont sow anything else .

Would you PLEASE run these filters and tell us how many issues each one finds. I really can't help you until you do that.

External issue ID 6: 3360 , External issue ID 5: 5637, External issue ID 4: 5860 , External issue ID 3: 5874, External issue ID 2: 5843, "External issue ID 1 - dont exist its all i've got. Sorry, but I have misunderstood If You want i can "print screen " send.

Could you help me for example with post function ?, maybe that's the right way

Ah, sorry, I didn't seem to get the "commented" email from your list. That's exactly what we needed. I'm afraid it is a bit of a pain, I was hoping the numbers would be small enough to fix manually, but there are no candidates for that, so we'll definitely have to do it the hard way. The way I've fixed this in the past is exactly what you suggest. I wrote a post-function that would read ALL of the fields, decide which one is the correct one for the current issue, copy the value into the field I wanted to keep, and blank it out of all the others. Applied it to several points in the workflows, and left it to run for a while so the users gradually cleaned up data on the active issues, and then later used "bulk edit" to push the issues through transitions to trigger it. I have a feeling you can write a script that would do the updates without needing a post-function, but I am not sure.

I dont think so. I saw language and i worried that without examples or manual i cant do that. Maybe have you some examples ?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,301 views 12 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you