Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.

0 votes


Accepted answer

Permanent link
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

0 votes

Comments

 Thank you Don for your guidance!

  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
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

0 votes

Comments

 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.

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.

Thank you so much Don!  

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,020
× 64

Question asked: May 30 '15, 8:34 a.m.

Question was seen: 5,486 times

Last updated: Jun 04 '15, 12:38 a.m.

Confirmation Cancel Confirm