Export Images from Jira to csv/excel

Question

Dear experts ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Greetings!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have a query on jira export to csv, when I export jira Tickets to csv , using export to csv as below:-The Tickets are exported properly in csv/excel, but the images used in those Tickets(description, analysis) are shown as below:-&nbsp;I did some Google on this , it says we need to create some kind of scripts for this..Could you please guide me on how to achieve this or if any such script already existing?&nbsp;Thanks in Advance,Br,Anupam&nbsp;

jkpieterse · Answer

If you know the path to that image file so you can build the full URL of the image, you could use the IMAGE function in Excel to pull in the images.

anupambit1797 · Answer

Thanks JKPieterse , I tried that image function , but getting below Err.

Atleast , it should ask me for like my user/pass so that it can fetch the image.. but showing "Blocked"

Thanks in Advance,

Br,

Anupam

peiyezhu · Answer

I am afraid the url is not valid.Can you see the image by visiting the url by Edge browser?

anupambit1797 · Answer

Hipeiyezhu , yes I can..example:-https://jiradc.ext.net.nokia.com/secure/attachment/3096722/image-2024-10-10-08-03-28-131.png&nbsp;&nbsp;Br,Anupam&nbsp;

jkpieterse · Answer

Perhaps this discussion gets you somewhere? https://techcommunity.microsoft.com/t5/excel/blocked-images/m-p/3721687

Forum Discussion

Export Images from Jira to csv/excel

7 Replies

Resources