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; } } }

Errorperforming CSV import: Cannot add value to Epic Link - Probably value was in incorrect format

Rob Horan

This is a gross oversimplification, but assume you had a CSV with 2 issues:

Issue 1:

Summary - My Epic
Epic Name - Epic1

Issue 2:

Summary: My Story
Epic Link - Epic1

These import with no errors. I then go to import a second CSV, also with 2 issues:

Issue 1:

Summary - My Other Epic
Epic Name - Epic1

Issue 2:

Summary: My Other Story
Epic Link - Epic1

In this case, I get an error "Cannot add value [ [Epic1] ] to CustomField Epic Link in Issue with summary 'My Other Story'. Probably value was in incorrect format"

When manually creating issues, Epic Name does not need to be unique in a project. You can have two or more Epics with the same Epic Name, with their own issues linked.

In this case, each CSV is a complete unit: The Epic has its own unique Epic Name within in the CSV and the issues in the CSV point to the Epic Name in the CSV.

Does Epic Name need to be unique in a project when performing a CSV import? If so, shouldn't the error state that the value already exists, as opposed to suggesting the format is incorrect?

Accepted answers

John Funk

Hi Rob,

It doesn't look to me like the problem is with the Epic Name - it looks like it doesn't like the Epic Link value. That should be a key, like EPIC-1 or EPIC-2

Trudy P Claspill

Are you importing to a Company Managed project or a Team Managed project?

Assuming you are importing to Company Managed projects:

1. In the scenario where you are creating both the epic and then creating a story that should be a child of the epic, what exactly are you putting in the Epic Link field for the story? It should be a unique numeric ID that is in an "issue ID" field for the Epic.

2. In the scenario where you are importing another Epic and creating another story but assigning that one to the Epic created in scenario 1, what are you putting in the Epic Link field for the story? In that case, if the Epic already exists in JIRA, you should be providing the Issue Key (i.e. ABC-123) of the Epic.

While the Epic Link field in JIRA displays the Name of the Epic to which the story is linked, it actually stores the Issue Key of that Epic. It is an Issue Key story field that is automatically resolved in the UI to show the Epic Name value. When importing data, you need to treat the field as an issue key field.

All comments

John Funk

Hi Rob,

It doesn't look to me like the problem is with the Epic Name - it looks like it doesn't like the Epic Link value. That should be a key, like EPIC-1 or EPIC-2

Trudy P Claspill

Are you importing to a Company Managed project or a Team Managed project?

Assuming you are importing to Company Managed projects:

Rob Horan

Hi Trudy,

I do my best to only work with Classic/Company Managed Projects. The other thing.... eh

Assume there is data coming from another system. Nothing yet exists in Jira.

So I have the two CSVs below. I import the first, and as you see, The Epic, Story, and Subtask are imported with the structure intact. YAY!

The second CSV imports, but the Epic link field for the story cannot be populated.

AC Sample.png

Now this is being done in accordance with the example shown here:
https://community.atlassian.com/t5/Jira-questions/How-to-import-stories-linked-to-epics-in-jira/qaq-p/373117

The value of the Epic Link field for the story matches the value of the Epic Name field for the Epic. In the first case it worked. In the second, it failed.

This happens every time the Epic Name exists within the project I am importing into.

Trudy P Claspill

Hm, I have never done imports trying to use the Epic Name in the Epic Link field. I have always used Issue Keys. I would replace the text in the Epic Link field with the value from the ID field for the Epic.

John Funk

You need to use the Key and not the name.

Rob Horan

@John FunkHow do you use a key when the key doesn't exist?

The Epic is row 1 of the CSV and the Story is row 2.

I am importing the entire structure new.

The first time it works well. The Epic, Story, and Sub-task import flawlessly.

When I run another CSV with an Epic Name that already exists in the project that is where I get a failure.

Rob Horan

That definitely doesn't work I had tried it before, but here's the proof:

John Funk

