Import CSV issue - description column not rendering HTML tags

[siddhesh pawar]

I have imported CSV issue ,the column has HTML tags in it after mapping it with Description column it is showing all html tags as<div><b>Actual Result: </b></div>.

I have enabled the HTML renderer for the field still same issue.

Any solution for this?

[Sachin Dhamale]

@siddhesh pawar 

Here you can do this 2 ways

Either you can convert html tag to wiki tag in the csv file it self and then import OR

You can import csv file and then you can write groovy script/plugin which will process the imported issues description field where it will convert html text to wiki text. 

Here is some API/Dependency  Or you can also use some other API which will done your Job

<dependency>
  <groupId>com.atlassian.renderer</groupId>
  <artifactId>atlassian-renderer</artifactId>
  <version>8.0.5</version>
</dependency>

convertXHtmlToWikiMarkup  - Method which convert text.

You can also refer this one - https://community.atlassian.com/t5/Adaptavist-questions/Convert-HTML-tags-in-description-field-when-copying-from-Insight/qaq-p/1805629

Please accept the answer if it helps you

[siddhesh pawar]

Thanks @Sachin Dhamale,

Instead of importing CSV, now I'm integrating JIRA with Azure Devops using Exalate.

Now after Synchronization HTML tags are not coming but formatting is also gone.

eg:

Original Description from Azure Devops 

This will be an image1

Italic

1. Step 1 
2. Step 2 

After sync with Jira

This will be an image1 Italic Step 1 Step 2

any idea what must be going around here?

[francis]

Hi @siddhesh pawar 

Checkout this thread on the exalate community
https://community.exalate.com/questions/25070212/converting-html-to-wiki---the-azure-devops-style


It should provide you the necessary details.

Francis

[siddhesh pawar]

Thanks @francis,

The given Post suggests to convert HTML to Wiki as after sync they are getting description in HTML tags(<>) and they are converting it to Wiki, whereas in my case plain text is coming(without any tags or formatting) after sync in Jira server.

what can be done in this case?

[Pramodh M]

Hi @siddhesh pawar 

Welcome to the Community!!

Can you change the Description field rendering to Wiki

Here's the solution

https://confluence.atlassian.com/jirakb/issue-description-or-comment-is-showing-the-html-code-rather-than-the-real-content-296092664.html

Thanks

[siddhesh pawar]

Thanks @Pramodh M 

I did the same already , Description field is Wiki Rendered , I even created custom field and rendered it to Wiki still getting same issue.

[Pramodh M]

Here's the Wiki Format, you need to follow

https://jira.atlassian.com/secure/WikiRendererHelpAction.jspa?section=all

[siddhesh pawar]

Thanks @Pramodh M

As I am Importing data from CSV, my csv file has data in the format of HTML tags as "<div><b>Actual Result: </b></div>" , so as per your suggestions do I need to convert it manually to the format you mentioned in the link https://jira.atlassian.com/secure/WikiRendererHelpAction.jspa?section=all 

[Pramodh M]

@siddhesh pawar 

Yes Correct