Importing Multi-valued Attributes using RQM Excel Importer

Bhargavi Battala (11●1●2) | asked Jun 29 '12, 8:59 a.m.

Hi,

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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Hao Wan (1.5k●3●5) | answered Jul 02 '12, 2:06 a.m.
JAZZ DEVELOPER
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.
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

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:

Script:
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.

E.g:
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

Hutter Donat 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.5k●3●5) | answered Jul 02 '12, 12:50 a.m.
JAZZ DEVELOPER

hi Bhargavi, depending on which multi-valued attributes you using, are you using multi-valued categories? or some other attributes?

Comments

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

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

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

0	permanent link Bhargavi Battala (11●1●2) \| answered Jul 02 '12, 2:22 a.m. Thank you Hao Wan

permanent link

Gerd Schiering (122●1●13●16) | answered Feb 14 '14, 5:04 a.m.
JAZZ DEVELOPER

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

It's all about the answers!

Related questions

Importing Multi-valued Attributes using RQM Excel Importer

5 answers

Your answer