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

RQM Excel Importer - Link Test case to Test script

Questions
Tags
Users
Badges
rachel bruk
(17●1●1●15) Mar 12 '17, 9:26 a.m.

I'm looking for an answer to:

"how to link test script to test case", I found many answers regarding the configuration file
but I'm looking for the declaration of test script in the Excel sheet: test script ID? test script name?
would be happy to get an example.

Thanks in advance

0 votes

8 answers
6,703 views
0 votes

8 answers

Permanent link
Donald Nong
(14.5k●6●14) Mar 12 '17, 6:56 p.m.

Have you checked the samples that come with the RQM Excel Importer intallation? There are quite a few of them, such as "Scripts that create testcases with comments", "Scripts that create testcases with TCER", "Scripts that create testcases", "Test Cases made from scripts with attachments" and etc.

0 votes

Comments
rachel bruk
Mar 14 '17, 6:34 a.m.

 Thanks Donald,
I checked already RQM samples - which Excel cell declare the test script? I didn't see any link or test script name/ID, could you send an example?

rachel bruk
Mar 14 '17, 6:56 a.m.

 I want to explain myself again:


I want to link test script that I already created and exist in RQM to the testcase - how to do it by Excel?

Thanks in advance

Permanent link
Jörg Werner
(303●38●81) Mar 14 '17, 12:54 p.m.

May be this example is what you need?

It creates a test suite and assigns multiple test cases.
Each test case is linked against an existing test script.



 Cheers, Jörg

0 votes

Comments
rachel bruk
Mar 15 '17, 3:22 a.m.

 The Excel file is exactly what I looked for, but unfortunately still didn't get results

and got the message:
"Error Found a value that reduced to "urm:com:ibm:rqm:testscript:"", but was expecting a value equivalent to a column, cell, or literal."
I'll show you the cfg. file and the Excel sheet:
//create test case
testcase.XLSStartRow=2
testcase.dc:title=A
testcase.alm:owner=B
testcase.priority=C
testcase.category term="Category".value=D
testcase.category term="Feature".value=E
testcase.category term="Package".value=F
testcase.category term="Supported Projects".value=G
testcase.category term="Supported Environments".value=H
testcase.dc:description=I
//Link to test script:
testcase.testscript=Link(urm:com:ibm:rqm:testscript:"&K)


rachel bruk
Mar 15 '17, 3:39 a.m.

in the Excel file, cell K include the test script ID per test case.

Thanks and hope to get a good solution!

Jörg Werner
Mar 15 '17, 4:21 a.m.

testcase.testscript=Link(urm:com:ibm:rqm:testscript:"&K)

-->

testcase.testscript=Link("urn:com:ibm:rqm:testscript:"&K)

might help :-)

Jörg Werner
Mar 16 '17, 5:26 a.m.

Just see that you also used : instead of .

new try:

testcase.testscript=Link("urn:com.ibm.rqm:testscript:"&K)

From my above example the line is (for better copy&paste):

testcase.testscript=Link("urn:com.ibm.rqm:testscript:"&C)


Is your import  now working?

rachel bruk
Mar 19 '17, 7:21 a.m.

 Yes, Thanks a lot - the import is working successfully!

Don Yang
Mar 19 '17, 8:53 p.m.

If Jörg's suggestions helped, please accept as an Answer so that the post cycle will be complete.

showing 5 of 6 show 1 more comments
Permanent link
jim monroe
(11) Mar 20 '17, 5:04 a.m.

hello
i'm new here.I don't have more idea about this topic.

regards
john worne
work at http://prodissertation.co.uk

0 votes

Permanent link
James Richards
(11) Mar 22 '17, 2:03 p.m.

Check the samples that come with the Installation & find an answer to those test scripts to test case. I am not sure if there are any notes related to the query, but let me know if you couldn't figure it - I will fix it for you, PM me for that.


I have written a research paper for one person who was looking for a help in such issue & wanted to buy research paper. I had few difficulties but I figured it out in the end!

0 votes

Permanent link
Scott Nelson
(11) Apr 27 '17, 3:53 a.m.

Check the samples that associate with the Installation & realize a solution to those check scripts to check case. I'm unsure if there are any notes associated with the question, however, let me know if you could not figure it - I'll fix it for you. UK Dissertation Service

0 votes

Permanent link
jacky worne
(11●1) edited
Apr 26 '18, 5:05 a.m.

 hlo every one

0 votes

Permanent link
jacky worne
(11●1) Apr 26 '18, 5:05 a.m.

 hlo every one

0 votes

Permanent link
Jack Ponting
(11) Jan 01 '22, 12:40 a.m.

 Thanks for sharing meaningful content on a RQM excel importer. - http://www.qualitydissertation.co.uk/


0 votes

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.

Ask a question
Guidelines
FAQ
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: Mar 12 '17, 9:26 a.m.

Question was seen: 6,703 times

Last updated: Jan 01 '22, 12:40 a.m.

Confirmation Cancel Confirm