It's all about the answers!

Ask a question

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


Isabelle le menez (111) | asked May 11 '23, 4:54 a.m.
edited May 11 '23, 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 '23, 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 '23, 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



permanent link
Don Yang (7.7k21109138) | answered May 14 '23, 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 '23, 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 '23, 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)

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.