Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

CSV Import for multiple sub-tasks error

Vicky Lawrence March 6, 2024

I'm having issues importing a csv with multiple sub-tasks.

Every time I run the import, it will only take the first sub-task in the list then generate the following error.  However, if I import the next item individually, it will create the sub-task without an issue.

Any idea how I can get the full list to import as sub-tasks?

 

The log shows:

2024-03-06 17:03:10,885 INFO - Importer started!
2024-03-06 17:03:10,885 INFO - Engine is running in Import mode
2024-03-06 17:03:11,042 INFO - All issues will be imported to project: Task Tracking - CX Team (TTCT)
2024-03-06 17:03:11,057 INFO - Creating issue: [externalId='TTCT-20', summary='Testing / Certification']
2024-03-06 17:03:11,516 INFO - Issue created successfully with Key [TTCT-39], [externalId='TTCT-20', summary='Testing / Certification']
2024-03-06 17:03:11,695 INFO - Creating issue: [externalId='TTCT-20', summary='Go Live / Production Date (set a date)']
2024-03-06 17:03:11,705 ERROR - Issue can't be created due to the error/s [ Parent issue ID: '27126' / Key: 'TTCT-39' can not be sub-task. ]
2024-03-06 17:03:11,712 INFO - Creating issue: [externalId='TTCT-20', summary='First production order / confirmation / ASN / invoice validated']
2024-03-06 17:03:11,721 ERROR - Issue can't be created due to the error/s [ Parent issue ID: '27126' / Key: 'TTCT-39' can not be sub-task. ]

 

The csv contains:

 

Issue IDParentIssue TypeSummaryPriorityCustomer NameAssigneeDescription
TTCT-20TTCT-20Sub-taskTesting / CertificationNormalElixir Kitchen  
TTCT-20TTCT-20Sub-taskGo Live / Production Date (set a date)NormalElixir Kitchen Switch staging set up to live account, ready for go live date
TTCT-20TTCT-20Sub-taskFirst production order / confirmation / ASN / invoice validatedNormalElixir Kitchen  

1 answer

1 vote
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 6, 2024

Hi Vicky - Welcome to the Atlassian Community!

It somehow thinks that the one you created is now the parent for the next one. If the Parent already exists, why do you have a column for Issue ID? And are you mapping that to anything on the import. If so, don't do that.  :)   Just get rid of that column. 

Vicky Lawrence March 6, 2024

Thank you that works!  I thought I saw somewhere that Issue ID needed to be included, but looks like that was the block for getting multiple sub-tasks to load.

Like John Funk likes this
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 6, 2024

Great! You would need that if you are creating the parent at the same time, you are creating the sub tasks.

Vicky Lawrence March 7, 2024

Good to know, that's very helpful as well :)

Like John Funk likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events