It's all about the answers!

Ask a question

Import Requirement with RQMExcelImporter


Jose Maria Bernal Fernandez (461) | asked Dec 03 '09, 5:41 a.m.
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.

6 answers



permanent link
Jose Maria Bernal Fernandez (461) | answered Dec 03 '09, 5:52 a.m.
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.

permanent link
Jose Maria Bernal Fernandez (461) | answered Dec 11 '09, 6:57 a.m.
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.

permanent link
Mike Yalter (11611) | answered Dec 11 '09, 3:33 p.m.
JAZZ DEVELOPER
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.

permanent link
Jose Maria Bernal Fernandez (461) | answered Dec 14 '09, 9:03 a.m.
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.

permanent link
Mike Yalter (11611) | answered Mar 18 '10, 10:40 a.m.
JAZZ DEVELOPER
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.

permanent link
Joost Voskuil (6) | answered Jan 19 '11, 8:18 a.m.
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)

Your answer


Register or to post your answer.