It's all about the answers!

Ask a question

RQMExcelWordImporter: Importing Multiple Test Suites


Andrew Trobec (49713144139) | asked Dec 16 '11, 5:58 a.m.
Hello,

I am getting an error when trying to import multiple test suites. The cfg file is very simple:

testsuite.XLSStartRow=2

testsuite.dc:title=B
testsuite.dc:description=C


Within my Excel sheet I have one row per suite, so I expect the program to iterate through the rows and create a Test Suite for each one.

When specifying a single row, it works, but only adds that one row:

testsuite.XLSStartRow=2

testsuite.dc:title=B2
testsuite.dc:description=C2


so there is nothing wrong with the data.

I have tried adding blank rows between the rows in Excel but I still get an error:

testsuite.XLSStartRow=2

testsuite.XLSDelimeter=\n
testsuite.dc:title=B2
testsuite.dc:description=C2


I am using RQMExcelWordImporter version 3.0.1.1.

How do I successfully import multiple Test Suites?

Thank you in advance.

Best regards,

Andrew

4 answers



permanent link
Hao Wan (1.5k35) | answered Feb 08 '12, 9:32 p.m.
JAZZ DEVELOPER
Hi Andrew, have you tried to put the testsuites in different excel sheets?

you can use the config file like,
testsuite.XLSStartRow=2

testsuite.dc:title=B2
testsuite.dc:description=C2


and put the testsuite titles in B2 cell of excel sheets, and descriptions in C2.

permanent link
Pierre-Luc Turcotte (4835) | answered Mar 07 '12, 8:34 a.m.
Hi ,

I have try your code that you posted, but I still only able to import the first one.

any idea why...???


thank you

permanent link
Hao Wan (1.5k35) | answered Mar 07 '12, 9:48 a.m.
JAZZ DEVELOPER
@plturcotte,

make sure you put the test suites in the different excel sheet, one sheet should contains only one testsuite in Excel Impoter.

Hi ,

I have try your code that you posted, but I still only able to import the first one.

any idea why...???


thank you

permanent link
Pierre-Luc Turcotte (4835) | answered Mar 07 '12, 11:14 a.m.
@wanhaobj

Thanks a lot for the info.

next problem now...

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.