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

RQMExcelWordImporter Problem when Importing Test Cases

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

0 votes



One answer

Permanent link
Most likely caused by https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/52851. Try using a literal string instead.

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: Oct 14 '11, 10:31 a.m.

Question was seen: 7,600 times

Last updated: Oct 14 '11, 10:31 a.m.

Confirmation Cancel Confirm