How to assign 'Owner' of RQM Test Case Execution Record using RQMexcelImporter utility
Our testing team runs several hundred test cases daily through automated processes as the application is migrated from ALC to JAVA. I’ve had some success creating Test Case Execution Records in RQM using samples installed with the RQMexcelImporter utility on my laptop. I am not able to set the ‘owner’ of a Test Case Execution Record – not with executionworkitem.alm:owner= or executionworkitem.jzalm:owner= where the right side of the equal sign is a column of names. I’ve also tried setting the right side to a literal such as “Test Team”. Suggestions, anyone? Thank you, Mark Prybylski
These are my .cfg statements: // static test case definition testcase.XLSStartRow=2 testcase.XLSDelimeter=\n testcase.XLSArtifactID=Link(B) (column of hyperlinks to existing RQM test case id’s) (doesn’t work….) testcase.dc:title=C testcase.dc:description=F testcase.priority=D testcase.jzalm.owner=H testcase.alm.owner="Test Team"
// static configured testcase definition with link to testcase executionworkitem.XLSLink=testcase // executionworkitem.testcase=Link(B) executionworkitem.testplan=Link(E) (column of hyperlinks to existing RQM test plans – does work) executionworkitem.dc:title=testcase.dc:title executionworkitem.dc:description=F executionworkitem.jzalm:owner=H (column of names - doesn’t work….) // executionworkitem.jzalm:owner="Test Team" // executionworkitem.alm:owner="Test Team"
// result definition starting at line 2 in the spreadsheet executionresult.XLSWorksheetID="Test" executionresult.XLSStartRow=2 executionresult.dc:title=executionworkitem.dc:title executionresult.XLSArtifact=Link(B) executionresult.er:details=I executionresult.jzalm:state=I executionresult.jzalm:owner=H // executionresult.jzalm:owner="Test Team" // executionresult.alm:owner="Test Team" |
Accepted answer
Mark,
You need to specify the user id while using the below syntax, make sure the user id is existing and valid user id.
executionworkitem.alm:owner=CELL_NAME
If it is still not working, I would check the debug log to investigate further.
Regards,
Mehul
Mark Prybylski selected this answer as the correct answer
|
One other answer
Hi Mehul. Thanks for your response. I have tried that syntax using actual names of people exactly as they are in their RQM user profile. I've even copied their 'profile name' using the Quick Search feature in RQM. That produces a hyperlink to the user. Here are samples of the xml statements produced when I perform "Export to File". I included the config statement and an abbreviated image of column 'H' as referred to in the cfg file.
<?xml version="1.0" encoding="utf-8"?>
the config statement that produced the xml.... executionworkitem.alm:owner=H abbreviated list of contents in column H content from the excel spreadsheet:
Thanks, again for your reply. Mark Prybylski |
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.