Problem with CSV upload

Currently on JIRA On Demand and facing an import issue with the CSV. It seems that while it was working in the past, at some point it stopped but not sure if I am doing something wrong. The CSV I try to upload is:


Issue Type,Summary,Priority,Assignee,Due Date,Description,Issue ID,Parent ID

Simplified Task,Summary 5,High,chpsar,20/07/2014,,5,

Simplified Sub-task,Summary 5.1,High,chpsar,20/07/2014,"This is a description

with multiple


Simplified Sub-task,Summary 5.2,High,chpsar,20/07/2014,,,5


The date format I am using in the configuration is dd/mm/yyyy


When I try to validate the file I get the following two errors:

  • Issue can't be created due to the error/s [ You did not enter a valid date. Please enter the date in the format "d/MMM/yy", eg. "12/Sep/14" ]
  • Issue can't be created due to the error/s [ Issue type is a sub-task but parent issue key or id not specified. ]


Any ideas what am I doing wrong?


I have also tried the format proposed in the date error message and again I got the same error.


Thank you

6 answers

1 accepted

4 votes
Accepted answer

Hi Haris,
There are two possibilities of such situation.

  1. SubTask are not enabled (but you have just confirmed that they are, so I believe it's not the case)
  2. You are using Bulk Create (new added feature, available under Issues top level menu) - Bulk Craete is not yet supporting SubTasks, but it's a frequently asked feature, so we are considering adding it in near future. Connected improvement request is reported in JIM project:

To create subtasks via CSV file please use admin CSV Importer which is available under "External System Import" item in System section.

Hi Haris,

First, inside your CSV file you need to change ALL the dates to this format: "d/MMM/yy", eg. "12/Sep/14".

After that, when doing the mapping you need to also map the following fields:

  • issue id (that will be the issue key on your CSV file)
  • parent id (that will be the issue key of the parent issue of this subtask on you CSV file)

Could you give that a try? smile


Hello and thank you for your answer.


The problem with the date seems to be overcome (weird as I have used the exact same changes in the past and it would not work). Concerning the task and sub-task, I am having an issue there still. To which fields should I map these two values? I do not have any relevant options in the drop down lists of the Map Fields screen and the Map Field Value option cannot be checked.


Thank you

I just tried to reproduce your problem (JIRA 6.2 and JIM 6.2.3) and I was able to import everything correctly, that's the configuration that I used:


The only thing I did before the import is making sure that I have enabled sub-tasks and "Simplified Sub-task" exists and is a Sub-Task Issue Type.

Hello and thank you too for your answer,


Find below a screenshot of when I try to map the Issue ID csv field to the relevant JIRA field. There is no option for Issue Id. Same happens for the Parent ID. Don't know if I am doing something wrong.

image2014-9-16 15:2:43.png


Sub tasks are enabled in the installation and the "simplified sub task" is a sub-task type of issue.

I am working on the cloud version so, currently on JIRA 6.4.


Thank you


Thank you very much, that did it. You really need to note that the two importers are different so that people do not get mixed up.


Thank you very much for the clarification and the help.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Jira

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,083 views 0 8
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you