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 |
3 answers
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. |
|
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
|
|
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
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.