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

Import testscript to RQM from Excel which contain information in different worksheet

I don't know how import testscript when I have the information of the testscript in a workbook but in different worksheet.

Thank you very much

0 votes



3 answers

Permanent link
Hi Diego,
if the testscript have the similar structure in the different worksheets (i.e. title, descripttion, steps are all in the same column/cell), then don't use XLSWorksheetID in the config file, Excel Importer will construct test script from all the worksheets.

0 votes


Permanent link

Thank you Hao for your answer, but it doesn't work as I would like.

So I going to say in more detail how I have specified an excel file that contains a single script with several tabs:
Tab --- 'Summary' contains title and description
Tab --- 'Test Steps' cntains title of step, decription of step and expected result of step
There are other labels that I'm not interested
I created the following configuration file:
testscript.dc: title = C9
testscript.dc: description = B12
testscript.XLSStartRow = 15
testscript.steps.type = "Manual"
testscript.steps.name = B
testscript.steps.description = C
testscript.steps.expectedResult = D
testscript.XLSDelimeter = \ n
When exported to RQM, generated several testscript and none of them have steps. I would like to generate a single testscript with the steps specified. I don't know what is wrong

0 votes


Permanent link
 Hi Diego,
just from your config file, there's one problem,
testscript is for manual and remotescript is for others types
so you can try to change 
testscript.steps.type = "Manual" 
to 
testscript.steps.type = "execution" 
to see if it works this time,
if not you can refer to the sample "Test Cases made from scripts.xls", 
or attach the excel file, then I can have a try on my environment.

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: Dec 11 '12, 4:53 a.m.

Question was seen: 3,829 times

Last updated: Dec 12 '12, 1:58 a.m.

Confirmation Cancel Confirm