JIRA Import issue - Importing from CSV creates new custom fields

Hello,

we have a problem when trying to import issues into JIRA from a CSV file.

In the CSV file we have the values which should be set in the Custom Fields in JIRA.

These custom fields are mostly type Select List so we tried to use the mapping (map the value from CSV to the value in Select list) but it didn't work - the existing values were not displayed.

When we continued with the import JIRA actualy created new global custom fields with the same name as the already existing custom fields which is very bad.

We had to delete all the imported issues (more than 250) and delete all the new custom fields manually to restore JIRA to where it was before the import.

Our JIRA version is 4.4.4., Importers plugin 3.5.3

2 answers

1 accepted

Hi,

I agree there should be a select box to select values from an existing custom field but there's none. We haven't implemented it yet. I raised https://studio.atlassian.com/browse/JIM-731 for that, anyone interested please vote.

I guess new custom field is created because the one in JIRA has a limited context - like it's defined only for some projects or issue types. Am I guessing correctly?

JIM 3.x allows you to import only to global custom fields, it may show the custom field on the list, but later it will create a new one if it can't find a global custom field. I think there's a message in the log about that.

Cheers,

Pawel

Hi Pawel,

thank you for your reply.

Our custom fields are also limited for a specific issue type on one project so that could be the reason why the import did not work.

Atleast now we know the error is not on our side, but still we need to find another way to import the data. I was thinking about an using SQL query to the DB instead.



Hi, if I remember well in one step you choose what Custom Field will be mapped with what column of the CSV File. And then in order to select the values, you have to write in those text box you marked the value of the Select Custom Field. I'm not sure, but I think the values have to be already created in the custom field before doing the import.

Hi Ramiro,

yes we have the values already created in the existing custom fields but the import just creates whole new custom fields instead of using the already existing fields with values.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,932 views 12 18
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot