It's all about the answers!

Ask a question

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


Mohanraj Ragupathi (54520) | asked 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.


Comments
Chandan M B commented 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 commented Nov 15 '21, 1:34 a.m.

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


Mohanraj Ragupathi commented 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 commented 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.

Be the first one to answer this question!


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.