How to batch import both new requirements and update existing requirements in DOORS Next with hierarchy?
I am trying to batch upload a .xlsx file that both updates existing requirements and adds new requirements. It is important that hierarchy is maintained.
I am currently testing it with this table:
Identifier Artifact Type Primary Text isHeading parentBinding ID
100 Heading Test Subheading 1.2 true 2439023 3424090
101 System Functional Test system functional false 3424090 3424091
200 Heading NEW Test Subheading 2.0 true 2439023
201 System Functional NEW system functional false 200
The first three artifacts import correctly and under the heading that I intend. However, 201 NEW system functional is not properly parented to 200 Heading. Instead, it ends up at the bottom of the module.
Removing the ID column allowed 200 Heading and 201 System Functional to import correctly, but without it, 100 and 101 did not update the existing requirements and loaded in separately.
How do I batch import to DNG when there are both new requirements and updates to existing requirements?
Accepted answer
parentBinding uses the ID column to create the hierarchy, so you need to put the 200 in the ID column for it to work.
If the ID column contains a number that doesn't exist in the project area in which you're importing the file, then the row is treated as a new requirement but the parentBinding will still work