It's all about the answers!

Ask a question

Export from Excel Test Case with more related Scripts


Antonio Silvestro (144) | asked Apr 26 '13, 2:58 a.m.
retagged Apr 26 '13, 11:51 a.m. by Laura W. Hinson (16126)
 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

16 answers



permanent link
Vidya Malkarnekar (1.0k15) | answered Apr 29 '13, 11:37 a.m.
JAZZ DEVELOPER
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



permanent link
Ara Masrof (3.2k15) | answered Apr 29 '13, 8:51 a.m.
JAZZ DEVELOPER
 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

permanent link
Antonio Silvestro (144) | answered Apr 29 '13, 10:45 a.m.
 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.

permanent link
Antonio Silvestro (144) | answered Apr 30 '13, 4:38 a.m.
 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. 

permanent link
Vidya Malkarnekar (1.0k15) | answered Apr 30 '13, 8:11 a.m.
JAZZ DEVELOPER
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" ?

permanent link
Antonio Silvestro (144) | answered Apr 30 '13, 9:50 a.m.
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 :(

permanent link
Ara Masrof (3.2k15) | answered Apr 30 '13, 9:53 a.m.
JAZZ DEVELOPER
 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? 

permanent link
Antonio Silvestro (144) | answered Apr 30 '13, 11:45 a.m.
 https://qclm.risorse.enel:9443/qm/

permanent link
Ara Masrof (3.2k15) | answered Apr 30 '13, 12:01 p.m.
JAZZ DEVELOPER
edited Apr 30 '13, 12:01 p.m.
 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.

permanent link
Antonio Silvestro (144) | answered May 02 '13, 4:46 a.m.
 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?

Your answer


Register or to post your answer.