Use RQM Excel Importer to import associated Test Case, Test

Hi All,

I am writing a .cfg file to import Requirement, Test Case and Test Script from Excel to RQM.

I am aware of the article on jazz.net (https://jazz1.torolab.ibm.com/wiki/bin/view/Main/RQMExcelWordImporter). I created a sample Excel file and a cfg file according to the instructions in the article and provided examples.

But I still couldn't make the association between "test case and requirements", "test case and test scripts" to be imported into RQM.

In my sample Excel file, there are:

Requirement 1 --- Test case 1 --- Test Script 1;
Requirement 2 --- Test case 2 --- Test Script 2;
Requirement 3 --- Test case 3 --- Test Script 3;

What the I want is to link Requirement, Test Case and Test Script to each other. For example, "Requirement 1" <<link>> "Test case 1" <<link>> "Test Script 1".

I have been able to import requirements, test cases and test scripts into RQM successfully.

Now the problem is how to link **single** requirement, test case and test script to each other respectively. I tried the methods in provided sample cfg files but could make what they want.

Please see below what I have tried.

// Link test case to test script
// Below lines will link test case and test script to each other BUT also create duplicate test cases in test script's name <<<
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description

//Link test case to requirement
//This line will link test case to ALL requirements in the xls file <<<
testcase.XLSLink=requirement

I also found that above two sections cannot be used together, otherwise the link between requirements and test case will be missing.

Any input will be appreciated.