It's all about the answers!

Ask a question

Import Test Script from Excel to RQM using RQM 2.0.1.1 iFix3


Ann NC (161) | asked Aug 31 '11, 4:35 p.m.
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

13 answers



permanent link
Paul Slauenwhite (8.4k12) | answered Sep 07 '11, 9:50 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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

permanent link
Ann NC (161) | answered Sep 12 '11, 4:49 p.m.
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

permanent link
Ann NC (161) | answered Sep 13 '11, 1:55 p.m.
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??

permanent link
Ann NC (161) | answered Sep 13 '11, 2:04 p.m.
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?

permanent link
Paul Slauenwhite (8.4k12) | answered Sep 14 '11, 9:37 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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).

permanent link
Paul Slauenwhite (8.4k12) | answered Sep 22 '11, 2:07 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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?

permanent link
Paul Slauenwhite (8.4k12) | answered Sep 23 '11, 8:39 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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,

permanent link
Canberk Akduygu (99237371) | answered Oct 05 '11, 6:40 a.m.
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?

permanent link
Sudeeptika Gali (16) | answered Oct 07 '11, 4:32 p.m.
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

permanent link
Canberk Akduygu (99237371) | answered Oct 10 '11, 3:39 a.m.
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.

Your answer


Register or 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.