RQM Excel Importer 5.0 configuration file
I am able to import samples in RQM but in order to Import my Excel file of test cases i am not able to mapped properly due to some mistakes in .cfg file. Some of the values are either being ignored or getting mapped at wrong place/sections.
I have one 'Test case Id' column in excel file that i want to became name of my test case and there are some other sections in Excel file and also same sections in Test template already created in RQM. lets name A,B,C. I want value of these custom section automatically mapped in the same sections in RQM and when i clicked on perticular section, value must be there in "Rich text area". what is the correct line i need to write in .cfg file. your help would greatly appreciated:-
I have one 'Test case Id' column in excel file that i want to became name of my test case and there are some other sections in Excel file and also same sections in Test template already created in RQM. lets name A,B,C. I want value of these custom section automatically mapped in the same sections in RQM and when i clicked on perticular section, value must be there in "Rich text area". what is the correct line i need to write in .cfg file. your help would greatly appreciated:-
Accepted answer
Hi Naveen,
In order to set the name/title of the TestCase use the attribute testcase.dc:title. So lets say the Test case Id column is A then use below line
testcase.dc:title = A
Refer https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Supported_Attributes_and_Configu for more details
Just to add, specify the start row after which the artifact data starts. Use attribute
Regarding Custom sections you need to first figure out the Section Display Name and Section Id.
For predefined sections of RQM refer below link https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#SectionsIds
Syntax for predefined sections is as below
To define a new custom section in RQM, simply replace the first parameter with a valid name, and the second with a display name:
2) Goto the testcase feed url in browser "https://<host>:<port>/<contextRoot>/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<ProjectAreaAlias>/testcase"
2) Right click on the TestCase selected in step 1 which has data in the custom section, select Copy Link Location.
3) Now using RQMURLUtility do a GET to this copied url link or use POSTER utility of Firefox browser
4) In response you should get an xml similar to below. Locate the element/tag in the xml document with extensionDisplayName value = <Custom Section Name>. Here the attribute named "extensionDisplayName" is the ExtensionDisplayName value and corresponding tag name is the section ID (Here for eg dynamicSection_1421923675049 is the ID value for Scenario section). Use them in the cfg file with format testcase.Section("myns:<section id>", "<extensionDisplayName>")=C
------------------------------------------------------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<ns2:testcase xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" xmlns:ns1="http://schema.ibm.com/vega/2008/"
<ns3:title>tcase1232</ns3:title>
<ns3:description/>
........
<dynamicSection_1421923675049 xmlns="http://jazz.net/xmlns/alm/qm/v0.1/" extensionDisplayName="Scenario">
<div xmlns="http://www.w3.org/1999/xhtml">scenario</div>
</dynamicSection_1421923675049>
<dynamicSection_1421923690528 xmlns="http://jazz.net/xmlns/alm/qm/v0.1/" extensionDisplayName="Test-Condition">
<div xmlns="http://www.w3.org/1999/xhtml">test condition</div>
</dynamicSection_1421923690528>
</ns2:testcase>
------------------------------------------------------------------------------------------------------------------------------------------------------------------
In order to set the name/title of the TestCase use the attribute testcase.dc:title. So lets say the Test case Id column is A then use below line
testcase.dc:title = A
Refer https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Supported_Attributes_and_Configu for more details
Just to add, specify the start row after which the artifact data starts. Use attribute
XLSStartRow
(It defines what row the artifact data starts after)
Regarding Custom sections you need to first figure out the Section Display Name and Section Id.
For predefined sections of RQM refer below link https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#SectionsIds
Syntax for predefined sections is as below
testcase.Section("<sectionID>", "<extentionDisplayName>")=C
To define a new custom section in RQM, simply replace the first parameter with a valid name, and the second with a display name:
testcase.Section("myns:mysection","my custom section")=C
In case if the custom section is already present in RQM then follow below steps to get sectionID and extensionDisplayName
:
2) Goto the testcase feed url in browser "https://<host>:<port>/<contextRoot>/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<ProjectAreaAlias>/testcase"
2) Right click on the TestCase selected in step 1 which has data in the custom section, select Copy Link Location.
3) Now using RQMURLUtility do a GET to this copied url link or use POSTER utility of Firefox browser
4) In response you should get an xml similar to below. Locate the element/tag in the xml document with extensionDisplayName value = <Custom Section Name>. Here the attribute named "extensionDisplayName" is the ExtensionDisplayName value and corresponding tag name is the section ID (Here for eg dynamicSection_1421923675049 is the ID value for Scenario section). Use them in the cfg file with format testcase.Section("myns:<section id>", "<extensionDisplayName>")=C
------------------------------------------------------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<ns2:testcase xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" xmlns:ns1="http://schema.ibm.com/vega/2008/"
<ns3:title>tcase1232</ns3:title>
<ns3:description/>
........
<dynamicSection_1421923675049 xmlns="http://jazz.net/xmlns/alm/qm/v0.1/" extensionDisplayName="Scenario">
<div xmlns="http://www.w3.org/1999/xhtml">scenario</div>
</dynamicSection_1421923675049>
<dynamicSection_1421923690528 xmlns="http://jazz.net/xmlns/alm/qm/v0.1/" extensionDisplayName="Test-Condition">
<div xmlns="http://www.w3.org/1999/xhtml">test condition</div>
</dynamicSection_1421923690528>
</ns2:testcase>
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Comments
