I am not working as a system administrator. but as a normal user. I only have access to 1 project and start the csv import from the create button in the top menu bar. I want to upload a file with tasks and subtask, under an already existing Epic. * Tasks cannot be related to parent Epic For the task, I put as Parent ID the Epic name. The validation process responds: Issue 'Task 1' doesn't have Subtask Issue Type, its Parent Id mapping will be ignored. So how can I relate tasks to existing Epics? Based on the validation reply it is not possible to relate tasks to Epics...( * Should the tasks and the sub tasks be in the same or in separate files. * Subtasks are not uploaded. Error;doesn't have a valid Parent Id selection I tried uploading 2 subtasks. For 1 Subtask 1 specified the task name as Parent ID. For the other I specified the Issue ID of the task as parent ID. None worked, See upload file below Issue Type, Issue ID, Parent ID, Summary , Description , Assignee , Reporter Task , 100 , TestEpic , Task1 , Task1 , fvb , fvb Subtask , 1001 , 100 , Sub of task 1 , Sub of task 1, fvb , fvb Subtask , 1002 , Task1 , sub2 of task 1,sub2 of task 1, fvb , fvb

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

Upload Epic, Task and Sub task via CSV is not working

Fred van Beek

I am not working as a system administrator. but as a normal user.
I only have access to 1 project and start the csv import from the create button in the top menu bar.

I want to upload a file with tasks and subtask, under an already existing Epic.

Tasks cannot be related to parent Epic
For the task, I put as Parent ID the Epic name.
The validation process responds: Issue 'Task 1' doesn't have Subtask Issue Type, its Parent Id mapping will be ignored.
So how can I relate tasks to existing Epics? Based on the validation reply it is not possible to relate tasks to Epics...(
Should the tasks and the sub tasks be in the same or in separate files.
Subtasks are not uploaded. Error;doesn't have a valid Parent Id selection
I tried uploading 2 subtasks. For 1 Subtask 1 specified the task name as Parent ID.
For the other I specified the Issue ID of the task as parent ID.
None worked,

See upload file below

Issue Type, Issue ID, Parent ID, Summary , Description , Assignee , Reporter
Task , 100 , TestEpic , Task1 , Task1 , fvb , fvb
Subtask , 1001 , 100 , Sub of task 1 , Sub of task 1, fvb , fvb
Subtask , 1002 , Task1 , sub2 of task 1,sub2 of task 1, fvb , fvb

Accepted answers

All comments

Ismael Jimoh

Hi @Fred van Beek

With regards your CSV import,

With Epic, please use the epic link field as the parent/child fields are reserved for Task -> sub-task association. As you are bot the admin, make sure you can create and associate the issues from the Jira project’s create issue screen first else your import will potentially fail.
You can put tasks and sub-tasks in the same file but you must make sure your tasks come before any sub-tasks that will be related to them.
Your sub-task shouldn’t need an issue id . All it requires is a parent id. Do not use issue summary for parent id also.

Regards

Fred van Beek

Hi Ismael, Thanks for your quick answer

Actually I was looking for a field Epic Link ( I have seen when someone logged in as admin), but that field is not available for linking in my view (see screen print below)

I put a value in the parent ID of the taskm because it is mandatory. When not putting a value for parent ID for the task, an error appears> Fatal error during import: Parent Issue cannot be null

Epic Link not available.JPG
Other things are understood.
I adjusted file as suggested.

Issue Type,Issue ID,Epic link ,Parent ID,Summary ,Description ,Assignee,Reporter
Epic , 1, , ,Test Epic ,Test Epic ,fvb ,fvb
Task , 100,Test Epic , ,Task1 ,Task1 ,fvb ,fvb
Subtask , 1001, ,100 ,Sub1 ,Sub1 ,fvb ,fvb
Subtask , 1002, ,100 ,Sub2 ,Sub2 ,fvb ,fvb

Ismael Jimoh

Hi @Fred van Beek

Can you confirm that the epic link field appears when you click the create button in JIRA?

Without this field appearing, you will not be able to import it since you are not the system admin of the instance and the basic import, follows the fields provided on the create screen.

See below from my test:
Screenshot 2020-06-02 at 10.28.46.png
Regards.

Fred van Beek

I can con firm that the Epic Link field does NOT APPEAR

Seems like a bug to me.

I was able to create tasks and subtasks, but could not link the task to an Epic.
Same for stories. Can create but cannot link to the Epic.

In the end I used upload to create stores and sub tasks, but linked the stories manually.

why are mapping fields not same as in Supervisor Mode.
Upload of project data is a user action.
Normal user upload should work as well.

auj012

Hi Daniel

Any update on this topic ? Where U able to create tasks under a epic via csv ?

Please share I am getting the same error

Thanks

Daniel Alonso_s2e064

Thanks for checking in.
I reached out to my Jira Admin and got no response.
So unfortunately no real solution here.

However I found a decent workaround:

After you upload your tasks, you can click the link to view them.
In this view, you can do a bulk change to set their Parent to the Epic you want.
It only takes maybe a few more minutes to do this extra step, so it's still pretty efficient.

Screen Shot 2022-02-04 at 9.25.12 AM.png

For my use-case all of my tasks are generally assigned to the same Epic after I upload them, but I can imagine it being more tedious if you need to assign them to different Epics.

auj012

Thank you Daniel. On my systems "Components" was a mandatory field , once I added and mapped it I was able to create it.

Thanks

Welcome!

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

Quick Links

Find more posts tagged with

csv

jira

cloud

jira-software

import