Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

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

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

3 votes
Answer accepted

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.

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

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

This worked for me, thank you.

In JIRA Cloud, 

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

Its easy for me to reproduce 

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

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

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.

0 votes
Brant Schroeder Community Leader Sep 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.

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 Sep 20, 2017

What version of JIRA are you using?

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

Brant Schroeder Community Leader Sep 20, 2017

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

0 votes

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

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.

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

Hi! 

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

jira.export.excel.enabled=true

Cheers,

Gonchik Tsymzhitov 

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.

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.

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

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). 

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

☕️ Monday coffee with Jexo: Weekly Atlassian news roundup | 21st June 2021

Hi community 👋, as every Monday we're bringing you a quick update on what happened in the Atlassian ecosystem last week. There were a few interesting events like for example the announcement of th...

56 views 0 6
Read article

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