You can't create both in the same CSV and link them in that case then with the existing name because that's all it has to go on. If you run it first with just the Epic and get it created and then use the key for that and run it again for the rest of them, you should be in good shape.

Tero Jukola

Context: Importing to a Company Managed project.

Hello there, I had exactly the same Cannot add value [ ... ] to CustomField Epic Link in Issue with summary '...'. Probably value was in incorrect format" with this CSV (UTF8 with BOM):

Issue Type;Summary;Issue ID;Parent ID
Epic;COTehtavalistaTESTing.6;1;0
Story;S1;101;1
Subtask;S11;1001;101
Story;S2;102;1
Subtask;S21;1002;102
Story;S3;103;1
Subtask;S31;1003;103
Subtask;S32;1004;103

I got only Epics and Stories (and relations btw the two) imported, but not the sub tasks.

This file was much more complex CSV file originally (including 343 rows in it, 3 epics, 35 stories and sub tasks the rest). I reduced the file by one thing at a time and rerun the import (at least 10 times) until I had simplified the file down to another CSV test file, which did import all the 3 levels of issue hierarchy nicely: Epic, Story, Sub-task

The test import file, that worked:

Issue Type;Summary;Issue ID;Parent ID
Epic;Epic1;1;0
Story;S1;100;1
Sub-task;subtask 1;1001;100
Sub-task;subtask 2;1002;100
Story;S2;101;1
Epic;Epic2;2;0
Story;S3;102;2
Epic;Epic3;3;0
Story;S4;103;3
Story;S5;104;3
Sub-task;subtask 3;1003;104
Sub-task;subtask 4;1004;104

So, what is the difference btw the two CSVs?

Answer: the issue type identifier string for the sub tasks: The problematic CSV had "Subtask" vs the successful having "Sub-task".

When I changed to the "Sub-task" notation, all three issuetypes (and relations Epic to Story, Story to Sub-task) did import successfully.

The root cause: The Jira Cloud configuration that I use, has two sub task issuetypes (namely "Sub-task" and "Subtask"), and so, the import process did find both of them, but obviously the characteristics of these two issue types are different (the Subtask being bad).

That is why I didn't understand the somewhat ambiguous error messages. And burned half a day with this simple import thing.

Message for Atlassian developers working on the new IMPORT/EXPORT: Look how the Microsoft Azure Devops Boards TWO WAY import/export with Excel is implemented, it's like a breeze compared to this very cumbersome Jira import. It is hard to make it better that that!

My 5 cents

Tero Jukola

https://www.linkedin.com/in/terojukola/

Wouter Markvoort

So I copied the CSV in this answer https://community.atlassian.com/t5/Jira-questions/Re-Errorperforming-CSV-import-Cannot-add-value-to-Epic/qaq-p/2683284/comment-id/1013224#M1013224 and tried it. Still the same issue, stories do not get linked to Epics.

The situation is now as follows:

I have an eighty line csv, I can import it to a new project, using the new importer. The entire parent-child structure stays intact.

I can not import it properly into an existing project using the old importer, not even into the new project I just imported. epic-story connections result in this error:

Cannot add value [ [ABC-143] ] to CustomField Parent Link in Issue with summary 'Test story'. Probably value was in incorrect format

Any ideas anyone? e.g. why the error mentions the Custom Field? That is not being used as far as I know.

Trudy P Claspill

Hello @Wouter Markvoort ,

Welcome to the Atlassian community.

This 3+ years old post has an answer accepted by the original author.

Please start a new post to get assistance for your situation. Click the Ask a question option at the top of the Community page to start that new post. Starting a new Question will also result in better visibility of your question to the entire community. Adding to an existing posts notifies only the original author and the people that already responded.

In your new post include the information you provided above as well as showing how you are mapping the CSV fields to Jira fields during the import. Also, tell us the project Type into which you are importing the issues; i.e. Team Managed or Company Managed, Software or Business or Service.

Welcome!

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

Quick Links

Find more posts tagged with

csv

cloud

jira-software

jira-software-cloud

import

epic-link

epic-name