EWM - CSV Import into "Large HTML" Attribute
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.
<a href="https://rtc.server.com/dng0001001/resources/_R1j10cgdEemcIdm2QVkI0Q?oslc_config.context=https%3A%2F%2Frtc.server.com%2Fdng0001001%2Fcm%2Fbaseline%2F_gEyLoAJkEe-qMcmLs7VTaQ">201481: My Module</a>
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> |
One answer
Ralph Schoon (63.6k●3●36●47)
| 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
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.
Comments
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.
I should have mentioned that I did this.
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.
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.
PS: I know that some bigger customers have used WCL in the past for similar reasons.