Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Linking Test Plan to Test Case Execution Result

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

0 votes



3 answers

Permanent link

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

0 votes


Permanent link

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.

 

0 votes


Permanent link

We have Version 6.0.6.1

0 votes

Your answer

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

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,013

Question asked: Mar 28 '21, 1:22 p.m.

Question was seen: 1,185 times

Last updated: Mar 30 '21, 11:37 a.m.

Confirmation Cancel Confirm