It's all about the answers!

Ask a question

Is there a way to link test cases to requirements using the xls for uploading test artifacts?


Elizabeth Mai (1726) | asked Apr 08 '15, 4:29 p.m.

I'm wondering if there is a way to export the requirements to obtain the artifact id, take the artifact id and add a column to the .xls used for importing test artifacts to identify the relationship to the test case.

Similarly, I'm wondering if there is a way to link test scripts to test cases using the import tool. 

2 answers



permanent link
Don Yang (7.7k21109138) | answered Apr 08 '15, 6:54 p.m.
The current way to link a test case and requirement(s) is explained in https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter, in which it requires manual selection of requirement during exporting.
The feature of having the requirement id(or title) to be a part of xls file and use cfg file to export the link into RQM has been discussed. It is still under consideration in this RFE workitem:
https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=126460

Please comment there so that it can be implemented at earliest.

Regarding export multiple testcases linking to multiple test scripts, yes, it is achievable but you will need to put test cases and test scripts into separate sheet for multi-multi links export. I asked similar question before in this post:
https://jazz.net/forum/questions/177517/rqmexcelimporter-export-multiple-testcases-each-with-multiple-test-scripts-into-rqm

Hopefully this helps.

permanent link
Bas Bekker (1.4k4) | answered Apr 09 '15, 1:02 a.m.
JAZZ DEVELOPER
Using the RM CSV export function, you can add the 'Validated By'  column to a view, and run the export.
This will add a column with the testcase "id: title" format (or corresponding test artifact depending of RM artifacts in the view) in the output CSV file.
RM does not provide functionality to establish Validated By links from a CSV import.

Here you can find some more info on RM importing and exporting using the CSV format.

Your answer


Register or to post your answer.