It's all about the answers!

Ask a question

RQM : Importing Test Scripts using Excel Importer


David Beange (111364101) | asked May 16 '14, 5:30 a.m.
In RQM V4.0.2 our users are trying to import but getting ERROR 500 when they try and import more than 1 record.

I am sure the issue is with the cfg file but i cannot figure it out. Does anyone have any suggestions?

CFG -
// This configuration file creates a test case with each test script and links them.
//Also there is a singular testsuite created that has all of the testcases in it.


// Start looking for scripts after row 2
testscript.XLSStartRow=5

// use the data in the first row of a found script's column B
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=C

// 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

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
   
// we want to use the data we got for each test script to create a test case
testcase.ID=testscript.XLSArtifactID

// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description

testsuite.dc:title=B1
testsuite.dc:description=B2
testsuite.XLSLink=testcase


Spreadsheet -



One answer



permanent link
Diao Xian Feng (361) | answered May 22 '14, 11:36 p.m.
Hi David,

Can you please send your excel file and .cfg file to my email (dxfdiao@cn.ibm.com)? then I will try to look at it.
Also sometimes you can check the log files, in the log file, some useful messages will be here, in my machine, log files located at "C:\Users\IBM_ADMIN\AppData\Roaming\Mso2Rqm"

Thanks :)

Comments
Diao Xian Feng commented May 25 '14, 9:49 p.m.

Hi David,
I checked your files, and the root cause is:
your version RQM importer creates "executionworkitem" before "testcase".

The created sequence should be: test case first, then executionworkitem.

I tested on RQM 5.0 importer, everything is ok, so maybe you can check RQM 5.0 importer.

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.