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

Import Requirement with RQMExcelImporter

Hi all, I have a great trouble!
I am importing requirements from excel with RQMExcelImporter, but I only can get name and description and empty the oters elements. I need to set risk assessment, severity and tags. How can I do it?

I use this cfg:
requirement.XLSStartRow=2
requirement.dc:title=A
requirement.dc:description=B
requirement.risk=C
requirement.jzalm:severity=D
requirement.jzalm:tags=E

Column A and B from excel work fine, what about the others?

Thanks in advance.
Best regards.

0 votes



6 answers

Permanent link
This is the excel sheet I work with:
RESUME DESCRIPTION RISK ASSESSMENT SEVERITY TAGS
Requisito001 Descripcion 1 Very Low Minor sopa, cocido
Requisito002 Descripcion 2 Low Normal caldo, pollo
Requisito003 Descripcion 3 Medium Major pescado, trucha
Requisito004 Descripcion 4 High Critical pasta, tomate
Requisito005 Descripcion 5 Very High Blocker verdura, tempura


Hi all, I have a great trouble!
I am importing requirements from excel with RQMExcelImporter, but I only can get name and description and empty the oters elements. I need to set risk assessment, severity and tags. How can I do it?

I use this cfg:
requirement.XLSStartRow=2
requirement.dc:title=A
requirement.dc:description=B
requirement.risk=C
requirement.jzalm:severity=D
requirement.jzalm:tags=E

Column A and B from excel work fine, what about the others?

Thanks in advance.
Best regards.

0 votes


Permanent link
No one can help me?

A lot of people mail me asking the solution, but I have not!!! I need it, but nobody did answer.

0 votes


Permanent link
The other column's values are being sent to RQM but the values don't match what RQM expects. For instance, the XML schema doc states:
risk

Type:

anonymous, complex content
The risk associated with the requirement. The possible values could be 'Unassigned', 'Very Low', 'Low', 'Medium', 'High', 'Very High'. The corresponding internal representation is number 0-5.


So you need to have numbers 0-5.

0 votes


Permanent link
Yeah, I've read this, but it doesn't work. I don't know why... I use:

requirement.XLSStartRow=2
requirement.dc:title=A
requirement.dc:description=B
requirement.risk=C

title description risk
Requisito001 Descripcion 1 2

What happend?

The other column's values are being sent to RQM but the values don't match what RQM expects. For instance, the XML schema doc states:
risk

Type:

anonymous, complex content
The risk associated with the requirement. The possible values could be 'Unassigned', 'Very Low', 'Low', 'Medium', 'High', 'Very High'. The corresponding internal representation is number 0-5.


So you need to have numbers 0-5.

0 votes


Permanent link
Yeah, I've read this, but it doesn't work. I don't know why... I use:

requirement.XLSStartRow=2
requirement.dc:title=A
requirement.dc:description=B
requirement.risk=C

title description risk
Requisito001 Descripcion 1 2

What happend?

The other column's values are being sent to RQM but the values don't match what RQM expects. For instance, the XML schema doc states:
risk

Type:

anonymous, complex content
The risk associated with the requirement. The possible values could be 'Unassigned', 'Very Low', 'Low', 'Medium', 'High', 'Very High'. The corresponding internal representation is number 0-5.


So you need to have numbers 0-5.


Hi,
The risk field is a "compound" field.
It needs to be specified like so:
requirement.risk.riskLevel=C

This isn't supported until ifix4 of the tool I think.
Even so, it doesn't seem to work. I filed a work item 29813 for it.

0 votes


Permanent link
Is there a sollution for this? If I look at the XSD, both the Id as riskLevel must be included. There isn't much information on this subject.

Does anyone know how to define the riskLevel (Risk Assessment)

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

Question asked: Dec 03 '09, 5:41 a.m.

Question was seen: 7,375 times

Last updated: Dec 03 '09, 5:41 a.m.

Confirmation Cancel Confirm