hi,

I have one excel sheet containing sheet1 and sheet2 and I want to import these sheets data through RQM. Is it possible?

I have one cfg file to import... but this have import only one sheets data.

Manoj,

I assume that you are having an excel sheet with two worksheets ( 2 tabs).

Few things to be remember here are

> If you are trying to import the excel (.xls) file verify that both your worksheet are in the same format. it should look the same.

So after mapping to the correct .cfg file you will be able to upload the file into RQM at one shot.

Please try this out and let us know if this helps.

Hi @lmanoj1,
in your configuration file you have specify the worksheet
testscript.XLSWorksheetID="DetailedTestCases"
that means you only want to create testscript from this worksheet,
and you used self reference to do the link between testcase and testscript.
so I think testcase and testscript will only create from worksheet "DetailedTestCases" .

and by the way, are you using Excel Importer 3.0
as I saw you use testsuite.testcase=testcases which is no longer supported from Excel Importer 4.0

hi,

I have one excel sheet containing sheet1 and sheet2 and I want to import these sheets data through RQM. Is it possible?

I have one cfg file to import... but this have import only one sheets data.

Manoj,

I assume that you are having an excel sheet with two worksheets ( 2 tabs).

Few things to be remember here are

> If you are trying to import the excel (.xls) file verify that both your worksheet are in the same format. it should look the same.

So after mapping to the correct .cfg file you will be able to upload the file into RQM at one shot.

Please try this out and let us know if this helps.



Hi Anoop,

In one tab i have to Import only four values and from another tab i have to import all testcases.
Please see my cfg file which i have tried...


testsuite.dc:title=Table("Requisite").B2
testsuite.dc:description=Table("Requisite").B3
testsuite.testcase=testcases
testsuite.category term="Author".value=C28
testsuite.category term="Release".value=C7

testcase.dc:description=testscript.dc:title
testcase.dc:title=testscript.dc:description
testcase.category term="Type".value=this.C
testcase.category term="Complexity".value=this.H

testscript.XLSStartRow=2
testscript.XLSWorksheetID="DetailedTestCases"
testscript.dc:title=A
testscript.dc:description=A
testscript.category term="Type".value=C
testscript.category term="Complexity".value=H
testscript.category term="Traceability".value=I
testscript.steps.type="execution"
testscript.steps.description=D&". Input: "&E
testscript.steps.expectedResult=F
testscript.steps.property name="comment"=G
testscript.XLSDelimeter=\n

Please have a look on these statements and let me know your suggestions.....

I have to import two tabs data.