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

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

Questions
Tags
Users
Badges
Isabelle le menez
(11●2) 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


0 votes

Comments
Don Yang
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
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.

1 answer
4,331 views
0 votes

One answer

Permanent link
Don Yang
(7.7k●21●114●139) 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.

0 votes

Comments
Isabelle le menez
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
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 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.

Ask a question
Guidelines
FAQ
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,180
× 174
× 64

Question asked: May 11 '23, 4:54 a.m.

Question was seen: 4,331 times

Last updated: May 18 '23, 12:00 a.m.

Confirmation Cancel Confirm