RQMExcelImportUtility - Import and Link test artifacts in one go
Hi,
We have a excel file contains test plan, test cases and test scripts each in different sheets of the same excel file.
I am able to import all the artifacts but facing issue while linking them through CFG. What happens is, when i use to link the artifacts by self reference testscript.steps.expectedResult=D it gets the test script sheet columns instead of getting column details from Test case sheet.
How can i define in cfg to get the details from different sheets?
|
2 answers
You need to include a XLSWorksheetID value in your .cfg files:
I have three examples below:
remotescript.XLSWorksheetID="Data Sheet"
testcase.XLSWorksheetID="TestCase"
testscript.XLSWorksheetID="TestScriipt"
|
|
Thanks Nigel, yes i used the same syntax ... but still it picks the values from test script sheet for test case sections (e.g test case condition , expected result).
Also, it doesn't link the test case to test plan.
This is how my .cfg file looks like,
testplan.XLSWorksheetID="TestPlan"
testplan.XLSStartRow=3
testplan.dc:title=A
testplan.testcase=Link(B)
testcase.XLSWorksheetID="TestCase"
testcase.XLSStartRow=3
testcase.XLSArtifactID=B
testcase.dc:title=testscript.dc:title
testcase.dc:description=C
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseConditions","Test Case Conditions")=G
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResult","Test Case Expected Result")=H
testscript.XLSWorksheetID="TestScripts"
testscript.XLSStartRow=3
testscript.dc:title=B
testscript.steps.type="execution"
testscript.steps.description=C
testscript.steps.expectedResult=D
testscript.XLSDelimeter=\n
|
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.