It's all about the answers!

Ask a question

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


Diego Berzal (111) | asked Dec 11 '12, 4:53 a.m.
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

3 answers



permanent link
Hao Wan (1.5k35) | answered Dec 11 '12, 9:49 a.m.
JAZZ DEVELOPER
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.

permanent link
Diego Berzal (111) | answered Dec 11 '12, 11:36 a.m.

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

permanent link
Hao Wan (1.5k35) | answered Dec 12 '12, 1:58 a.m.
JAZZ DEVELOPER
 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.

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.