It's all about the answers!

Ask a question

Linking Test Plan to Test Case Execution Result


Mark Prybylski (131) | asked Mar 28 '21, 1:22 p.m.

It seems like such a common requirement but I have burned up hours trying to find the right combination of RQMexcelImporter configuration statements to create a Test Case Execution Record and have it linked to a Test Plan.  I can link it to a Test Case and I have Test Plan statements in the configuration file and the excel spreadsheet.  These are the config statements:

// Static test case definition
testcase.XLSStartRow=2
testcase.XLSDelimeter=\n
testcase.XLSArtifactID=A
testcase.dc:title=B
testcase.dc:description=E
testcase.priority=C


//Config for Testplan
testplan.XLSStartRow=2
testplan.XLSDelimeter=\n
// testplan.dc:title=testcase.dc:title
testplan.dc:title=I
testplan.XLSArtifactID=Link(G)
testplan.testscript=Link(D)

//Config for Executionworkitem with link to testcase
executionworkitem.XLSStartRow=2
executionworkitem.XLSDelimeter=\n
// executionworkitem.XLSArtifact=A
// executionworkitem.testplan=G
executionworkitem.testcase=Link(A)
// executionworkitem.testscript=D
executionworkitem.dc:title=B
executionworkitem.dc:description=E
executionworkitem.alm:owner="MJFSB"

//Config for Executionresult
executionresult.XLSStartRow=2
executionresult.XLSDelimeter=\n
executionresult.dc:title=executionworkitem.dc:title
executionresult.XLSArtifact=executionworkitem.XLSArtifact
executionresult.er:details=H
executionresult.jzalm:state=H
executionresult.alm:owner="MJFSB"
executionresult.testcase=Link(A)
executionresult.testscript=Link(D)
executionresult.executionworkitem=Link(G)
executionresult.testplan=G

Here's a sample of the spreadsheet data:

It's probably something simple...but after dozens of attempts, I'm drawing blanks...

Thanks,

Mark

3 answers



permanent link
Mehul Patel (9545) | answered Mar 30 '21, 1:16 a.m.
FORUM MODERATOR

Mark,


Given syntax mostly depends on how is your data organized in the spreadsheet. First help could be the available sample 'Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne' from the sample folder, you can alter your data and cfg file as per your need. 

Couple of points -
- Looks like you are having script less test execution? test scripts are not defined but referenced in above cfg syntax.
- Which version of add-in you are using?
- Check for the log file (%appdata%\Mso2Rqm), it might have more insight of what's happening (refer logging for more detail, v701 onward it allows to configure this logging)

Regards,
Mehul


permanent link
Mark Prybylski (131) | answered Mar 30 '21, 9:18 a.m.

Thanks for getting back to me.  I've been using the AllInOne'  sample attempting to find the right sequence of config statements.  Literally, hundreds of variations.  None have worked, so far.

 


permanent link
Mark Prybylski (131) | answered Mar 30 '21, 11:37 a.m.

We have Version 6.0.6.1

Your answer


Register or to post your answer.