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

Update a Test Plan by the Excel Importing tool

Hi every one

Im starting with the .CFG configuration file of the excel import tool, I have the situation where 2 teams add TestCases to an actual TestPlan but for example the second time I import the same file with new testcases but it disassociates old ones. Is there any way to add them and conserves actuals?

Gracias

This is my CFG:
//Config for Testplan
testplan.dc:title=B1
testplan.XLSArtifactID="urn:com.ibm.rqm:testplan:98"
testplan.dc:description=B2
testplan.XLSLink=testcase

// use the data in the first row of a found script's column B
Start looking for scripts after row 2
testscript.XLSStartRow=8
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=C
testscript.steps.type="execution"
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.description=E
testscript.steps.expectedResult=F

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n

// we want to use the data we got for each test script to create a test case
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
testcase.category term="Aplicación".value=B3
testcase.category term="Módulo".value=B4
testcase.category term="Área Responsable".value=B5
testcase.category term="Tipo de Prueba".value=B6

0 votes



One answer

Permanent link
You can only do it by putting the "old" and "new" test cases in the same Excel file. There is no other way round. When you do the import, it simply "updates" the existing artifact and the content in the Excel file is the new content of the artifact. In other words, it replaces the content with what you see in the Excel file.

0 votes

Comments

I was able to do that by adding:
testcase.testplan=LinkExisting("urn:com.ibm.rqm:testplan:"&D1)

D1 = Test Plan ID

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
× 6,126

Question asked: Oct 13 '15, 11:47 a.m.

Question was seen: 2,974 times

Last updated: Oct 14 '15, 3:59 p.m.

Confirmation Cancel Confirm