Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RQMExcelImport- How to import multiple test plan where multiple test cases/scripts are assigned

Hi,

I need to import multiple test plans.
Each test plan has one or more test cases.
Each test case has one or more test scripts assigned (with 1..n) test steps.

The import itself is working in the sense that all test artifacts exist.
But each test plan has only one test case and each test case has also only one test script.

My test data is:
Tp_: Testplan   Tc_: Testcase    Tsp_: Testscript

import table with test data

and the configuration file I use:
testscript.XLSWorksheetID="rqm"
testscript.XLSArtifactID=FindColumn("Tsp_ID")

testscript.XLSStartRow=2
testscript.dc:title="Tsp_" & FindColumn("Tsp_ID") & "_" & FindColumn("Tsp_Title") 
testscript.dc:description= FindColumn("Tsp_Title") 

testscript.steps.type=FindColumn("Tsp_Step")
testscript.steps.description=FindColumn("Tsp_Description")
testscript.steps.expectedResult=FindColumn("Tsp_Expected_Result")
testscript.XLSDelimeter=\n


testcase.ID=testscript.XLSArtifactID
testcase.dc:title= "Tc_" & FindColumn("Tc_ID") & "_" &  FindColumn("Tc_Title")
testcase.dc:description=FindColumn("Tc_Title")
testcase.XLSDelimeter=\n

testplan.ID=testcase.XLSArtifactID
testplan.dc:title= "Tp_" & FindColumn("Tp_ID") & "_" & FindColumn("Tp_Title")
testplan.XLSArtifactID=FindColumn("Tp_ID")
testplan.XLSLink=testcase
testplan.XLSDelimeter=\n
	
	
	

Can anyone tell me what I have to change, so that all test cases and test script are linked as required?

   thanks, Jörg


PS: The result in RQM 6.0.2 looks like:



Here the test data as csv extract:
Tp_ID;Tp_Title;Tc_ID;Tc_Title;Tsp_ID;Tsp_Title;Tsp_Step;Tsp_Description;Tsp_Expected_Result
1;Tp_A;10;Tc_Aa;100;Tsp_Aa;1;Aa 1;ER Aa 1
;;;;;;;;
1;Tp_A;11;Tc_Ab;200;Tsp_Ab;1;Ab 1;ER Ab 1
;;;;;;;;
2;Tp_B;12;Tc_Ba;300;ZTsp_Ba;1;Ba 1;ER Ba 1
;;;;;;2;Ba 2;ER Ba 2
;;;;;;3;Ba 3;ER Ba 3
	

0 votes


Accepted answer

Permanent link
Jörg,

Used syntax XLSLink will link to all artifacts of the specified type within the worksheet. Given scenario of multiple test plan and multiple test case link from the same worksheet is not supported, you might want to create new RFE for this.

Regards,
Mehul
Jörg Werner selected this answer as the correct answer

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,024

Question asked: Dec 12 '16, 8:11 a.m.

Question was seen: 1,819 times

Last updated: Dec 21 '16, 2:19 a.m.

Confirmation Cancel Confirm