Missing fields for mapping when importing issues through CSV in Jira

Still need help?

The Atlassian Community is here for you.

Ask the community

Summary 

When importing issues through a CSV file into Jira, on the field mapping screen, the user can't find a certain field to map because it is not shown on the drop-down list.

Example scenario

On the field mapping screen, the user can't map the field Issue Type because it is not shown on the drop-down list.


Environment

All versions of Jira Core 7.x and 8.x


Diagnosis

  1. The expected field is not mapped in the Field Mapping step of CSV import.
  2. When trying to manually create the record through Jira's "Create" button on the header, such fields are also not present in the creation screen.


Cause

A) The missing fields are not present in the respective Create Issue Screen for that issue type in that project.  For information related to assigning screens to specific operations such as the Create operation please see Associating a Screen with an Issue Operation.

B) The field is one of the banned fields for bulk create issues:

  • Attachment
  • Created
  • Creator
  • Custom Fields
  • Due Date
  • Issue key
  • Issue Links
  • Issue Type
  • Last Viewed
  • Original Estimate
  • Project description
  • Project key
  • Project name
  • Project type
  • Project url
  • Resolution
  • Resolved
  • Security Level
  • Status
  • Time Spent
  • Updated
  • Watchers
  • Worklog

(info) A and B happen only when importing using the Issues > Import Issues from CSV path. The fields should show up normally in Administration > System > External System Import > CSV.

C) If the CSV import file has two columns with the same title (this can happen for fields that accept multiple values), the importer screen will limit the fields available to only those that can accept multiple values (such as labels, affected versions, Components, etc)


Solution

A) Missing fields in create screen

  1. Go into the respective project administration screen
  2. Click on the project's Screen Scheme
  3. For all affected issue types, edit their respective Create Issue Screen and add the missing fields

OR

  1. Import the CSV using Administration > System > External System Import > CSV

B) Banned field

Request an admin to import the CSV or don't import those fields.

C) Duplicate columns in CSV file

You can either select a field that can accept multiple values, or alternatively, you could rename one of the columns in the CSV file before importing it in order to place that data into a different field.


Some fields may be available for mapping in the CSV import if they're present in any Create Screen in use by that Project, but their values will only be persisted by Jira if the field's present on that respective Issue Type Create Screen.




Last modified on Mar 8, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.