Importing a CSV into JIRA and the fields are not available to map?

[Kellie McWhirter]

I have been trying to import a CSV into Jira, but I keep getting errors. 

The first way I attempted to do it was by going to the 3 dots on the right and selecting "Import work items from CVS." I kept getting errors.  The next way I tried was by going into the System settings, then "external system import", and I was even going to just make the new project and move the tickets over. Once I got to the mapping fields screen, I was unable to find some of the fields to link them to, even though the custom fields exist in Jira. I will attach a photo of what I see. For reference, the Google sheet has. values such as money, dates, names, emails, yes/no dropdown, multiselector, etc. It is not a simple Google sheet; it is very complex. 

[Trudy Claspill]

Hello @Kellie McWhirter 

Without drilling into specific fields...

Are you trying to create a new project as part of the import process or import into an existing project?

What is the project type into which you are trying to import data? You can find the project Type in the information available on the project list page:

https://<yourBaseUrl>/jira/projects?page=1&sortKey=name&sortOrder=ASC

Have you confirmed that the fields into which you want to import data

• exist in the Field Configuration used by the issues you are trying to create through the import? (applicable only if your target is a Company Managed project)
• exist in the Create Item/Issue screen that you would see in the UI for the Project and Issue types you are trying to create?

Beyond that we would need to start looking into the specific fields you are trying to fill and research if the field exists, if they are included on the correct screens, etc.

[Kellie McWhirter]

Thank you so much for responding! 

I tried both ways - the first way I attempted to import into a project that already existed, and it's a software project. I received several errors stating that the date format was incompatible and that certain fields were null. There were several more errors, but apparently I didn't save the info. The second way I created a new project, and that seemed easier; however, several of the fields were not shown as an option (the screenshot above). When I searched for the field, the option was not there. 

[Trudy Claspill]

When trying to go through External System Import were you using the old import experience or the new import experience available there?

• Were you trying to import to an existing project or create a new project during this scenario?
• When trying to import to an existing project was that project listed as Team Managed or Company Managed?

When trying to import from the All Work screen (where you clicked the three dots button)

• Were you trying to import to an existing project or create a new project during this scenario? I don't use that option, but it appears that you can only import to an existing project.
• When trying to import to an existing project was that project listed as Team Managed or Company Managed? It appears that only existing Company Managed projects are available in this scenario.

It will be easier to debug if we can focus on a single scenario at a time, clearly defining which options you are choosing as you step through the process.

[Kellie McWhirter]

Were you trying to import to an existing project or create a new project during this scenario? I don't use that option, but it appears that you can only import to an existing project.

This is the new option they introduced this year- it's in the admin settings

• First, I went to System settings
• Next, I went to "External System Import"  
• Selected CSV
• It then had me add a CSV, but forced me to make a new project where not all of the fields had mapping

When trying to import to an existing project was that project listed as Team Managed or Company Managed? It appears that only existing Company Managed projects are available in this scenario.

• For this one, it was a company-managed software project. This is the option I want to go with since it has all of the mapping; however, I kept getting errors. I am also confused about the date format

[Trudy Claspill]

Thank you for that additional information @Kellie McWhirter 

When trying to import to an existing project was that project listed as Team Managed or Company Managed? It appears that only existing Company Managed projects are available in this scenario.

• For this one, it was a company-managed software project. This is the option I want to go with since it has all of the mapping; however, I kept getting errors. I am also confused about the date format

Alright, let us work through the problems you are encountering when you try to import to an existing Company Managed project. 

Which path are you using to start the import? Are you going through the System > External System Import path, and using the "old experience"? Or are you going through the Search Work Items screen where you click the ... button and select Import Work Items from CSV?

What types of items are you trying to import? Are you trying to import items from multiple levels of the item type hierarchy, and connect them with parent/child relationships? Are you trying to add item linking relationships?

Can you provide a list of your CSV column headings and the corresponding Jira field mapping you are choosing?

What errors are you getting?

Can you provide a sample of the data you are trying to import that covers items that are resulting in errors?