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



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