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

RQMExcelImporter creates section "XLSArtifactID" when importing Test Plans. How can I avoid this?

Hello,

I am using RQM 4.0.3 and when I import a Test Plan with the Excel import tool and use the testplan.XLSArtifactID="Test Plan Name" command to assign a re-usabile External ID, it adds the new section XLSArtifactID to the bottom of the Test Plan in the Web UI.

How can I avoid this from happening?

I have read in some other posts that the XLSArtifactID section should not be visibile in the web UI, but this is not the case.

Regards,

Andrew

0 votes

Comments

Hi Andrew,
Why do you need to import Test Plan with an existing external ID?
Could you share the cfg file you used?

@liwang

Hello Lily,
The following script will create a Test Plan > Test Case > Test Script hierarcny:
testscript.XLSStartRow=2
testscript.XLSArtifactID=C
testscript.dc:title=E
testscript.steps.type="execution"
testscript.steps.description=G
testscript.steps.expectedResult=H
testscript.XLSDelimeter=\n
testcase.XLSLink=testscript
testcase.dc:title=testscript.dc:title
testplan.XLSLink=testcase
testplan.XLSArtifactID=A2
testplan.dc:title=B2
I want to assign an ID to the Test Plan so I can add Test Cases to it in multiple imports.
Regards,
Andrew

@liwang

I'd also like to add that the creation of the section XLSArtifactID also happens with the Test Case.  The above script will avoid that issue by taking the values assigned to the Test Script as well.  If I were to add the line:
testcase.XLSArtifactID = C
Then the section would be visible in the WebUI as well.  It's not just limited to Test Plans.
Regards,
Andrew

From the first cfg file you provided, I don't see any problem.
But you mentioned you used testplan.XLSArtifactID="Test Plan Name" to add more test case to the test plan. What's the entire cfg file for it?

BTW, similar issue reported before:
https://jazz.net/forum/questions/85665/remove-tc-section-id-xlsartifactid-after-creating-link-with-testcaseidtestscriptxlsartifactid
https://jazz.net/forum/questions/94068/rqmexcel-importer-get-an-id-with-testplanxlsartifactid
which were fixed due to incorrect configuration file.

@liwang

The config file works, but the only problem is that it adds a section called "XLSArtifactID" to the Test Plan, even though it shouldn't.  If I don't include the line
testplan.XLSArtifactID=A2
then the Test Plan gets assigned a generic ID and I lose the possibility of assigning new Test Cases to it through successive imports.  My reference to the line
testplan.XLSArtifactID="Test Plan Name"
was just to highlight the fact that I am assigning the ID.  In my actual script I am using a cell reference A2.

@liwang

I took a look at the links that you provided, but they don't solve my problem unfortunately.

showing 5 of 6 show 1 more comments

Accepted answer

Permanent link
Hello Andrew,

This appears to be a known defect and is fixed in version 4.0.4:

https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=88997

I realize the title of the defect specifies test case, but it appears to be the same problem with all test artifacts.

Please review the defect description.  I hope this helps.

Thank you,
Diane
Andrew Trobec selected this answer as the correct answer

1 vote

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
× 12,020

Question asked: May 21 '14, 9:30 a.m.

Question was seen: 3,796 times

Last updated: May 22 '14, 3:03 p.m.

Confirmation Cancel Confirm