nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Some problems in trying to import CSV file

Jim Stewart_1wcyht

In our company, we have a database of people's objectives and the actions they must take to meet them. While it is a viable storehouse, it is not useful for tracking activities week-to-week.

So I was asked to download the information and import it into Jira Software. The goal is simple - each person's objectives and related activities will be imported and then we'll run one-week sprints for them to work on the activities.

The issue I'm having is in importing. I've attached a picture of a very small sample file. I figure if I get this right, the rest will just be a matter of duplicating this for all users.

In this instance, our security guy has an objective of "Renew Cyber Insurance." I would like that to be an epic. And then he has a related task (or issue) of "Complete Tech E&O." which should be an issue in that Epic.

I mapped Assignee to Assignee, Objective to Epic Name and Summary to Summary.

On importing, the issue (or activity) is created correctly and the assignee is correct. (I don't know why Summary creates it as an issue but it does.) But as to the epic, not only does it not show up attached to the issue but it doesn't show up at all. I get this error: "Cannot set value for locked custom field 'Epic Name' in issue '"Complete Tech E&O",' because it is not applicable for issue type 'Story'.

Accepted answers

Hana Kučerová

Hi @Jim Stewart,

information about Epic is stored in the field Epic Link, so if you want to import issues to some Epic, the file needs to look like this:

Please try to fill the reference to epic to the field Epic Link and map this column during import.

All comments

Hana Kučerová

Hi @Jim Stewart,

information about Epic is stored in the field Epic Link, so if you want to import issues to some Epic, the file needs to look like this:

Please try to fill the reference to epic to the field Epic Link and map this column during import.

Jim Stewart_1wcyht

Does the epic already have to exist? I've been trying to import epics and issues and have them link.

Jim Stewart_1wcyht

I'm still not getting this. I created a non-production project. I also created a CSV file based on yours just to see if I can get anything to import correctly. If I am understanding your graphic, line 2 establishes that I want to create an issue type of Epic and I want to call it "Test Epic Name." Line 3 establishes that I want to create a story called "Test Story" and map it to epic "Test Epic Name" that I am also creating.

I am mapping Issue Type to Issue Type, Summary to Summary, Epic Link to Epic Link, Epic Name to Epic Name.

The results are that Test Epic and Test Story get created as issues and no epic is created

Errors

Cannot set value for locked custom field 'Epic Name' in issue '"Test Epic",' because it is not applicable for issue type '"Epic",'
Cannot add value [ [,] ] to CustomField Epic Link in Issue with summary '"Test Epic",'. Probably value was in incorrect format
Cannot add value [ ["Test Epic Name"] ] to CustomField Epic Link in Issue with summary '"Test Story",'. Probably value was in incorrect format

Hana Kučerová

Hi @Jim Stewart

"Does the epic already have to exist? I've been trying to import epics and issues and have them link."

No. Epics can be created during import, that's ok. You just need to link them correctly.

I've found a nice explanation about Epics - names and links - please look at it. I hope it will clear the situation for you.

Cannot set value for locked custom field 'Epic Name' in issue '"Test Epic",' because it is not applicable for issue type '"Epic",'
Cannot add value [ [,] ] to CustomField Epic Link in Issue with summary '"Test Epic",'. Probably value was in incorrect format
Cannot add value [ ["Test Epic Name"] ] to CustomField Epic Link in Issue with summary '"Test Story",'. Probably value was in incorrect format

Your mapping is right, but I can see there is some problem with the data formatting. There are some extra commas and quotes, which are not parsed well. If you edit the csv import file in some text editor like Notepad, how does the data look like?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud