Import from excel in a test plan- Why existing tests cases are replaced after the import of new tests cases?

Isabelle le menez (11●1) | asked May 11, 4:54 a.m.
edited May 11, 5:00 a.m.

Hi, hope someone can help me

i import new test cases in an existing test plan.

this test plan have already test cases.

after the import, the TC (in plan) are replaced by the new ones (imported)

here my configuration:

// Sheet to export

testcase.XLSWorksheetID="TestCases"

// the test cases start at the row 8

testcase.XLSStartRow=8

//Fields of TC

testcase.state=B

testcase.priority=C

testcase.dc:title=D

testcase.dc:description=E

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=F

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=G

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXP-RESULTS-TITLE")=H

testcase.jzalm:owner=I

testplan.XLSLink=testcase

testcase.testplan=LinkExisting(C3)

//(C3) contains

urn:com.ibm.rqm:testplan:191

Before the import:

4 tests cases in Plan 191 :

ID : 24248 / 24249 / 24250 / 24251

Test name :"test import 1008" ---> "test import 1011"

After the import:

the ID are the same with the imported TC

ID : 24248 / 24249 / 24250 / 24251

Test name :"test import 1023" ---> "test import 1026"

Then i added the column "ID" and the configuration testcase.XLSArtifactID=A

The import was correct with 4 new TC without overwriting the others.

ID : 24248 / 24249 / 24250 / 24251 /24252 / 24253 /24254 / 24555

Test name :"test import 1023" ---> "test import 1026" + "test import 1033" ---> "test import 1036"

But when i imported again news TC, the last 4 were overwriting.

ID : 24248 / 24249 / 24250 / 24251 /24252 / 24253 /24254 / 24555

Test name :"test import 1023" ---> "test import 1026" + "test import 1042" ---> "test import 1045"

"test import 1033" ---> "test import 1036" have been overwriten

I don't understand.

Thanks

Isabelle

Comments

Don Yang commented May 11, 5:46 a.m.

Hi Isabelle

What is ETM and ExcelImporter version?

What are in column A in which you configure testcase.XLSArtifactID=A?

Isabelle le menez commented May 11, 8:16 a.m.

hi Don

versions are : IBM CLM 6.0.6.1 / Mso2Rqm_common version 6.0.6.1.32428

in the column A, it's empty.
I've tried with the ID of artifact but the tests ware duplicated too.
I don't understand the subtilties.

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Don Yang (7.7k●21●108●137) | answered May 14, 11:48 p.m.

Hi Isabelle

But when i imported again news TC, the last 4 were overwriting.

ID : 24248 / 24249 / 24250 / 24251 /24252 / 24253 /24254 / 24555

Test name :"test import 1023" ---> "test import 1026" + "test import 1042" ---> "test import 1045"

"test import 1033" ---> "test import 1036" have been overwriten

===

1) when the last 4 testcases are overwritten, did you only import 4 new test cases or not?

2) at the time, what are external ids set in column A?

when using testcase.XLSArtifactID=A, it is supposed that you would have unique external id to be set in column A,

otherwise, it would overwrite the existing test cases with the same external id(in previous import) in column A.

Try to use unique values(ids) in column A and see if the result is improved.

Comments

Isabelle le menez commented May 15, 5:47 a.m.

Hi,

1/ i've added one test on my excel list. => 4+1 (without ID in excel)

==> CLM : the new one is added. i've 5 tests ==> OK

2/ then, I've tried with and without CLM ID reported in Excel.

In excel, I've put the ID 24281 of one + change description => in CLM, it's duplicated = ID 24282 so i've 2 tests with same name.

Finally it's the contrary of what you say about the ID : when the ID is in excel, the test is duplicated, and when there is no ID the test is overwritten.

Very strange.

Don Yang commented May 18, 12:00 a.m.

---

In excel, I've put the ID 24281 of one + change description => in CLM, it's duplicated = ID 24282 so i've 2 tests with same name.

---

Re- "2 tests with same name.", do you mean test case title(name)?

Please refer to Excel Importer Samples

Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne.xls/Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne.cfg,

in which you can see that it use test case name as external id

testcase.XLSArtifactID=B

so in your use case, you may try to do the same,

testcase.XLSArtifactID=D

(suppose D column is your test case unique name)

It's all about the answers!

Related questions

Import from excel in a test plan- Why existing tests cases are replaced after the import of new tests cases?

One answer

Your answer