Import from excel in a test plan- Why existing tests cases are replaced after the import of new tests cases?
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 exporttestcase.XLSWorksheetID="TestCases"// the test cases start at the row 8testcase.XLSStartRow=8//Fields of TCtestcase.state=Btestcase.priority=Ctestcase.dc:title=Dtestcase.dc:description=Etestcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=Ftestcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=Gtestcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXP-RESULTS-TITLE")=Htestcase.jzalm:owner=Itestplan.XLSLink=testcasetestcase.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
One answer
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
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.
---
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)
Comments
Don Yang
May 11 '23, 5:46 a.m.Hi Isabelle
Isabelle le menez
May 11 '23, 8:16 a.m.hi Don
I've tried with the ID of artifact but the tests ware duplicated too.
I don't understand the subtilties.