It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

When Trying to import CSV file cannot find Issue type in the field mapping

Hi Experts
When trying to import issues from csv file - 
on the import wizard cannot find the field issue type in the dropdown if the jira fields
Can you please advise?
Thanks
Naama

5 answers

1 accepted

0 votes
Answer accepted
nic Community Leader Dec 17, 2014

What do you mean "cannot find the field issue type"?    Is it not appearing in the "map TO" drop down?

Hi Nic, 

Thanks for your replay - pls see below the details

1) I go to Issues->Import from CSV File

2) Choose a file and click Next

3) I choose the project and click Next

4) on the Map Field Windows : I would like to map the issue type however I cannot see it in the drop down list

Thanks

Naama

nic Community Leader Dec 17, 2014

It should appear (almost) at the top of the list. Can you check that you have more than one issue type in the project, and that the column you are trying to map is complete - no blank lines in it at all

Hi Nic, I have more than one issue type in the project, When i am running the same wizard from the administration panel , I can see the issue type - However I would like this option to be available to the users as well... Can you please advise? Thanks Naama

Hi Nic, When I am trying to import through the administration panel I get the following error: Error importing issue ExternalIssue{externalId=autoid-8547538591012086323, summary=RUM Engine setup & configuration, issueType=10102} However I cannot see the problem in my CSV file... Thanks Naama

nic Community Leader Dec 17, 2014

Aah, I see, it's not the full importer. No, you can't do issue type in there, it's fixed

nic Community Leader Dec 17, 2014

You'll need to read the log for more detail on that error, it's not enough to diagnose where the problem is.

Hi Nic, Sorry I didn't understand you answer... Users cannot import issues? and map the issue types?

Thanks Naama

Hi Nic, Can you please let me know - Users cannot import issues from csv and map it to issue types? Thanks Naama

I have the same question,,,the tool is relatively useless if users can't map issue type in the importer version found in issues tab. Also noticed they cannot import comments and reporter. There could be more...

Helllo sumtotal - I logged a support case and the problem was configuration of my default create issue screen... (witch I am not using...) Cheers Naama

Hi, Can you import the issue type now? I am having the same problem here. Thanks!

Hi Wei , It was a configuration of one of my customize screen that prevented the import, it didn't has - 'issue type' on the 'create issue type screen' Cheers Naama

Hi Naama,

Could you please let me know how you resolved this issue in steps, so that even we could implement the same.

Cheers.

Any update on this issue?  I am also facing same issue?

It seems that there are two kinds of CSV import:

a) Issues -> Import issues from CSV.

This is "not the full importer" (Nic Brough) but a kinda crippled variant where you cannot set issue type.

The documentation includes issue type, which might be a mistake in the documentation and contribute to user confusion.
https://confluence.atlassian.com/jirasoftwarecloud/creating-issues-using-the-csv-importer-764478441.html 

b) Administration > System > Import & Export > External System Import > Import

This is the full importer where you can set issue type, and is explained here: https://confluence.atlassian.com/adminjiraserver071/importing-data-from-csv-802592885.html

Thank you so much! I was able to have more control using the admin import.

Like Brandon Uniewski likes this

After spending a day trying to figure this out, here is the solution.

First, confirm that this functionality exists on your instance:

  1. go to JIRA Settings > System > External System Import.
  2. Attempt to upload a file and confirm if you have access to Issue Type.

If you do, this means that your JIRA instance supports the ability to map issue type for a CSV import, but that your edit screen is not configured. If you do not see this setting, unfortunately I do not have a solution.

 

In the case that you did see the Issue Type in the External System Import tool, you can modify your edit screens to allow all users to add Issue Type during an import. To do this:

  1. Navigate to Project Settings > Screens.
  2. Click on Action in the top right corner and select Edit Screens
  3. Next to Default, click on the Screen Scheme link
  4. Next to Default (again), click on the Screen link
  5. Under the Field Tab, scroll to the bottom of the screen and add Issue Type from the Select Field... drop down.

You should now be able to select issue Type from the standard issue importer when adding tickets as a normal user.

The issue key mapping is currently not available via Issues->Import issues from CSV, please vote for this feature request: https://jira.atlassian.com/browse/JRA-62865

 

The regular non-admin CSV importer will only let you pick fields you have available in your Create Screen.

It's not unusual for admins to leave out Issue Type from the Create Screen since you're forced to specify one.

Make sure you add Issue Type to you Create Screen, even though it seems superfluous.

Awesome answer, David.  This was the issue, that the Issue Type field wasn't on the create screens, so it could not be mapped in the non-Admin importer.   Wish others in this thread had reported this fact.   All the best.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Calling all Jira Cloud users! Give us feedback on our exploration of a new navigation.

Hi everyone! My name’s Matt and I’m a product manager at Atlassian. I work in the navigation & findability space for all our Jira Cloud products. We’ve been working on trying to improve the exp...

1,065 views 16 12
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you