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:- |
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
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:
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> ------------------------------------------------------------------------------------------------------------------------------------------------------------------ Naveen Tyagi selected this answer as the correct answer
Comments Thanks Reshma!!! more than half of my problem is solved and now i am able to create sections, and import data to pre existing section but i am not able to do same for the custom section already in RQM since i have no idea about RQMURLUtility. I am only aware of RQMExcelImporter, i know there is something RQMURLUtility for Export related stuff but that would be my next task and this stage i have no idea.
You can even use POSTER utility (an add-on of Firefox) to do a GET of the artifact. Just add header ("user-agent", abc)
I have only Chrome and IE on machine. In order to Install something i need admin permission that will also take some time.
Chrome also has POSTER add-on. https://chrome.google.com/extensions/detail/cdjfedloinmbppobahmonnjigpmlajcd Thanks!! let me install it and check. |
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.