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

Problem occured to import excel into RQM

Hi,

I want to import test cases along with test scripts from Excel file to RQM, but my requirement is not getting catered due to wrong config file, as I have made one config file, which created both the test cases and test scripts but not able to associate those. I have attached the excel test case which would be uploaded and the config file, which I used.

Please help me to upload the excel into RQM, minimal change of format is possible.

Regards,
Sumita

excel format is
Test Case name Summary (description) Test Case design Pre-condition Test Data Expected results Test-script-Name Step Number Step description Expected Result Review Comments

The sample config file is

/ This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data


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

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


// 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=I
testscript.steps.title=H
testscript.steps.name=H
testscript.steps.expectedResult=J

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

// test case defined with definite cell locations
testcase.dc:title=A2
testcase.dc:description=B2
testcase.XLSLink=testscript

E

0 votes



One answer

Permanent link
Note: This post is 4+ years old.

Please upgrade to the latest version of RQM (see https://jazz.net/downloads/rational-quality-manager/) and review the product documentation (see https://jazz.net/help-dev/clm/topic/com.ibm.help.common.jazz.calm.doc/com.ibm.help.common.jazz.calm.doc_eclipse-gentopic1.html) and jazz.net resources (see https://jazz.net/help).  If your issue persists, please ask a new question (https://jazz.net/forum/questions/ask), open a defect (see https://jazz.net/mystuff/#tab=workitems), or open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639).

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.

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: Aug 18 '10, 8:40 a.m.

Question was seen: 6,515 times

Last updated: May 27 '15, 7:24 a.m.

Confirmation Cancel Confirm