Uploaded image for project: 'JIRA Importers Plugin'
  1. JIRA Importers Plugin
  2. JIM-230

As an admin I would like to be able to create subtasks through the CSV importer

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5
    • Component/s: CSV
    • Labels:
      None

      Gliffy Diagrams

      1. subs.png
        26 kB
      2. subtasks.config
        0.6 kB
      3. subtasks.csv
        0.4 kB

        Issue Links

          Activity

          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: wseliga; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Wojtek Seliga added a comment -

          Putting it to 2.4 - that's long awaited issue (8 years old, many votes!).
          We should prove that we can do it NOW!

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: wseliga; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Wojtek Seliga added a comment - Putting it to 2.4 - that's long awaited issue (8 years old, many votes!). We should prove that we can do it NOW!
          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: rkrishna; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Roy Krishna added a comment -

          We will do this after the bulk of PT polishing is complete. (post 2.4)

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: rkrishna; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Roy Krishna added a comment - We will do this after the bulk of PT polishing is complete. (post 2.4)
          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: pniewiadomski; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Pawel Niewiadomski added a comment -

          In case parent id is wrong there should be an error.

          In case issue has non sub-task issue type and parent id is set there should be an error.

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: pniewiadomski; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Pawel Niewiadomski added a comment - In case parent id is wrong there should be an error. In case issue has non sub-task issue type and parent id is set there should be an error.
          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: wseliga; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Wojtek Seliga added a comment -

          Better error handling will be covered in JIM-411

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: wseliga; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Wojtek Seliga added a comment - Better error handling will be covered in JIM-411
          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: wseliga; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Wojtek Seliga added a comment -

          I am attaching sample files showing how to create sub-tasks using CSV importer.
          Important thing is: for parent tasks you should allocate a column containing their id (it can be any unique string) and define the mapping for this column to "Issue Id", for child tasks (sub-tasks) you should have another column containing the reference to its parent (the same unique key) and which should be mapped to "Parent Id".
          You need to also remember about mapping issue types.

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: wseliga; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Wojtek Seliga added a comment - I am attaching sample files showing how to create sub-tasks using CSV importer. Important thing is: for parent tasks you should allocate a column containing their id (it can be any unique string) and define the mapping for this column to "Issue Id", for child tasks (sub-tasks) you should have another column containing the reference to its parent (the same unique key) and which should be mapped to "Parent Id". You need to also remember about mapping issue types.
          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: dafemec; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Doug Femec added a comment -

          For the second and third subtasks in subtasks.csv, how will My Issue Id be assigned?

          I am presently working on exporting content from VersionOne to JIRA and plan on using the CSV importer. I will let you know how it goes, especially the subtasks part.

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: dafemec; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Doug Femec added a comment - For the second and third subtasks in subtasks.csv, how will My Issue Id be assigned? I am presently working on exporting content from VersionOne to JIRA and plan on using the CSV importer. I will let you know how it goes, especially the subtasks part.
          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: rkrishna; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Roy Krishna added a comment -

          @Doug,
          In subtasks.csv, subtasks 2 and 3(rows 5 and 6) do not require a value for 'My Issue Id'(column G) because it only reflects the parent issue. Row 4 has a value there just as an example to show that subtasks can have their own Ids(but it's not used in the import).

          Unable to render embedded object: File (sub.png) not found.

          We also look forward to your results on using the CSV importer with VersionOne.

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: rkrishna; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Roy Krishna added a comment - @Doug, In subtasks.csv, subtasks 2 and 3(rows 5 and 6) do not require a value for 'My Issue Id'(column G) because it only reflects the parent issue. Row 4 has a value there just as an example to show that subtasks can have their own Ids(but it's not used in the import). Unable to render embedded object: File (sub.png) not found. We also look forward to your results on using the CSV importer with VersionOne.
          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: detheridge; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} detheridge added a comment -

          just to confirm - JIM 2.7.3 does not support importing sub-tasks against an existing parent task, correct? I was able to import sub-tasks against new parents in the same csv, but I couldn't upload sub-tasks to an existing parent. I kept getting this error in the log "ERROR - Unable to link issue from 1 to PMO-2740 with link named 'sub-task-link': Cannot find imported issue key for external id 'PMO-2740'", where "PMO-2740" is the id of an existing parent issue and what I entered in the parentID field, and '1' was the unique string I created in the issuetype field. Hopefully Im just doing something wrong. thx.

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: detheridge; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} detheridge added a comment - just to confirm - JIM 2.7.3 does not support importing sub-tasks against an existing parent task, correct? I was able to import sub-tasks against new parents in the same csv, but I couldn't upload sub-tasks to an existing parent. I kept getting this error in the log "ERROR - Unable to link issue from 1 to PMO-2740 with link named 'sub-task-link': Cannot find imported issue key for external id 'PMO-2740'", where "PMO-2740" is the id of an existing parent issue and what I entered in the parentID field, and '1' was the unique string I created in the issuetype field. Hopefully Im just doing something wrong. thx.
          Hide
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: pniewiadomski; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Pawel Niewiadomski added a comment -

          It does not.

          Parent/child linking is done only between issues from CSV.

          Cheers,
          Pawel

          Show
          {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: pniewiadomski; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Pawel Niewiadomski added a comment - It does not. Parent/child linking is done only between issues from CSV. Cheers, Pawel

            People

            • Assignee:
              {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: wseliga; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Wojtek Seliga
              Reporter:
              {annotationCollection: [{}], annotations: [{}], collectionInheritableAnnotations: [{}], declaredAnnotations: [{}], description: Annotated value: rkrishna; Annotations: [@com.atlassian.velocity.htmlsafe.HtmlSafe()]} Roy Krishna
            • Votes:
              8 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Who's Looking?