It's all about the answers!

Ask a question

Is there any way to import test cases in custom excel template to RQM


Adarsh Balachandran (1311) | asked May 30 '15, 8:34 a.m.
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


permanent link
Don Yang (7.0k2186117) | answered May 31 '15, 2:12 a.m.
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



permanent link
Don Max (22617) | answered Jun 03 '15, 1:50 a.m.
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. 

As we have no idea on how to edit the cfg file, request you to kindly provide us the whole code to be placed in the cfg file so that we can copy and replace the existing lines as a whole.


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
and focus on test script creation part in cfg file. You can try to export the sample first and see the results and try the same against your own excel by borrowing those related lines.


Adarsh Balachandran commented Jun 04 '15, 12:38 a.m.

Thank you so much Don!  

Your answer


Register or to post your answer.