Is it possible to extract the contents of an excel sheet from EWM?
One answer
For EWM Jazz SCM, a checked in Excel sheet is a binary. Period. EWM does not care for the content.
You can use the available clients, APIs, SDK, whatever, to download such a binary. Once you have downloaded the Excel sheet, you can use whatever capabilities, client, Excel, APIs or whatever to do something with it.
CSV or Excel is sometimes used to transport change management data. There are CSV export/import capabilities in EWM or outside of it. You can use whatever libraries or APIs or SDKs you like to implement something on your own.
Comments
Hi Ralph,
What file, where in EWM? As far as I am aware, you can not download a file using OSLC. Files in SCM can be retrieved using the scm command line, or the plain java client libraries.
Files attached to work items can be downloaded using the plain java client libraries, e.g. the work item command line ( https://github.com/jazz-community/work-item-command-line ) does this.
Thanks for the info
Comments
David Honey
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 23 '23, 7:27 a.m.Have you looked at https://jazz.net/wiki/bin/view/Deployment/CLMProductAPILanding and the EWM API pages it links to?