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

RQMExcelWordImporter: Importing Multiple Test Suites

Questions
Tags
Users
Badges
Andrew Trobec
(497●13●144●139) 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

0 votes

4 answers
5,196 views
0 votes

4 answers

Permanent link
Hao Wan
JAZZ DEVELOPER (1.5k●3●5) Feb 08 '12, 9:32 p.m.
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.

0 votes

Permanent link
Pierre-Luc Turcotte
(48●3●5) 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

0 votes

Permanent link
Hao Wan
JAZZ DEVELOPER (1.5k●3●5) Mar 07 '12, 9:48 a.m.
@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

0 votes

Permanent link
Pierre-Luc Turcotte
(48●3●5) Mar 07 '12, 11:14 a.m.
@wanhaobj

Thanks a lot for the info.

next problem now...

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.

Ask a question
Guidelines
FAQ
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: Dec 16 '11, 5:58 a.m.

Question was seen: 5,196 times

Last updated: Dec 16 '11, 5:58 a.m.

Confirmation Cancel Confirm