RQMExcelImporter & RQM Rest API
![]() I want to import test cases from EXCEL to RQM, I found some introduction on RQMExcelImporter, it support this function, but I don't know how to set the config file to meet our requirement. Or can I say, what's the property name for the below items in RQM Rest API? We need import the below items for the test cases: 1. TEST NAME 2. Test case design 3.requirement 4. Expected Result Below is the current config from internet, how can I modify it to meet our requirement? testcase.dc:title=testscript.dc:title testcase.dc:description=testscript.dc:description testcase.weight=D testcase.regressionTest=testscript.regressionTest // Categories are defined in a special way testcase.category term="Category".value=F testcase.category term="Function".value=H // Sections are defined differently, the first part within the quotes is the section tag, and the optional second part after the comma // defines the name of the section. Sections that already defined within RQM will use the display name they already have testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseAcceptanceCriteria","RQM-KEY-TC-ACCEPT-CRITERIA-TITLE")=E testcase.XLSStartRow=4 testcase.XLSDelimeter=\n |
Accepted answer
![]()
Hi Lei Ruan,
Please let me know if this is what you are looking for:
![]() ![]() Lei Ruan selected this answer as the correct answer
|
2 other answers
![]() Hello Lei, From the above config, it seems that you are looking to import some test cases into RQM using the RQM Excel Importer. I'm sure that you have seen this document but I wanted to place it for reference as well: https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter I'm not sure if you know, but when installing the Excel Importer, we do provide some sample files that can be imported into RQM. By default, the RQMExcelImporter is installed in: C:\Program Files\IBM\RQMExcelImporter In that folder you will also see if Samples folder that will contain sample .cfg and .xls that you can use as examples to import test cases, plans, scripts in from Excel to RQM. I hope this helps. Comments Thank you Ted, it looks Expect results in Test case section is not supported when importing, from the below info, I am confused that expected result is the basic info for a test case, why it is not supported? Is there any method to implement it? Supported Attributes and Configuration Syntax Test Case
How did you get the impression that Expected Result is not supported? Check out the samples "Scripts that create testcases" and "Test Cases made from scripts"
Hi, Lei Ruan
1
Not quite right. Also test cases have an expected result section!
1
Not sure why comment is not updated to my email.
|
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.
Comments
Thank you, it works!