It's all about the answers!

Ask a question

How to assign 'Owner' of RQM Test Case Execution Record using RQMexcelImporter utility


Mark Prybylski (131) | asked Sep 24 '20, 4:41 p.m.

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


permanent link
Mehul Patel (9545) | answered Sep 25 '20, 2:21 a.m.
FORUM MODERATOR

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



permanent link
Mark Prybylski (131) | answered Sep 25 '20, 11:05 a.m.

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

Your answer


Register or to post your answer.