Importing Multi-valued Attributes using RQM Excel Importer
5 answers
hi Bhargavi,
yes we support this scenario. if your multi-valued categories is "Cagetory1" in the testcase and 3 values to choose from.
you can use the config file like:
testcase.category term=cell1.value=F / F1
testcase.category term=cell2.value=G / G1
testcase.category term=cell3.value=H / H1
you can use the config file like:
testcase.category term=cell1.value=F / F1
testcase.category term=cell2.value=G / G1
testcase.category term=cell3.value=H / H1
cell1, cell2 and cell 3 all stored category name "Category1"
cell is the excel cell such as A1, H3 etc.
if your testcases have different category values, you can specify with a column, if the same you can use a cell.
and
F G H
case1 v1 v2 v3
case2 blank v2 v3
case3 v1 blank v3
then testcase1 will have multi category value v1,v2, v3
and testcase2 will have multi cagtegory value v2, v3,
and testcase3 will have v1 and v3
if your testcases have different category values, you can specify with a column, if the same you can use a cell.
and
F G H
case1 v1 v2 v3
case2 blank v2 v3
case3 v1 blank v3
then testcase1 will have multi category value v1,v2, v3
and testcase2 will have multi cagtegory value v2, v3,
and testcase3 will have v1 and v3
Comments
To clarify the solution steps:
The syntax F / F1 means the two values are in the same cell.
The syntax F / F1 means the two values are in the same cell.
But for Excel to understand the difference you need a newline character in between the two values.
To put a new line character in a cell in an Excel spreadsheet you have to type
Alt+Enter to start a new line inside that cell.
Then specify the next value of the possible multi-value entries in that same cell.