Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Importing Multi-valued Attributes using RQM Excel Importer

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

1

0 votes



5 answers

Permanent link
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

1 vote

Comments

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.

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

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
hi Bhargavi, depending on which multi-valued attributes you using, are you using  multi-valued categories? or some other attributes?

0 votes

Comments

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


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

0 votes


Permanent link
Thank you Hao Wan

0 votes


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

0 votes

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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,121

Question asked: Jun 29 '12, 8:59 a.m.

Question was seen: 8,129 times

Last updated: Feb 14 '14, 5:04 a.m.

Confirmation Cancel Confirm