It's all about the answers!

Ask a question

RQMExcelWordImporter Problem when Importing Test Cases


Andrew Trobec (49713144139) | asked Oct 14 '11, 10:31 a.m.
Hello,

I am trying to import Test Cases into RQM2.0.1 iFix 5 using the RQMExcelWordImporter tool without linking them to any other artifact.

I read the Keywords and special cases section of the document here https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter which states
XLSArtifactID specifies the external ID of the artifact and then proceeds to give the example testcase.XLSArtifactID=D1. Taking this into consideration I constructed my own configuration file

testcase.XLSStartRow=2

testcase.XLSArtifactID=A
testcase.dc:title=F
testcase.dc:description=S
testcase.category term="System".value=T
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=H
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXP-RESULTS-TITLE")=J
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseNotes","RQM-KEY-TC-NOTES-TITLE")=Q

As you can see I have specified that the XLSArtifactID is listed in column A.

When I import my data, it correctly shows that it is inserting my Test Cases. Here is a section of the log:

14/10/2011 14:59:53: sending testcase0 named D01_TS02_1.xml

14/10/2011 14:59:54: Server returned code OK
14/10/2011 14:59:54: sending testcase1 named D01_TS02_2.xml
14/10/2011 14:59:55: Server returned code OK
14/10/2011 14:59:55: sending testcase2 named D01_TS02_3.xml
14/10/2011 14:59:55: Server returned code OK
14/10/2011 14:59:55: sending testcase3 named D01_TS02_4.xml

I also read in the document that if it does not read the ID, it will use the format <Excel>_<Excel>.xml which isn't the case.

The only problem is that when I now open the Test Cases, I find that it has added a new section XLSArtifactID to the bottom of the section list, with the value of the ID in the text box! This shouldn't happen!

Here is a screenshot of one of the uploaded Test Cases: http://i.imgur.com/bHj2L.jpg

What am I doing wrong, and how can I solve?

Thank you and best regards,

Andrew

One answer



permanent link
Paul Slauenwhite (8.4k12) | answered Nov 10 '11, 3:21 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
Most likely caused by https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/52851. Try using a literal string instead.

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.