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

Export from Excel Test Case with more related Scripts

 Hello,

I need to export from excel to RQM an excel containing more scripts related to the same test case, creating the test case in the same file excel.

How should I configure the .cfg file in order to relate scripts to the test case?

Thank you,
Antonio Silvestro

0 votes



16 answers

Permanent link
You should be able to use the sample example ''Test Cases made from scripts" to create multiple scripts for one test case. You have to separate test scripts with a blank row ( testscript.XLSDelimeter=\n).

The comment in cfg file has this:
// this configuration file will create a single test case from the defined cells and link to all
// test scripts in the same worksheet


1 vote


Permanent link
 Antonio,
Have you had a chance to take a look at the sample xls/cfg files? If not, take a look at this one in particular:

Test Cases made from scripts.xls
Test Cases made from scripts.cfg

You can you this as a basis for the specif data you want to import

Ara

0 votes


Permanent link
 Hi,

I saw that sample but I need to load more scripts related to the same test case.

In 'Test Cases made from scripts.xls' sample, it's described how I could load one script for each test case.

0 votes


Permanent link
 Hi 

I tried using this configuration

//Summary
testscript.XLSStartRow=7
testscript.dc:title=A
testscript.dc:name=A
testscript.dc:description=B

//Test script fixed values
testscript.alm:state = "com.ibm.rqm.planning.common.approved"
testscript.jzalm:owner="SILVESTRO ANTONIO"
testscript.steps.type="execution"

//Step details
testscript.steps.title=C
testscript.steps.name=C
testscript.steps.description=D
testscript.steps.expectedResult=E

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n

// test case defined with  definite cell locations
testcase.XLSLink=testscript
testcase.dc:title=A3
testcase.dc:description=B3
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition", "RQM-KEY-TC-PRE-COND-TITLE")=C3
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition", "RQM-KEY-TC-POST-COND-TITLE")=D3
testcase.category term="Component".value=E3
testcase.category term="Version".value=F3

Tool creates  xml files, but loading them (one for time), system doesn't create automatically the link between test case and test scripts.

I tried to load first the xml related to test scritps and then the xml related to test case, and contrariwise, but with the same result. 

0 votes


Permanent link
What version of tool are you using? I tried the sample that came with  the 4.0 version of utility and it worked for me ( created the links between test cases & test scripts).  
Also, are you using "export to  file"?  Have you tried "Export to Repository" ?

0 votes


Permanent link
I'm using version 4.0.

I think the problem is because I'm exporting to file instead of to repository.

My "Export to repository" option doesn't work because it seems that it can't connect to rtc server :(

0 votes


Permanent link
 Antonio,
My "Export to repository" option doesn't work because it seems that it can't connect to rtc server :(
What URL are you specifying to connect to RQM? 

0 votes


Permanent link
 https://qclm.risorse.enel:9443/qm/

0 votes


Permanent link
 The URL looks fine assuming your RQM user is set up with the 3.x/4.x context root (i.e. QM not JAZZ)
When you say "it cant connect"; what error message is displayed? Are you able to view the list of project areas from the drop down list? Does the user you are specifying have the appropriate permissions to access the server?
Take a look at the Mso2Rqm_Debug.log; it may provide additional information on the nature of the error.

0 votes


Permanent link
 I'm using v4.0

The error is "Invalid Server, username or password!".

(Username and password are obviously correct)

Where can I find Mso2Rqm_Debug.log file?

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
× 12,019

Question asked: Apr 26 '13, 2:58 a.m.

Question was seen: 12,068 times

Last updated: Sep 17 '13, 8:54 a.m.

Related questions
Confirmation Cancel Confirm