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

RQM : Importing Test Scripts using Excel Importer

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 -



0 votes



One answer

Permanent link
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 :)

0 votes

Comments

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

Question asked: May 16 '14, 5:30 a.m.

Question was seen: 7,128 times

Last updated: May 25 '14, 9:49 p.m.

Confirmation Cancel Confirm