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
See the following samples (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration):

Scripts that create testcases with comments.cfg
Scripts that create testcases.cfg

0 votes


Permanent link
See the following samples (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration):

Scripts that create testcases with comments.cfg
Scripts that create testcases.cfg


Thanks

0 votes


Permanent link
See the following samples (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration):

Scripts that create testcases with comments.cfg
Scripts that create testcases.cfg


----------------------------------------------------------------------------
Is it possible to have a If/Then clause in the config file.

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.description=E
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=F

I need to have some steps in the Test Script with step type tag as "reporting" How should the code be changed??

0 votes


Permanent link
I have been able to successfully import Testscript from Excel to RQM, but I Need to have some steps as 'execution' & and some steps as reporting. The following code in Config file creates all steps as Execution steps

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.description=E
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=F

Is it possible to have a "IF"/"Then" clause statement to accomodate 'Reporting' steps too.
How should I write the code in the Config file?

0 votes


Permanent link
Unfortunately, there is no conditional keyword. You may be able to use the Find*() or property() keywords (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Examples).

0 votes


Permanent link
Did you follow https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Troubleshooting to determine the problem?

Are you using the RQM Excel/Word Importer to import the test resources or importing raw XML using the RQM UI?

0 votes


Permanent link
Correct, you cannot import test scripts in the RQM UI. You must use https://jazz.net/wiki/bin/view/Main/RqmApi or https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter.

Follow the Tip in https://jazz.net/wiki/bin/view/Main/RqmApi#Create_Tip to see how to link a test case to a test script,

0 votes


Permanent link
Hi everybody,

Everything is fine with excel to repo import utility. I am able to import some basic information of test case/script/plans. Now I am trying to import some advanced properties of them like Pre-Conditions,etc...

I am using
testcase.section("com.ibm.rqm.planning.editor.section.testCaseExpectedResults", "Excepted Result")=G

But I got an error message which says Test Case cannot be created. There is nothing more.Does anyone have any solution for this?

0 votes


Permanent link
Hi iam new to Qulaity Maanger.We need to Imoprt all the test scripts from Excel to RQM.
I saw comments about Excel-Addin is this available in 2.0.1 iFix 4
Please let me know the steps to import

0 votes


Permanent link
Hi iam new to Qulaity Maanger.We need to Imoprt all the test scripts from Excel to RQM.
I saw comments about Excel-Addin is this available in 2.0.1 iFix 4
Please let me know the steps to import


https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter this can help you.

0 votes

1–15 items
page 1of 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: 21,282 times

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

Confirmation Cancel Confirm