Linking artifacts using excel import

Hi Don,

In DOORS Classic you could have used Link By Attribute feature out of the box to do this since you could choose the linking attribute.

In DNG you can only use the ID for the LBA feature.

So to achieve the same outcome in DNG you need to import your Reqs1 spreadsheet, then export it as a View, which will give you the DNG IDs.

Use VLOOKUP on your Reqs2 spreadsheet, converting your original Reqs1 indices into the new DNG IDs.

Import your Reqs2 spreadsheet, then use Link By Attribute to create the links between Reqs1 and Reqs2.

This will create base artifact links.

You will need to prefix the ID generated IDs with the module ID+'.' if you want module context links.

Yes you can import and link at the same time via spreadsheet.

The best way to set this up is to create a view containing all the attributes you want to import, including the link types, and then manually create a single link of each type on one of the artefacts. Then export the view to Excel.

This will give you a spreadsheet with the correct column name for the link, and will give you a template to follow for the cell content. All you need in the link cell to make a link is:

{LINK id=<value>}

where value will be the id of the target - linking to a base artefact only requires the artefact id, whereas linking to the target artefact within a module requires <module id>.<artefact id> as the value.

On the source artefact side, supplying just the id column will link from the base artefact, whereas supplying both an id column and a module column will link from the artefact within the module

we are company Softacus and among other things, we provide scripts for our customers.

Thank you.