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

How to update a field in ETM through excel export and import?

Questions
Tags
Users
Badges
Mohanraj Ragupathi
(54●5●20) Nov 11 '21, 3:09 a.m.

 We are using ETM 702 . Business team wants to add a customize field in all ETM artifacts and update the field programmatically. Do we have any option like exporting the artifact including the customize field in excel and update the field value and import it again (like in EWM)? 

I want to give a try with excel export utility. Don't know whether this scenario will be covered or not.

If any one already come across this scenario , please throw some light on this.

0 votes

Comments
Chandan M B
Nov 13 '21, 6:51 a.m.

 Hi Mohanraj,


 You can use the excel export utility for this purpose
 Export the required test cases into excel
 Prepare the config file such that XLSArtifactID as test case ID
 Excel Importer will identify this test case already exists and update the test case with custom attributes

Mohanraj Ragupathi
Nov 15 '21, 1:34 a.m.

Thanks Chandan . I will give a try and let you know. 

Mohanraj Ragupathi
Nov 18 '21, 6:40 a.m.

As you suggested I tried.This is the script & Attached the excel table "image"

testscript.XLSStartRow=4
testscript.XLSArtifactID=A
testscript.dc:title=B
testscript.customAttributes identifier=C1.name=C3.type=C2.value=C
I am getting this error. 
Initializing.....
Reading Configuration File....
Resolving artifacts from document - "Execution Script.csv".....
Sending testscript 0 named 1232160...
Error sending to server 1232160 of type testscript
The remote server returned an error: (400) Bad Request.
Message: Required property 'steps' is missing.
Exporting completed with 8 failures!

Chandan M B
Nov 18 '21, 11:30 a.m.

As per the error message, you have to pass all mandatory fields along with custom attributes. Looks like your test script step is missing.

0 answers
688 views
0 votes

Be the first one to answer this question!

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
× 17

Question asked: Nov 11 '21, 3:09 a.m.

Question was seen: 688 times

Last updated: Nov 18 '21, 11:30 a.m.

Confirmation Cancel Confirm