It's all about the answers!

Ask a question

RQMExcelImporter: updating Test Results to existing Test execution record


Richard Good (872159) | asked Nov 01 '17, 11:03 a.m.

Using RQM 6.0.2 and RQMExcelImporter 6.0.2

Trying the

Trying to update an existing test execution record, the samples work ok

Created stuff for Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne sample, but my use case will be to update the same Test Execution Record multiple times not the whole thing, so I wish to simply add execution records, simple you think, but the system has been non functional with no useful error messages all morning, my config file is as follows: -

Any ideas welcome, can't seem to attach excel file to go with it, but it is a simple cut down of the sample. What am I doing wrong? Thanks for any help

Richard

executionresult.XLSWorksheetID="Test"
executionresult.XLSStartRow=15
executionresult.XLSDelimeter=\n

executionresult.XLSArtifactID="TC001_TS034"
executionresult.dc:title="TC001_TS034"
executionresult.er:details=E
executionresult.jzalm:state=J
executionresult.er:starttime=K
executionresult.er:endtime=L
executionresult.er:stepResults.steptitle=D
executionresult.er:stepResults.stepname=D
executionresult.er:stepResults.er:steptype=H
executionresult.er:stepResults.er:result=I
executionresult.er:stepResults.er:description=E
executionresult.er:stepResults.er:expectedResult=F
executionresult.er:stepResults.er:actualResult=F

executionresult.testcase=LinkExisting("urn:com.ibm.rqm:testcase:20")
executionresult.testscript=LinkExisting("urn:com.ibm.rqm:testscript:19")
executionresult.executionworkitem=LinkExisting("urn:com.ibm.rqm:executionworkitem:11")

One answer



permanent link
Richard Good (872159) | answered Nov 01 '17, 11:41 a.m.

Think I was nearly there, just some duff information on the wiki (or version specific stuff anyway) and pointers to other wikis making life easy for ibm wiki writers, but a pain for the poor old user. You  would think someone else would have had this problem before. Hopefully this will help someone else.

Why are there no examples of adding results to existing artifacts and why are you given cryptic references to API wikis to find out the URNs for your internal ids. Include the most useful on the main wiki page, this utility is useful, but is hamstrung by less than brilliant examples and weird documentation

executionresult.XLSWorksheetID="Test"
executionresult.XLSStartRow=15
executionresult.XLSDelimeter=\n

executionresult.XLSArtifactID="TC001_TS034"

executionresult.testcase=Link("urn:com.ibm.rqm:testcase:20")
executionresult.testscript=Link("urn:com.ibm.rqm:testscript:19")
executionresult.executionworkitem=Link("urn:com.ibm.rqm:executionworkitem:11") 

executionresult.dc:title="TC001_TS034"
executionresult.er:details=E
executionresult.jzalm:state=J
executionresult.er:starttime=K
executionresult.er:endtime=L
executionresult.er:stepResults.steptitle=D
executionresult.er:stepResults.stepname=D
executionresult.er:stepResults.er:steptype=H
executionresult.er:stepResults.er:result=I
executionresult.er:stepResults.er:description=E
executionresult.er:stepResults.er:expectedResult=F
executionresult.er:stepResults.er:actualResult=F        

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.