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.

Hi,
Multiple artifact linking isn't supported yet in the tool. The ability is covered in WI 25869.

Hi,

I have succefully imported artifacts linked to other artifacts using the XLSLink notation in the cfg file.

But this works only if I could import everything at the same time. What if I need to import test case and link it to an already EXISTING requirement?

Do you now if this can be done?

Thanks!

Matteo

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.

Hi,
We are trying to upload test cases and test scripts together.
We have used the following mapping command.

testcase.XLSLink=testscript

When we are uploading all the test scripts are getting mapped to all the test cases. Can anyone suggest a method to map a particular test script to a particular Test case

Hi,

you have to split your records into several excel sheets: put 1 parent and N childs (1 TC & N TS script) for each sheet.

Also do not declare the sheet name in the conf file, the import will process all the sheets.

Regards,

Matteo

Hi,
Multiple artifact linking isn't supported yet in the tool. The ability is covered in WI 25869.

When is this ability to be released, Mike? It would be extremely useful to be able to link plans to cases to scripts. My understanding is that this WI 25869 is the solution. Is this correct?

Thank you and regards,

Andrew

May i... introduce u a c#/.net component? Spire.XLS for .NET from e-iceblue.

Hi alll

I am currently doing some research for the project team in regards to importing and exporting our Requirements, Test Cases, Test Scripts etc into RQM.

After reading all the relevant documentation i understand i will need to create a .cfg file which in most cases will be tailored to specific project needs however i am wondering is there is a basic generic .cfg file i can obtain to begin to understand what is needed to produce one for myself.

I am tasked to look in to the best practice of getting all our test data into RQM on behalf of the team so i am hoping someone can give me some basic lessons learnt advice or even point me in the direction of a basic commonly used cfg file to have a look at.

Once the config file is created is there anything else i would need to consider which i have already come across (just so that i am one step ahead of the game)

Your help would be greatly appreciated

Thanks in advance

Vishal-UK

Hi All,

I am writing a .cfg file to import 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 test scripts" to be imported into RQM.

In my sample Excel file, there are:

Test case 1 --- Test Script 1.1;
Test case 1 --- Test Script 1.2;
Test case 2 --- Test Script 2.1;
Test case 2 --- Test Script 2.2;
Test case 3 --- Test Script 3.1;
Test case 3 --- Test Script 3.2;
Test case 3 --- Test Script 3.3;

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

I am able to get the XML generated but every test case is linked and generated to all the test scripts, instead of it should link on the test case 1 to test scirpt 1.1 and 1.2 into RQM successfully.

The CFG file i am using to generate the XML is below:

*************************************************************

//---Test Scripts
// Start looking for scripts after row 2
testscript.XLSStartRow=2

// use the data in the first row of a found script's column B
// Test script is using the same XLSArtifactID as requirement
testscript.XLSArtifactID=B
testscript.dc:title=D
testscript.dc:description=E
testscript.dc:state="Draft"

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="Manual"
testscript.steps.description=G
testscript.steps.title=F
testscript.steps.name=D
testscript.steps.expectedResult=H

// a new script starts when we encounter an empty row
//testscript.XLSDelimeter=\n

//--- Test Case
// Start looking for test case after row 2
testcase.XLSStartRow=2

// a new test case starts when we encounter an empty row
//testcase.XLSDelimeter=\n

//Test case and requirement are having the same XLSArtifactID
//This is for the TestCaseUpdater Utility
//testcase.XLSArtifactID=A
//testcase.XLSArtifactID=D
//testcase.ID=requirement.XLSArtifactID


//Link test case to requirement
//This line will link test case to all requirements in the xls file
//testcase.requirement=requirement.identifier

// Link test case to test script
// self referential links must be declared before also using column definitions
// Below lines will create test case and test script in same name but they can link each other
testcase.dc:title=B
testcase.dc:description=C
testcase.dc:state="Draft"
//testcase.dc.category=E3
//testcase.dc.test phase=F3
testcase.dc:category="Forms Factory"
testcase.dc:Phase="System Test"
testcase.weight="100"
testcase.XLSLink=testscript
*************************************************************

Any input will be appreciated.

A couple of points:

-See the examples (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration), specifically Scripts that create testcases.cfg.

-Look at self referential links (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Data_locations_and_self_referent).

A couple of points:

-See the examples (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration), specifically Scripts that create testcases.cfg.

-Look at self referential links (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Data_locations_and_self_referent).

Hi Paul,

thks for your input... can i ask for your advise on the Test Case Updater thingy?
I understand that It is tested with RQM 2.0.0.1 and applicable iFix releases only.
But now we have RQM 3.0 and I have tried but the updater ain't running on RQM 3.0. Do you have any updates on this?

Thank you