Atlassian Excel Plug-in

[Prashant.shastri@centurylink.com]

I am using Excel Plug-in from Microsoft Marketplace, in the list of available fields, I selected Linked Issues, it gives me the Issue Key but not the type of dependencies like Blocked By, Implemented By, etc...which field to select or how can I get the type of dependency for the linked Issues?

Thanks

Prashant

[Dario B · Accepted solution]

Hello Prashant.shastri@centurylink.com ,

Welcome to the Atlassian Community!

If I search our marketplace for Excel and Jira I get around 100 results, so I am not sure which add-on you are referring to: 

• https://marketplace.atlassian.com/search?product=jira&query=excel

Can you kindly let us know which one is installed on your side?

I am asking this because, looking at similar threads, this can be a bug with the app you are currently using and you might have to go to contact their support:

• Export Issues to Excel with Link direction (blocks/blocked by)
• Export Issues from JIRA to .xls – “Linked issues” or Subtasks field

Cheers,
Dario

[Prashant.shastri@centurylink.com]

Dario,

Thanks for the pointers. I am using the Atlassian Excel Plug-in App

https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?hosting=cloud&tab=overview

I think the pointer you gave are probably plug-ins from other vendors.

Thanks

Prashant

[Dario B]

Hello Prashant.shastri@centurylink.com ,

Thanks for clarifying.

If that's the official Atlassian add-on then there are chances this is a bug since, even if the same behavior is experienced in the UI (searching for issues), then everything works as expected when exporting to CSV:

• Run a search on your site and show the "issue link" field (e.g. go to https://YOUR-SITE.atlassian.net/issues/?jql=order%20by%20created%20DESC and customize the returned fields to show the issue links one)
• See that only the issue key is displayed
• Export the results to CSV. 
• See that you get different columns for different kind of issue links. Specifically:
  

  Outward issue link (Blocks),Outward issue link (Cloners),Outward issue link (Problem/Incident),Outward issue link (Problem/Incident),Outward issue link (Problem/Incident),Outward issue link (Relates),Outward issue link (Relates)

I have contacted the team supporting the Atlassian Excel app asking if this is something they already know and/or if there is anything in their roadmap related to this issue. If not, I will proceed opening a bug request for this issue.

I will let you know as soon as I will get a reply on this.

Cheers,
Dario

[Dario B]

Prashant.shastri@centurylink.com 

Can you kindly provide a screenshot of what you get when you export the field "issue links" to Excel?

Also, as a temporary workaround you could use the export to CSV functionality and open the csv file with Excel. Not sure if this would be a viable option for you.

This is how it looks when I export the issue results to CSV and I open the file with LibreOffice (I don't have Excel since I am on Linux):

Cheers,
Dario

[Dario B]

Prashant.shastri@centurylink.com 

One last thing, I have created the below bug ticket to have this issue fixed:

• [API-238] Exporting the Linked Issues field to Excel only returns a list of issues keys without any info on the kind of link

Please vote for the above bug ticket and set yourself as a watcher so that you will be notified in case of any update/progress. The bug will be addressed according to the Atlassian Cloud bug fixing policy.

Cheers,
Dario

[Prashant.shastri@centurylink.com]

Dario,,

Thanks for creating the ticket...I have been using the JQL reports extract as a workaround you said earlier for a while but the challenge is as people add / remove the Linked Issue types the columns of the reports are dynamically increased or decreased. Anyway that's another issue. The Atlassian plug-in is very handy but I don't see Link-Type attribute to select from the list of fields available.

If they can expose more fields that will be awesome.

Thanks once again for all your help

~ Prashant

[Dario B]

You are very welcome Prashant.shastri@centurylink.com ,

Please remember to set yourself as a watcher for the ticket so that you will be updated in case of any progress or change.

Also, since I believe this question has been addressed for the time being, you may want to accept my answer in order to mark this thread as answered. 

Have a nice day!

Dario