Is there any way to import test cases in custom excel template to RQM
We are having test cases and related test scripts in several excel files. Could you please advice us as to how can we import them into RQM.
|
Accepted answer
You will need RQMExcelImporter to import the test case and test script into RQM. Please check with :
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter first to understand how it works. Once you installed ExcelImporter, there is Samples under installation directory and you can refer to them as a practice and "borrow" cfg files from there. Adarsh Balachandran selected this answer as the correct answer
Comments
Adarsh Balachandran
commented Jun 01 '15, 12:45 a.m.
Thank you Don for your guidance!
Adarsh Balachandran
commented Jun 03 '15, 1:39 a.m.
Hi Don,
We tried exporting one of our test scripts to an xml file. But we are not sure about which .cfg file need to be selected for mapping.
Could you please tell us how to create a new mapping (.cfg) file based on two column test script template with the following headers: 1. Description, 2. Expected Results
Regards,
Adarsh
|
One other answer
Hi Adasrh,
Please use below syntax for test case expected results and description testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXP-RESULTS-TITLE")=F testscript.dc:description=G Comments
Adarsh Balachandran
commented Jun 03 '15, 2:22 a.m.
Thank you Don! As per your instructions we added the syntax to one of the existing config files. It is taking time and also when we imported the generated xml into RQM, it didnt come as it is in the excel and also not all steps in the excel are exported.
Don Yang
commented Jun 03 '15, 7:43 a.m.
In ExcelImporter installed directory\Samples, you can check with some samples such as: Test Cases made from scripts.cfg/Test Cases made from scripts.xls
Adarsh Balachandran
commented Jun 04 '15, 12:38 a.m.
Thank you so much Don! |
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.