It's all about the answers!

Ask a question

RQM Excel Importer - Link Test case to Test script

rachel bruk (176) | asked 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

8 answers

permanent link
Donald Nong (14.4k314) | answered 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.

rachel bruk commented 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 commented 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 (3033271) | answered 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

rachel bruk commented 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.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
//Link to test script:

rachel bruk commented Mar 15 '17, 3:36 a.m. | edited 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 commented Mar 15 '17, 4:21 a.m.




might help :-)

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

Just see that you also used : instead of .

new try:


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


Is your import  now working?

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

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

Don Yang commented 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) | answered Mar 20 '17, 5:04 a.m.

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

john worne
work at

permanent link
James Richards (11) | answered 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!

permanent link
Scott Nelson (11) | answered 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

permanent link
jacky worne (111) | answered Apr 26 '18, 5:03 a.m.
edited Apr 26 '18, 5:05 a.m.

 hlo every one

permanent link
jacky worne (111) | answered Apr 26 '18, 5:05 a.m.

 hlo every one

permanent link
Jack Ponting (11) | answered Jan 01, 12:40 a.m.

 Thanks for sharing meaningful content on a RQM excel importer. -

Your answer

Register or to post your answer.