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,
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"?>
<executionworkitem xmlns="http://jazz.net/xmlns/alm/qm/v0.1/"
xmlns:jzalm="http://jazz.net/xmlns/alm/v0.1/"
xmlns:alm="http://jazz.net/xmlns/alm/v0.1/"
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:myns="http://mydomain.net/some/custom/namespace/v0.1/"
xmlns:ts="http://jazz.net/xmlns/alm/qm/v0.1/testscript/v0.1/"
xmlns:er="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1"
xmlns:vg="http://schema.ibm.com/vega/2008/"
xmlns:rs="http://jazz.net/xmlns/alm/qm/remotescript/v0.1/" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:x="urn:schemas-microsoft-com:office:excel">
<dc:title>C2_ITPE_E2E_BS036A Entity Balance IDRS_EXTRACT</dc:title>
<alm:owner>Prybylski Mark [Contractor]</alm:owner>
<dc:description>E_IMF_ENTITY_BALANCE:IDRS_EXTRACT</dc:description>
<testplan href="../testplan/18397"/>
<testcase href="../testcase/964491"/>
</executionworkitem>
the config statement that produced the xml....
executionworkitem.alm:owner=H
abbreviated list of contents in column H content from the excel spreadsheet:
Tested By |
Thanks, again for your reply.
Mark Prybylski