nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to export "Epic Link" with all fields (KEY and NAME)?

Analucia Martin

I am exporting the results of a query I created in JIRA where one of the fields is the JIRA (locked) custom field "Epic Link". When viewing the results of the query in JIRA, the "Epic Link" field is rendered as the Name of the Epic (for example: "Fluids Events") but when I export the exact same fields, the value that exports for "Epic Link" is the JIRA ID for that Epic as opposed to the Epic Name (for example: JIRA-101 instead of "Fluids Events"). I need to export the Epic Name as it is rendered in JIRA when I am viewing the results of the query. Adding the column "Epic Name" results in blank values for that column for any story/bug/task that's part of an Epic, so that's not a solution. Help please!

Accepted answers

unknown

Keep the "EPIC Link" column, but export it as HTML. Save the file locally and open it with Excel. I get the actual names when I use this approach. You can then save it as a worksheet.

All comments

unknown

Keep the "EPIC Link" column, but export it as HTML. Save the file locally and open it with Excel. I get the actual names when I use this approach. You can then save it as a worksheet.

Analucia Martin

Thank you so much, that worked!

unknown

Glad to help!

Pablo Lopez Martin

Hi, this is still an issue for me.

From JIRA 7.2.X you can no longer do Excel HTML exports, so you are bound to use csv export, where the Epic Link is displayed as the JIRA ID, as opposed to the Epic Name.

There is a way to force enable the old Excel HTML exports but it will be something that they look forward to deprecate in future releases.

Is there any workaround for showing the name in the csv exports?

Brad White_4vz3of

A bit of a necro of this thread sorry, but I am facing this exact issue...and it looks like the "old Excel HTML" has indeed been deprecated.

Is there any way to obtain the actual Epic name rather than the JIRA ID for the Epic?

Thankyou in advance :-D

unknown

Hi guys,

This still works, select this export option and follow the rest of the steps I outlined above.

Screen Shot 2017-07-12 at 8.31.28 AM.png

joris van Emden_q6ww7s

What Jira version are you using?
They removed in JIRA v7.2.4 the HTML option.
So I guess we are downgraded from that version onwards

unknown

I'm currently on the 'Cloud' or 'On Demand' depending on what you want to call it. So I assume it's the latest version. Are you on the server version?

Not sure about that one. I do remember last year they messed the export options up and everyone screamed. I think the latest version is 7.4. You might want to upgrade

Alex Nicholas_lw7x5p

This sucks... why remove the only workaround for something so simple?

Jane Sherman_7deq4b

For those on the server version who can't export to html, I just cut/paste from an issues search where type = epic. Requires some cleanup, but it's the fastest way I can find.

Matt Hessler

Just ran into this issue. Your solution works great. Thanks for the workaround!

unknown

Good workaround, works in Cloud. Seems like Jira should handle this simple request without a workaround though.

Smita_4wri9n

This is a great solution. I am glad one less Market Place plugin to look for.!

Smita_4wri9n

For Everyone who is using JIRA server and would like to export Epic Name

1. Once you have your JQL results, click on Printable.

2. Save the page as HTML

3. Open the saved HTML page in Excel workbook : you could see all your Epic Names as its shown in the UI

Aron Gombas _Midori_

When you export using the Better PDF Exporter, the value of the Epic field will contain the name of the epic. If you also need to include the key, you can do that by customizing the "issue-navigator-fo.vm" template.

b088fd88-b60e-402e-83e3-4429b103d98a

unknown

That's assuming you want to pay $.95/user/month...

Just saying

matt.digel

These are the only options I'm seeing. Where is printable? Screen Shot 2019-06-07 at 11.45.05 AM.png

Smita_4wri9n

Probably depends upon your JIRA version. For me that is the first option in the drop down (but hey we are using the old version)

Paolo Franco Solinas_ns8ic3

i recently started using the Get Jira Data Excel add into import data from Jira. I have the Jira Cloud version. For having the name of the Epic on report i included the Epic Link.Name field.

Please upvote/accept the answer if you're satisfied with the response. Thanks!

Epic Link.name.jpg

unknown

Saying again....

Liah Fereydoonzad

Paolo, how do you get the Epic Link.Name field?

Sukanya_ohkv72

Keep the "EPIC Link" column, but export it as HTML.

Now Import Data from HTML into Excel

Open an Excel file.
Click Browse for More… in the lower-left corner of the popping out window.
Find the HTML file you want to import in the folder, then double-click it or hit Open.
As suggested by the tip, click the arrow icon to select the area of data then hit Import in the lower-right corner of the window.

Save the file locally and open it with Excel. I get the actual names when I use this approach. You can then save it as a worksheet.

Adam Dulberg

As a 'community leader' @Aron Gombas _Midori_ I am disappointed to see you recommend a paid option. I wish Atlassian had a tighter grip over their forum and would discourage this type of behavior and strip individuals of their ability to respond as posts like this should be infringing community policies - in my opinion. Whether you have a stake in the paid option or find it helpful yourself, a suggestion like yours does not educate folks to understand the situation and the capabilities of the application.

Very unhelpful.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud