CSV - loading story + task + sub-task

[timothy.schreiber]

I've created a pretty  simple CSV file to upload a template for managing project work.  The tool will not import the file in total without errors.  Can someone help me with my file format or is what i'm asking not something that CSV upload can do?  I have a story with tasks which seems to work correctly.  It's when the upload gets to the story with a task and sub-task that it appears to fatally fail.

[Petter Gonçalves]

Hello Timothy,

Welcome to Atlassian Community.

There are some incoherencies in your CSV file. A standard issue (Story) cannot be added as a parent of another Standard issue (Task), it can only be added as parents of Sub-task issue types.

Additionally, the issue ID and Parent ID are unique values added on the JIRA database which are usually automatically added in the issue when you create it. That been said, it would be a better practice to map the Issue Key and Parent Key instead of issue ID and Parent ID, using the project tag to define it. Let me give you an example:

Let's suppose you would like to import a parent and ira sub-task issue to a project called business (BSN). this would be the CSV:

issue key, parent key, summary, issue type

BSN-1, , Initiation / idea, Story

BSN-2, BSN-1, Identify Stakeholders, Sub-task

Another suggestion would be to export a CSV file from your existing issues to have a better idea of how JIRA would understand its format.

For more information about, check the documentation below:

- Importing Data from CSV

Let me know if this information helps, Timothy.

[Gurpreet]

please follow the guide here

https://confluence.atlassian.com/adminjiraserver0711/importing-data-from-csv-955168458.html#ImportingdatafromCSV-jirafieldtips

hope this helps