Trouble importing csv

[Wouter Markvoort]

I want to import epics, stories, etc into Jira

I have a test csv with only two items (and a few more fields than these, but this is what matters)

Issue ID, IssueType, Summary, Parent
1, Epic, Test epic,
2, Story, Test story, 1

When I import this csv file (into an existing project) , the epic gets imported just fine. It receives a key, "ABC-143". 

Now when it comes to importing the story, the importer tries to link it to the epic it just imported. But now I get this:

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

So the importer creates the epic, is smart enough to memorize the key it has just created, and to use that for the imported stories that it wants to link to that epic. 

So what goes wrong? The story gets imported btw, just not as belonging to the epic.

[justin-oh]

I'm experiencing this problem.

First we should clarify that what was previously called "Issue" is now apparently called "Work Item". When I go to map fields, instead of looking for "Issue type" I look for "Work type", instead of "Issue id" I look for "Work item id", etc.

In my organization, I am not restricted from creating new Work types. So that is not the problem. I can also see a "Parent" field on all Work types.

After import, all items (including Epics) get created. The Epic associations are missing but I can set them manually.

I even tried using the raw CSV from this page but I edited it to only have Epics and below:

issue type,issue key,status,summary,issue id,parent
Epic,test-125,To Do,Epic with parent and no child story but 1 sub-task and parent Inititive,3,
Epic,test-126,To Do,This is an epic with 1 story and 1 bug as child issues mapped,4,
Story,test-127,To Do,Example story 1 Summary no child issue mapped,5,
Story,test-128,To Do,"Example story with 1 child sub-task mapped, and a parent epic is mapped",6,4
Bug,test-129,To Do,bug with 1 child sub-task ,106589,4
sub-task,test-130,To Do,subtask 1,7,6
sub-task,test-131,To Do,subtask 2,8,106589
sub-task,test-132,To Do,Subtask 3,9,3

I get the same kind of errors after trying to import the above CSV:

• Cannot add value [ Work item ] to CustomField [JPT-126] in Parent Link with summary 'Example story with 1 child sub-task mapped, and a parent epic is mapped'. Probably value was in incorrect format
• Cannot add value [ Work item ] to CustomField [JPT-126] in Parent Link with summary 'bug with 1 child sub-task'. Probably value was in incorrect format

I have no clue how to proceed with / debug this problem anymore.

[Pasam Venkateshwarrao]

Hi @Wouter Markvoort 

check the story issue type screen fields whether parent field is added in story or not

[Wouter Markvoort]

Yes, it has a parent field.