It's all about the answers!

Ask a question

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


Andrew Trobec (49713144139) | asked May 21 '14, 9:30 a.m.
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

Comments
Lily Wang commented May 21 '14, 11:33 p.m.

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


Andrew Trobec commented May 22 '14, 2:10 a.m.

@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


Andrew Trobec commented May 22 '14, 2:15 a.m.

@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


Lily Wang commented May 22 '14, 3:51 a.m.

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.


Andrew Trobec commented May 22 '14, 5:10 a.m.

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


Andrew Trobec commented May 22 '14, 5:11 a.m.

@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
Diane Everitt (27835) | answered May 22 '14, 3:03 p.m.
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

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.