Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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! 

9 answers

1 accepted

12 votes
Answer accepted

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.

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

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

Like Tom Lukasiewicz likes this

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

This is now broken in Jira cloud as they've removed the HTML export option - any other ideas on how to work around it?

Hi Tom,

Scroll down to the bottom of this thread and see if Smita's work around is still working.

Cheers!

Scroll down to the bottom of this thread and see my comment to visualize this in MS Excel export

still works as of October 2020. Thanks!

5 votes

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

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

Just saying

Like Marcelo Lopez likes this

Saying again....

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.

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

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

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

Now Import Data from HTML into Excel

  1. Open an Excel file.
  2. Click Browse for More… in the lower-left corner of the popping out window.
  3. Find the HTML file you want to import in the folder, then double-click it or hit Open.
  4. 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.

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

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)

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

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.

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

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 :(

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

Like Administrator likes this

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

Don't despair, we're on the server version now and the option I described above is still available.

Not on Cloud though. Can't see any option to keep Epic link and issue Id is sth separate from Epic issue ID. 

Thank you so much, that worked!

Glad to help!

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?

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

Nope.
I hate this too.

I now manually find and replace the JIRA ID to the epic name for my reports

You can click on Printable and save the page as HTML. Then open it as Excel. Still works 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you