# Description in the JIRA Import

**URL:** <https://community.eazybi.com/t/description-in-the-jira-import/286>\
**Category:** Questions & Answers\
**Tags:** dataimport, jira\
**Created:** [January 18, 2018, 2:40pm UTC](https://community.eazybi.com/t/description-in-the-jira-import/286 "2018-01-18T14:40:54Z")\
**Posts on this page:** 6\
**Page:** 2

<div class="post-metadata">

**Author:** ![mmawla](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/4af34b/32.png) [@mmawla](https://community.eazybi.com/u/mmawla)\
**Post date:** [April 27, 2022, 8:35am UTC](https://community.eazybi.com/t/description-in-the-jira-import/286/21 "2022-04-27T08:35:05Z")

</div>

Thanks a lot Gerda for your insights. The trick with issues worked for me

Sadly, I work within a very restrictive environment so my options are limited. an Addon might take months to approve.

One last advise, please. In order to extract just the values after | in this multi-line field, I was thinking of using some sort of a substring function with indexof.

something similar to substring ([Issue Business Justification], Indexof('Priority | ') + 11 , Index of(‘Project |’)

I know it might not be clean, but is that attainable?

---

<div class="post-metadata">

**Author:** ![mmawla](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/4af34b/32.png) [@mmawla](https://community.eazybi.com/u/mmawla)\
**Post date:** [April 27, 2022, 4:12pm UTC](https://community.eazybi.com/t/description-in-the-jira-import/286/22 "2022-04-27T16:12:34Z")

</div>

I think I managed to do it using this expression. A bit of detour though.

CASE WHEN  
[Measures].[Issue Business Justification]\>""  
THEN

ExtractString  
(

CoalesceEmpty(Replace([Measures].[Issue Business Justification],CHR(13), “fini”),"")

,

‘._Priority |(.+)fini._’,1

)  
END

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [April 28, 2022, 8:34am UTC](https://community.eazybi.com/t/description-in-the-jira-import/286/23 "2022-04-28T08:34:41Z")

</div>

@mmawla you can try also this formula:

```auto
CASE WHEN
NOT IsEmpty([Measures].[Issue Business Justification])
THEN
Replace(
ExtractString(
  [Measures].[Issue Business Justification],
  '(Priority|\\n) (.*)',
    2),
    "| ", 
    "")
END

```

See related documentation on other [ExtractString()](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/extractstring) examples

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [February 27, 2024, 1:39pm UTC](https://community.eazybi.com/t/description-in-the-jira-import/286/25 "2024-02-27T13:39:58Z")

</div>

Hi @guy.winterbotham ,  
I wanted to let you know that we have released eazyBI version 7.1. recently. In this version, we included the feature to allow importing the Jira “Description” field using the [New calculated fields](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/new-calculated-fields) option. In the eazyBI account, it is possible to use those settings to define and import the description field. The JavaScript code is: `return issue.fields.description`

 ![eazyBI_field_description](https://community.eazybi.com/uploads/default/original/2X/0/02aee53cec22633a0085f1d9c9e7944a7c7b37ad.jpeg)

Please see a list of all changes for eazyBI for Jira app: [Changelog - eazyBI for Jira](https://docs.eazybi.com/eazybi/set-up-and-administer/atlassian-server-and-data-center/changelog-eazybi-for-jira).

Kind regards,  
Gerda // [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![thaynemunson](https://community.eazybi.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@thaynemunson](https://community.eazybi.com/u/thaynemunson)\
**Post date:** [May 16, 2024, 7:21pm UTC](https://community.eazybi.com/t/description-in-the-jira-import/286/26 "2024-05-16T19:21:48Z")

</div>

I am currently importing the description field into my eazybi project. I am trying to see if I can use the description field as a psudo project status report. I have added some of the jira ‘insert elements’ to the field but they are not rendering in my eazybi report. Is there some way to get these inserted elements to display correctly? Thanks, Thayne.

**Jira detail screen**

 ![image](https://community.eazybi.com/uploads/default/original/2X/3/334dbc2926403c1a9286e2d8fd7ae898eaa46fbc.png)

**Eazybi report screen**

 ![image](https://community.eazybi.com/uploads/default/original/2X/3/307661c344090c674343cf96e9706182248276f9.png)

---

<div class="post-metadata">

**Author:** ![lauma.cirule](https://community.eazybi.com/user_avatar/community.eazybi.com/lauma.cirule/32/8830_2.png) [@lauma.cirule](https://community.eazybi.com/u/lauma.cirule)\
**Post date:** [May 20, 2024, 12:31pm UTC](https://community.eazybi.com/t/description-in-the-jira-import/286/27 "2024-05-20T12:31:18Z")

</div>

Hi @thaynemunson,

Only HTML and Markdown are supported for text formatting; see [calculated member formatting description](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Formatting). eazyBI does not recognize [JIRA Rich text formatting](https://jira.atlassian.com/secure/WikiRendererHelpAction.jspa?section=all) and returns the plain text as entered when you edit the field.  
We have a feature request related to this in our backlog, and I will upvote the feature with your request, but I cannot give any estimates on this development.

Lauma / [support@eazybi.com](mailto:support@eazybi.com)

[Previous page](https://community.eazybi.com/t/description-in-the-jira-import/286.md?page=1)
