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

EWM - CSV Import into "Large HTML" Attribute

Questions
Tags
Users
Badges
Kelly Hoffman
(98●1●2●8) May 03 '24, 1:46 p.m.
EWM - CSV Import into "Large HTML" Attribute

IBM Engineering Workflow Management 7.0

What is the formatting requirements to import formatted text into a 'Large HTML' attribute? I have a text file containing HTML Hyperlink codes and I want the Hyperlinks to be properly displayed.



When I import this into an HTML attribute, I am just seeing the HTML codes displayed in my blob of text.

USE CASE
We're using EWM to track reviews, but EWM work items cannot link to DNG Modules. :-(
Therefore, I create a link from DNG via 'Share Link to...' and copy/paste the Hyperlink to the EWM Large HTML attribute.  When creating multiple EWM review work items...I want to import the data, instead of manually editing one at a time.

BTW - if I look at the Web Browser (edge) Elements of a copy (from DNG) / pasted link), the text in the Large HTML attribute is :

<a data-cke-saved-href="https://rtc.server.com/dng0001001/resources/_0IV5cfSIEeunhM8ewfIhtA?oslc_config.context=https%3A%2F%2Frtc.intel.com%2Fgc%2Fconfiguration%2F4254" href="https://rtc.server.com/dng0001001/resources/_0IV5cfSIEeunhM8ewfIhtA?oslc_config.context=https%3A%2F%2Frtc.server.com%2Fgc%2Fconfiguration%2F4254">332862: Customer Reference Board</a>

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER May 06 '24, 4:09 a.m.

I would suggest you export the data on a test system and then import the data you exported. This should give you an idea of how the data would look like and if it imports the way it exports.

Kelly Hoffman
May 06 '24, 12:13 p.m.

I should have mentioned that I did this.

Only the Link Label, i.e. 332862: Customer Reference Board, is exported.
The web link is NOT exported.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER May 07 '24, 2:37 a.m.

I can not change how EWM exports its data. I do not remember how I export data like that in the https://github.com/jazz-community/work-item-command-line, worst case you could modify the tools code.

Kelly Hoffman
May 07 '24, 11:26 a.m.

Sorry, I'm confused by the last comment. I don't want to change how to export data.  I want to import (via CSV import) an HTML encoded string so that EWM displays (in the UI) a hyperlink (link+label) in a Large HTML attribute.


I also don't have access to the jazz-community github and don't know what 'tools code' is, so it's difficult to follow the comment logic.

Perhaps the CSV import feature supports text only.  And HTML strings are treated as text & not properly configured in the Large HTML attribute.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER May 07 '24, 1:19 p.m.
  1. EWM imports/exports the way it does.There is nothing I can do about that. If you want it changed, create an idea. It is unlikely, but not impossible it gets implemented.
  2. I wrote https://github.com/jazz-community/work-item-command-line years ago, because I was thinking EWM lacked automation. It is open source. You can access the link. My previous above just got mangled by the forum software. The tool allows to create work item automation and also has export/import capabilities. You can see if that is enough already, otherwise it is easy enough to branch and change the CSV import/export code. The tool has a mode that exports in a different way than RTC. Maybe I export/import the HTML/XML correctly or more fitting. I do not know at the moment.

    PS: I know that some bigger customers have used WCL in the past for similar reasons.

1 answer
694 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.0k●3●36●48) May 08 '24, 5:39 a.m.

I took some time to test. As explained above, the work item command cline WCL that can be found here https://github.com/jazz-community/work-item-command-line  exports HTML attributes as strings containing the HTML tags. I assume I implemented the import that way as well. I can only suggest to try using the WCL instead the built in CSV export/import.

0 votes

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,031

Question asked: May 03 '24, 1:46 p.m.

Question was seen: 694 times

Last updated: May 08 '24, 5:39 a.m.

Related questions
Confirmation Cancel Confirm