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