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

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

Questions
Tags
Users
Badges
Prasad Barude
(13●1●2) Mar 23 '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?

0 votes

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?

1 answer
2,552 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) edited
Mar 23 '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.

0 votes

Comments
Prasad Barude
Apr 25 '23, 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
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 25 '23, 10:29 a.m.
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
May 22 '23, 3:00 a.m.
 Thanks for the info

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
× 12,144
× 1,736

Question asked: Mar 23 '23, 6:10 a.m.

Question was seen: 2,552 times

Last updated: May 22 '23, 3:00 a.m.

Confirmation Cancel Confirm