It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

CSV Import and creation of Sub-Tasks

Hi there,

I'm failing in the creation of sub-tasks in my jira import which worked great in old generation projects. Does anyone see the error? I might be blind.

I moved to the jira next-gen project which causes problems in my import of CSV to generate recurring tasks.

Jira complete the import but with the following errors, which lead to a non-creation of sub-tasks as well as Epics.

Import completed with 24 errors:

  • Issue 'DOC-6013' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6012'
  • Issue 'DOC-6014' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6012'

This is a screenshot of the CSV i'm importing which worked fine before but now i don't see where the error in the format is:

CSV for Import.png

 

Please find an Extract of the error log below:

2019-11-26 15:11:07,283 INFO - ------------------------------
2019-11-26 15:11:07,283 INFO - Importing: Issues
2019-11-26 15:11:07,283 INFO - ------------------------------
2019-11-26 15:11:07,283 INFO - Only new items will be imported
2019-11-26 15:11:07,386 INFO - Importing issue: [externalId='20191127', summary='2019-11 Monatswechsel']
2019-11-26 15:11:07,544 INFO - Importing issue: [externalId='20191128', summary='2019-11 Belege vorbereitet']
2019-11-26 15:11:07,642 INFO - Importing issue: [externalId='autoid--7945252159593576138', summary='2019-11 Kalender drucken & prüfen']
2019-11-26 15:11:07,732 INFO - Importing issue: [externalId='autoid--2504562105472326958', summary='2019-11 Kontoauszug  speichern (GLS, PayPal …)']
2019-11-26 15:11:07,818 INFO - Importing issue: [externalId='autoid--1395021589737671793', summary='2019-11 Einsatzprotokolle erfassen und ablegen']
2019-11-26 15:11:07,915 INFO - Importing issue: [externalId='autoid--2813587788594480597', summary='2019-11 Scans Ordner sortieren']
2019-11-26 15:11:08,006 INFO - Importing issue: [externalId='20191203', summary='2019-11 Buchungsnotizen verringert']
2019-11-26 15:11:08,109 INFO - Importing issue: [externalId='autoid--4074053383217461017', summary='2019-11 Auswertung ablegen (für Monat 2019-10)']
2019-11-26 15:11:08,196 INFO - Importing issue: [externalId='20191205', summary='2019-11 Interne Abrechnung beendet']
2019-11-26 15:11:08,295 INFO - Importing issue: [externalId='autoid-894000897561157267', summary='2019-11 Beleg/Quittung für Sachbezug abgeben (Milos)']
2019-11-26 15:11:08,405 INFO - Importing issue: [externalId='autoid--8467975715964546826', summary='2019-11 Beleg/Quittung für Sachbezug abgeben (Julia)']
2019-11-26 15:11:08,493 INFO - Importing issue: [externalId='autoid-8397029905708152919', summary='2019-11 Beleg/Quittung für Sachbezug abgeben (Regina)']
2019-11-26 15:11:08,596 INFO - Importing issue: [externalId='autoid-1141234078321607993', summary='2019-11 Beleg/Quittung für Sachbezug abgeben (Johanna)']
2019-11-26 15:11:08,714 INFO - Importing issue: [externalId='autoid-6984241208964359301', summary='2019-11 Fahrtenbuch extrahieren, unterschreiben, ablegen (Oliver)']
2019-11-26 15:11:08,816 INFO - Importing issue: [externalId='autoid-1778397612750922685', summary='2019-11 Reisekosten erstellen (für Oliver)']
2019-11-26 15:11:08,910 INFO - Importing issue: [externalId='autoid-3595423667468793315', summary='2019-11 Fahrtenbuch extrahieren, unterschreiben, ablegen (Milos)']
2019-11-26 15:11:08,997 INFO - Importing issue: [externalId='autoid-2598567120647592765', summary='2019-11 Reisekosten erstellen (für Milos)']
2019-11-26 15:11:09,082 INFO - Importing issue: [externalId='20191214', summary='2019-11 Belege abgelegt & verschickt']
2019-11-26 15:11:09,263 INFO - Importing issue: [externalId='autoid-8742784501508346147', summary='2019-11 Rechnungen und Belege ablegen']
2019-11-26 15:11:09,374 INFO - Importing issue: [externalId='autoid-1119630465601610863', summary='2019-11 Proforma Rechnungen erstellen']
2019-11-26 15:11:09,483 INFO - Importing issue: [externalId='autoid-398273569403312212', summary='2019-11 Rechnungen drucken und versenden']
2019-11-26 15:11:09,824 INFO - Importing issue: [externalId='autoid--110437931675280230', summary='2019-11 Unterlagen an Steuerberater verschicken']
2019-11-26 15:11:09,908 INFO - Importing issue: [externalId='20191219', summary='2019-11 PHV Abrechnung']
2019-11-26 15:11:10,005 INFO - Importing issue: [externalId='20191220', summary='2019-11 PHV Abrechnung durchgeführt']
2019-11-26 15:11:10,085 INFO - Importing issue: [externalId='autoid-4711257544044370330', summary='2019-11 Abweichende Dienste bestätigt']
2019-11-26 15:11:10,171 INFO - Importing issue: [externalId='autoid--3274396351097604756', summary='2019-11 Stundenaufstellung fertigstellen']
2019-11-26 15:11:10,257 INFO - Importing issue: [externalId='autoid-6685203818583930145', summary='2019-11 Rechnung erstellen und senden (PDF, phv-finanzen@doctoroo.org)']
2019-11-26 15:11:10,444 INFO - Importing issue: [externalId='autoid-7828744052422397449', summary='2019-11 Rechnung verschicken, an Regierungspräsidium.']
2019-11-26 15:11:10,525 INFO - Importing issue: [externalId='20191225', summary='2019-11 PHV Lohnlauf und Vergütungen erfolgt']
2019-11-26 15:11:10,613 INFO - Importing issue: [externalId='autoid-5406841754588278350', summary='2019-11 Lohnlauf durchführen']
2019-11-26 15:11:10,702 INFO - Importing issue: [externalId='autoid--9057318704717182617', summary='2019-11 Vergütungen überweisen']
2019-11-26 15:11:10,784 INFO - Importing issue: [externalId='20191228', summary='2019-11 PHV Betrag erhalten']
2019-11-26 15:11:10,866 INFO - Importing issue: [externalId='autoid-582574331086953527', summary='2019-11 Rechnungsbetrag erhalten und geprüft, von RP']
2019-11-26 15:11:10,944 INFO - 33 issues successfully created
2019-11-26 15:11:10,947 INFO - ------------------------------
2019-11-26 15:11:10,947 INFO - Finished Importing : Issues
2019-11-26 15:11:10,947 INFO - ------------------------------
2019-11-26 15:11:11,021 INFO - ------------------------------
2019-11-26 15:11:11,021 INFO - Importing: Issue Links & Subtasks
2019-11-26 15:11:11,021 INFO - ------------------------------
2019-11-26 15:11:11,021 INFO - Only new items will be imported
2019-11-26 15:11:11,027 INFO - Linking 'DOC-6013' and 'DOC-6012' as sub-task-link
2019-11-26 15:11:11,027 ERROR - Issue 'DOC-6013' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6012'
2019-11-26 15:11:11,036 INFO - Linking 'DOC-6014' and 'DOC-6012' as sub-task-link
2019-11-26 15:11:11,037 ERROR - Issue 'DOC-6014' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6012'
2019-11-26 15:11:11,045 INFO - Linking 'DOC-6015' and 'DOC-6012' as sub-task-link
2019-11-26 15:11:11,045 ERROR - Issue 'DOC-6015' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6012'
2019-11-26 15:11:11,058 INFO - Linking 'DOC-6016' and 'DOC-6012' as sub-task-link
2019-11-26 15:11:11,058 ERROR - Issue 'DOC-6016' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6012'
2019-11-26 15:11:11,066 INFO - Linking 'DOC-6018' and 'DOC-6017' as sub-task-link
2019-11-26 15:11:11,066 ERROR - Issue 'DOC-6018' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6017'
2019-11-26 15:11:11,075 INFO - Linking 'DOC-6020' and 'DOC-6019' as sub-task-link
2019-11-26 15:11:11,075 ERROR - Issue 'DOC-6020' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6019'
2019-11-26 15:11:11,084 INFO - Linking 'DOC-6021' and 'DOC-6019' as sub-task-link
2019-11-26 15:11:11,084 ERROR - Issue 'DOC-6021' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6019'
2019-11-26 15:11:11,094 INFO - Linking 'DOC-6022' and 'DOC-6019' as sub-task-link
2019-11-26 15:11:11,094 ERROR - Issue 'DOC-6022' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6019'
2019-11-26 15:11:11,102 INFO - Linking 'DOC-6023' and 'DOC-6019' as sub-task-link
2019-11-26 15:11:11,102 ERROR - Issue 'DOC-6023' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6019'
2019-11-26 15:11:11,110 INFO - Linking 'DOC-6024' and 'DOC-6019' as sub-task-link
2019-11-26 15:11:11,110 ERROR - Issue 'DOC-6024' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6019'
2019-11-26 15:11:11,118 INFO - Linking 'DOC-6025' and 'DOC-6019' as sub-task-link
2019-11-26 15:11:11,118 ERROR - Issue 'DOC-6025' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6019'
2019-11-26 15:11:11,126 INFO - Linking 'DOC-6026' and 'DOC-6019' as sub-task-link
2019-11-26 15:11:11,126 ERROR - Issue 'DOC-6026' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6019'
2019-11-26 15:11:11,134 INFO - Linking 'DOC-6027' and 'DOC-6019' as sub-task-link
2019-11-26 15:11:11,134 ERROR - Issue 'DOC-6027' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6019'
2019-11-26 15:11:11,142 INFO - Linking 'DOC-6029' and 'DOC-6028' as sub-task-link
2019-11-26 15:11:11,142 ERROR - Issue 'DOC-6029' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6028'
2019-11-26 15:11:11,153 INFO - Linking 'DOC-6030' and 'DOC-6028' as sub-task-link
2019-11-26 15:11:11,153 ERROR - Issue 'DOC-6030' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6028'
2019-11-26 15:11:11,162 INFO - Linking 'DOC-6031' and 'DOC-6028' as sub-task-link
2019-11-26 15:11:11,162 ERROR - Issue 'DOC-6031' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6028'
2019-11-26 15:11:11,170 INFO - Linking 'DOC-6032' and 'DOC-6028' as sub-task-link
2019-11-26 15:11:11,170 ERROR - Issue 'DOC-6032' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6028'
2019-11-26 15:11:11,185 INFO - Linking 'DOC-6035' and 'DOC-6034' as sub-task-link
2019-11-26 15:11:11,185 ERROR - Issue 'DOC-6035' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6034'
2019-11-26 15:11:11,194 INFO - Linking 'DOC-6036' and 'DOC-6034' as sub-task-link
2019-11-26 15:11:11,194 ERROR - Issue 'DOC-6036' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6034'
2019-11-26 15:11:11,203 INFO - Linking 'DOC-6037' and 'DOC-6034' as sub-task-link
2019-11-26 15:11:11,203 ERROR - Issue 'DOC-6037' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6034'
2019-11-26 15:11:11,232 INFO - Linking 'DOC-6038' and 'DOC-6034' as sub-task-link
2019-11-26 15:11:11,232 ERROR - Issue 'DOC-6038' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6034'
2019-11-26 15:11:11,244 INFO - Linking 'DOC-6040' and 'DOC-6039' as sub-task-link
2019-11-26 15:11:11,244 ERROR - Issue 'DOC-6040' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6039'
2019-11-26 15:11:11,257 INFO - Linking 'DOC-6041' and 'DOC-6039' as sub-task-link
2019-11-26 15:11:11,257 ERROR - Issue 'DOC-6041' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6039'
2019-11-26 15:11:11,265 INFO - Linking 'DOC-6043' and 'DOC-6042' as sub-task-link
2019-11-26 15:11:11,265 ERROR - Issue 'DOC-6043' is not of a sub-task type (Story). It will NOT be a sub-task of the issue 'DOC-6042'
2019-11-26 15:11:11,272 INFO - ------------------------------
2019-11-26 15:11:11,272 INFO - Finished Importing : Issue Links & Subtasks
2019-11-26 15:11:11,272 INFO - ------------------------------

 

1 answer

I have the exact same problem... does CSV import with subtasks not work with Jira Next Gen? In which case thanks for forcing me to waste the last 3 hours Atlassian!  

Hi @Douglas Rose ,

did you solve the problem for you? Seems there's not support here from Atlassian for this topic. Any suggestions how to drill this problem down?

Best Oliver

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Next-gen

Keyboard shortcuts have arrived for next-gen projects!

...ollected feedback from users around the lack of shortcuts, and we’re here to address that: In next-gen projects, I miss the keyboard shortcuts badly. This is particularly true on the Board, but also i...

345 views 3 7
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you