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
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:
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.
There are two possibilities of such situation.
To create subtasks via CSV file please use admin CSV Importer which is available under "External System Import" item in System section.
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:
Could you give that a try?
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.
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.
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot