It's all about the answers!

Ask a question

RQMExcelImportUtility - Import and Link test artifacts in one go


Ricky Jay (281126) | asked Jun 20 '16, 11:54 a.m.
 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



permanent link
Nigel Powell (11) | answered Jun 20 '16, 12:05 p.m.
 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"

permanent link
Ricky Jay (281126) | answered Jun 20 '16, 1:53 p.m.
  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


Register or 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.