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

Import Test Script from Excel to RQM using RQM 2.0.1.1 iFix3

I have downloaded the Excel Add-in to import to RQM

I want to import a Test Script with 3 columns in Excel into RQM.
The columns are Step #, Step description and Expected Results

Can somebody please guide me how to do it? Thanks in advance

0 votes



13 answers

Permanent link
1)https://jazz.net/downloads/rational-quality-manager/releases/2.0?p=allDownloads``
2) Click All Downloads
3) Click on Microsoft Excel and Word to Rational Quality Manager Import Utility (Enter jazz user name and password)
4) And save on your local machine
5) Unzip the files
6) Run the msi file (click on the msi file)
7) Click next until you finish
8) Add-in is installed
8) Open the Excel2007
9) You can see the Add-Ins-->RQM

So having Add-in but need to know how can we use the add in to export

This might help

0 votes


Permanent link
steps to Export the test case with test script
1) While downloading the Excel Importer files are saved in c://Program files/IBM/Excel Importer/Samples/Scripts that create test cases.xls and Scripts that create test cases.cfg files
2) Copy those files and rename with your own name
3) Open the renamed Excel sheet. There is a format so u can update the Excel sheet according to your Description and Expected Result (Egg contains 4 to 5 scripts /Test cases in one Excel sheet. These are separated by new line. So deleting all the test cases and try with only one test case)
4) Open the .xls file that renamed (Scripts that create test cases.xls) the Excel sheet-->Add-In-->RQM-->Export to Repository
5) RQMServer Name: 'Give the Your RQM Server Name'
6) Leave Port as it is
7) Give Your Network User name and Password
8) Choose project you assigned to
9) In the choose mapping file add the cfg file that u renamed
10) Select Other Document option and click on add button and add the rename xls and click Export button
11) You will get Log file. Close the log file
12)Got to RQM and search for Test case that you can find test case with test script
Hope this might help

0 votes


Permanent link
I have successfully imported testcases, scripts to RQM using configuration file 'scripts that create testcases'. But I what to mention Project name, owner etc parameters while importing to RQM. Could anyone please help on this issue.

0 votes

1–15 items
page 2of 1 pagesof 2 pages

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

Question asked: Aug 31 '11, 4:35 p.m.

Question was seen: 22,399 times

Last updated: May 13 '14, 8:10 a.m.

Confirmation Cancel Confirm