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

Questions
Tags
Users
Badges
Adarsh Balachandran
(13●1●1) 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.

0 votes

2 answers
8,358 views
0 votes

Accepted answer

Permanent link
Don Yang
(7.7k●21●114●139) 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

0 votes

Comments
Adarsh Balachandran
Jun 01 '15, 12:45 a.m.
 Thank you Don for your guidance!

Adarsh Balachandran
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
(24●1●17●34) 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

0 votes

Comments
Adarsh Balachandran
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
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
Jun 04 '15, 12:38 a.m.
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.

Ask a question
Guidelines
FAQ
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,145
× 64

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

Question was seen: 8,358 times

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

Confirmation Cancel Confirm