CSV Import and creation of Sub-Tasks

[Oliver Emmler]

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:

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 - ------------------------------

[Douglas Rose]

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!  

[Oliver Emmler]

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