It's all about the answers!

Ask a question

Importing Multi-valued Attributes using RQM Excel Importer

Bhargavi Battala (1112) | asked Jun 29 '12, 8:59 a.m.


I would like to know if we can import multi-valued attributes into RQM from an excel file (if the values are given in a single cell of the excel sheet, seperated with de-limiter (; or , or \n)). If we can, what should we edit in the config file??

5 answers

permanent link
Hao Wan (1.5k35) | answered Jul 02 '12, 2:06 a.m.
edited Jul 04 '12, 3:48 a.m.
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
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.
                    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

Gonzalo Garcia Favre commented Feb 27 '13, 10:25 a.m. | edited Feb 27 '13, 10:29 a.m.

Hi, I'm having problems importing multi-valued categories.

When I use P/P1, the tool throws an error:

testcase.category term="Feature".value= P / P1
testcase.category term="Feature".value= Q / Q1
testcase.category term="Feature".value= R / R1

Each category value are stored in a different column: P, Q or R

Error: Configuration File, Line 31, Found a value that reduced to "P / P1", but was expecting a value equivelant to a column, cell, or literal.

Exporting Aborted: Errors found!

I have a category called Feature.
Each feature can have 1 or more values.

Feature 1: Movies, TV
Feature 2: Movies
Feature 3: Chanel
Feature 4:

how can I import those multiple values? I wont let me do it the way you are posting here.

Gonzalo Garcia Favre commented Feb 27 '13, 11:41 a.m.

Don't worry. I was able to import multi-value categories by having the values in the same cell in different lines. Thanks

Donat Hutter commented Nov 06 '13, 5:04 a.m.

I'm dealing with the same issue/error.

What is the meaning of the syntax F / F1? Can you explain the configuration for multi valued category import a little bit more? 

permanent link
Hao Wan (1.5k35) | answered Jul 02 '12, 12:50 a.m.
hi Bhargavi, depending on which multi-valued attributes you using, are you using  multi-valued categories? or some other attributes?

Bhargavi Battala commented Jul 02 '12, 1:30 a.m.

Hello Hao Wan, I'm using multi-valued categories

permanent link
Bhargavi Battala (1112) | answered Jul 02 '12, 1:46 a.m.
Hello Hao Wan, I'm using multi-valued categories

permanent link
Bhargavi Battala (1112) | answered Jul 02 '12, 2:22 a.m.
Thank you Hao Wan

permanent link
Gerd Schiering (12211116) | answered Feb 14 '14, 5:04 a.m.
To clarify the solution steps:
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. 

Your answer

Register or to post your answer.