When exporting JIRA search results to csv linked issues column does not appear

Angie Goodman September 20, 2017

To replicate in JIRA (Cloud):  

1) Navigate to Search issues.

2) Add column "Linked Issues"

3) Search for something (that results in Linked Issues in some of the results)

4) Export to csv with "current fields".  The column of "Linked Issues" is not there.

5) Export to HTML report "current fields".  The column of "Linked Issues" IS there.

Why does it not appear with CSV?

11 answers

1 accepted

4 votes
Answer accepted
John Graves August 5, 2019

3 years later and it seems this issue still remains. However, one work around I found was:

  1. Export in HTML format (all linked issues should appear in this format)
  2. Open the HTML in Excel (I'm using Office 365) - The table format is maintained and allows you to set filters etc
  3. Save As excel format and do any further analysis as needed

Hope that works for you.

Roy Fitzpatrick August 7, 2019

Hi John,

thanks for that. Can you advise where I can export as HTML please? I have attached a screen shot of all my export options on the cloud version we're using and that does not appear:

JIRA Export List.png

 

Many thanks,

Roy

Angie Goodman August 7, 2019

John,

Thank you for the workaround.  It did at least pull the actual JIRA numbers for me (although they were not links like the key fields).  It would be nice if Atlassian would correct the problem though.

 

Roy,

It seems that there is a known bug JRACLOUD-68954 : Missing export HTML option.  Odd...it says the JIRA was updated in May 2019, but I don't see an update, and it is closed.  It almost reads like they have removed the html option (although I still have it).  There is a linked issue JRACLOUD-62115 that is open.  Maybe you could comment there.

 

Angie

Adam July 17, 2020

This worked for me, thank you.

2 votes
Sean Howe July 9, 2019

I'm also having the same issue. Is this being looked at by the Atlassian team?

Roy Fitzpatrick July 10, 2019

I'm having the same problem. Very frustrating, as it's something I would report on daily / weekly etc. 

Jason Neely July 25, 2019

I see the columns for many types of issues linked, but comparing the actual linked issues and the results in the .csv differ.   in the HTML all the linked issues appear.   The reason i prefer the .csv is that the results where there is a 1:many result in multiple columns... while this can be cumbersome for labels, it's great for issue Keys using lookups.

2 votes
Mark Cliffe September 24, 2018

In JIRA Cloud, 

When I export my linked issues, I get empty values in all rows except 1.

Its easy for me to reproduce 

1 vote
Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 20, 2017

Angie

In the CSV it should have the linked issues but they will be labeled by the link type.  For instance I have an issue that has three links associated in the issues search view.  When I export using CSV current fields there is no linked issues column.  There is however three additional columns with the titles:

  • Outward issue link (Blocks)
  • Outward issue link (Relates)
  • Outward issue link (Blocks)

The issue numbers are associated with the proper field.  Since I have two issues that are linked and blocked it creates two additional columns with the same header name.

Hope this helps.

Angie Goodman September 20, 2017

I'm not sure I understand.  Looking at my results, I guess my linked issues must tie to this Issue ID field I see in the excel doc.  Here are my results in JIRA:

jira results.jpgand here are my csv results:

csv export.jpgI was hoping it would give me the linked jiras, and possibly even give them to me as hyperlinks.

Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 20, 2017

What version of JIRA are you using?

Angie Goodman September 20, 2017

It's JIRA Cloud.  I don't think there is a version to reference with the cloud version.

Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 20, 2017

I have server so maybe the behavior is different and that is not available in cloud.

0 votes
Joseph Mangiafico March 29, 2021

If anyone wants this issue fixed, please consider Voting the issue directly to Atlassian Support: https://jira.atlassian.com/browse/JRACLOUD-63388

0 votes
Paige January 8, 2021

This feature does not work for me at all in ServiceDesk 8.5.1 nor in Jira 8.5.9
The only thing I can get to export is duplicate links, which serves me little purpose.  I need to see linked issues to track work with other teams across multiple projects.

 

Edit:  I'm using three different instance of Jira within my company.  My issue is specific to not being able to export linked issues when they are across instances (not projects within the same instance; that doesn't seem to be a problem, at least in the 1 instance I tested in). 

0 votes
Jeff Abbott October 1, 2020

I have Jira v8.4.2 and 'think" I have this same issue with Jira Server. The cause for me is that Inwards links don't get exported. They are only exported in the outward direction of definition. For example, the issues that are blocked don't have an exported issue link. The blocking issues do have that link.

Jeff

0 votes
Lakras_ Abhijit October 8, 2019

Very crude work around.

Step1. export first into excel CSV (current field) where in your exported excel you will not have 'linked issue' column available.

Step2. go back to query modify your columns to have only 'linked issue' column and now export to 'Print List'

Step3. in this 'print list' export you will get only 'linked issue' column (in HTML) copy this single column and paste it as last column in excel sheet which you have got in Step1.

0 votes
Fadi Shahwan May 7, 2018

Im facing the same issue in server version 7.7.1. only one link type "related to" is shown in the XLS and even if there is more that one link it will show me only one of them. i hope if their is a way to customize the exporting option based on our need.

0 votes
Ashish Naidu March 30, 2018

Hi Angie,

Happened to see this post just now as I was too having the same problem.

The best possible solution is to export the report in HTML and then save it as XLS. This worked for me.

Tx,

Ashish N

Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 2, 2018

Hi! 

Have you set this parameter into your jira-config.properties in JIRA_HOME folder? 

jira.export.excel.enabled=true

Cheers,

Gonchik Tsymzhitov 

0 votes
Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 17, 2017

Hi guys! 

Unfortunately, it is related JIRA Software 7.3.6.

 

May be anyone knows this bug reproducable on other standalone system?

 

Cheers,

Gonchik Tsymzhitov

Mark Rasmussen April 6, 2018

I'm running 7.7.1 on a stand-alone server and have the same problem when exporting - the issue links don't reliability show up. The Outward issue links don't always show up. Thinking about buying the Xporter add-on.

Suggest an answer

Log in or Sign up to answer