Is it possible to extract the contents of an excel sheet from EWM?

Prasad Barude (13●2) | asked Mar 23, 6:10 a.m.

I want to extract some contents from already checkedin excel sheet in EWM.

Do I have to download and extract the contents? or is it even possible to download an item from EWM using OSLC?

Comments

David Honey commented Mar 23, 7:27 a.m.

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Have you looked at https://jazz.net/wiki/bin/view/Deployment/CLMProductAPILanding and the EWM API pages it links to?

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Ralph Schoon (62.7k●3●36●43) | answered Mar 23, 7:41 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited Mar 23, 7:43 a.m.

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

Prasad Barude commented Apr 25, 9:43 a.m.

Hi Ralph,

Thanks for the answer.

However, do you know how to download a file in EWM using OSLC query?

Ralph Schoon commented Apr 25, 10:29 a.m.

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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.

Prasad Barude commented May 22, 3:00 a.m.

Thanks for the info

It's all about the answers!

Related questions

Is it possible to extract the contents of an excel sheet from EWM?

One answer

Your answer