It's all about the answers!

Ask a question

Linking artifacts using excel import


Don Max (24919) | asked Jul 11 '20, 11:11 a.m.
We have a requiremnent to import data to RDNG (6.0.6) from excel files. The artifacts in the excel files needs to be linked while importing. For example we need to link artifact A in one excel file with artifact B in another excel. The excel files has a column which has details about to which artifact link needs to be made.
Is it possible to make these links while importing.?
Since the amount of data is quite high, importing the excel files seperately and then manually linking is very time consuming. Any suggestions are welcome.

Thank you

3 answers



permanent link
Sean F (1.3k22556) | answered Jul 11 '20, 12:19 p.m.
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.


Comments
Don Max commented Jul 12 '20, 3:38 a.m.
Hello Sean,
 
Thank you for the suggestion. I will check and share a feedback

permanent link
Davyd Norris (1.1k8) | answered Jul 11 '20, 9:02 p.m.
edited Jul 11 '20, 9:03 p.m.
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


Comments
Don Max commented Jul 12 '20, 3:37 a.m. | edited Jul 12 '20, 3:39 a.m.
Hello Davyd,

   Thank you for the suggestion. I have tested the same and its not working as expected with only the {LINK id=<value>}or {LINK id=module id.artifact id}. We need to pass the artifact uri also which makes this method not practical. Please let me if am doing it wrong.




Davyd Norris commented Jul 12 '20, 7:13 p.m.

Something else must not be quite right in your import - you can definitely do it without the uri


permanent link
Erik Novysedlák (11) | answered Jul 16 '20, 1:25 a.m.

 Hello,


we are company Softacus and among other things, we provide scripts for our customers.
We have something like this:

Does the script fulfill your needs? If so, you can contact us on info@softacus.com
If not, we can also develop it for you.


Thank you.

Your answer


Register or to post your answer.