It's all about the answers!

Ask a question

EWM - CSV Import into "Large HTML" Attribute


Kelly Hoffman (9828) | asked May 03, 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>


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

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 commented May 06, 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 commented May 07, 2:37 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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 commented May 07, 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 commented May 07, 12:24 p.m. | edited May 07, 1:19 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
  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.

One answer



permanent link
Ralph Schoon (63.6k33647) | answered May 08, 5:39 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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.

Your answer


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.