It's all about the answers!

Ask a question

Creating more than one ExecutionRecord/Result using RQMExcelWordImporter-5.0.2 is not working


Renzo Disi (122) | asked Oct 27 '15, 2:08 a.m.
edited Oct 27 '15, 2:18 a.m.
 I'm using RQMExcelWordImporter-5.0.2 to create RQM artifacts from an excel with this structure by each row : 

TestPlan
TestCase1 | TestExecutionRecord1 | TestExecutionResult1 | TestExecutionRecord2| TestExecutionResult2 | TCER3|TCERR3
 
I can create TestPlan, TestCase1, TestExecutionRecord1 and TestExecutionResult1. In order to do this I'm using (what I'm presenting now is a simplification to explain  main situation, I have other fields related with other columns) :

executionworkitem.XLSArtifactID="executionworkitem_" & B    (where B is Column where TestCAse Description is)
executionworkitem.ID= B

Also consequently I'm  creating relationships : 

executionworkitem.testcase=Link(B) 
executionresult.testcase=Link(B) 

Everything works fine to create TestExecutionRecord1 & TestExecutionResult1. Nevertheless for 2 & 3 there is no way to create new entries. I have done a lot of test trying to describe a new artifact for 2 and 3. Also I have tried to add a new TCER after testPlan,testcase creation from another excel (in this case I used ids to refer rqm artifacts using /urn:com.ibm.rqm: NOTATION)

My questions : 

1.- It is possible to create more than one TCER from an excel using RQMExcelWordImporter??
   What is the notation/syntaxis to do this? 
   Where I can find an example to do it? (All examples just create one TCER)

2-. Is there another way to do this? 


2 answers



permanent link
Reshma Ratnani (1.1k1) | answered Oct 27 '15, 3:33 a.m.
JAZZ DEVELOPER
Hi Renzo,

To create more than 1 TCER for a testcase you need to follow a simple rule. Each TCER should have diff test env values or diff testplan, you cannot create multiple TCERs for a TestCase with all the details same except name.

permanent link
Renzo Disi (122) | answered Oct 27 '15, 1:42 p.m.
edited Oct 27 '15, 1:43 p.m.
Reshma : 

Is not working...

I created 2 envs. I'm trying to create 2 TCERS in a same load process.. seems is not possible use elements twice in the cfg.  Example  : "Element  XLSArtifactID was added"
====
//TCER 1
executionworkitem.XLSWorksheetID="Script"
executionworkitem.XLSStartRow=3
executionworkitem.XLSArtifactID="executionworkitem_" & B
executionworkitem.dc:title=B
executionworkitem.dc:starttime=O
executionworkitem.dc:description=G
executionworkitem.configuration=Link(BY)
executionworkitem.testphase=Link(BZ)
executionworkitem.testplan=Link(property("name"))
executionworkitem.testcase=Link(B)

//TCER2
executionworkitem.XLSWorksheetID="Script"
executionworkitem.XLSStartRow=3
executionworkitem.XLSArtifactID="executionworkitem_" & B
executionworkitem.dc:title=B
executionworkitem.dc:starttime=O
executionworkitem.dc:description=G
executionworkitem.configuration=Link(BW)   ---> Other env
executionworkitem.testphase=Link(BZ)
executionworkitem.testplan=Link(property("name"))
executionworkitem.testcase=Link(B)



====








27/10/2015 11:22:34 a. m.: ERROR: <Unknown Caller Context>: Config File Line: 85 Ya se ha agregado el elemento. Clave en el diccionario: 'XLSArtifactID' Clave agregada: 'XLSArtifactID'


27/10/2015 11:22:34 a. m.: ERROR: <Unknown Caller Context>: Config File Line: 87 Ya se ha agregado el elemento. Clave en el diccionario: 'dc:title' Clave agregada: 'dc:title'


27/10/2015 11:22:34 a. m.: ERROR: <Unknown Caller Context>: Config File Line: 88 Ya se ha agregado el elemento. Clave en el diccionario: 'dc:starttime' Clave agregada: 'dc:starttime'


27/10/2015 11:22:34 a. m.: ERROR: <Unknown Caller Context>: Config File Line: 89 Ya se ha agregado el elemento. Clave en el diccionario: 'dc:description' Clave agregada: 'dc:description'


27/10/2015 11:22:34 a. m.: ERROR: <Unknown Caller Context>: Config File Line: 90 Ya se ha agregado el elemento. Clave en el diccionario: 'configuration' Clave agregada: 'configuration'


27/10/2015 11:22:34 a. m.: ERROR: <Unknown Caller Context>: Config File Line: 102 Ya se ha agregado el elemento. Clave en el diccionario: 'testplan' Clave agregada: 'testplan'


27/10/2015 11:22:34 a. m.: ERROR: <Unknown Caller Context>: Config File Line: 103 Ya se ha agregado el elemento. Clave en el diccionario: 'testcase' Clave agregada: 'testcase'

Your answer


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