I am using JIRA for requirments management.I tried exporting issues from JIRA to excel but the attachments that were linked to the issues are missing.The attachments appear as embedded objects when I do the export to word.
Does anyone know if it is possible to embed attachments in Excel when an export is done or is this a limitation with JIRA? Some people in our company prefer to use Excel as it enables them to filter and sort requirements
Currently not possible yet however there are improvement request being raised related on this requirement:
Please feel free to vote on it to increase its popularity and don't forget to add yourself as watcher to receive any latest updates from the developer and also feedback from other customer as well.
Additionally, you may try a third party plugin called Xporter for JIRA, which export issues/search result to word file/pdf. The demo seems to offer a feature whereby exporting to pdf will also attach the the screenshots containing on the issues.
It's tricky as Excel does not really allow to embed an object in a specific row (may be it is possible, but won't it become a mess with all the images and attachments sitting in an Excel row). If you need an extended functionality for exporting, I would suggest to use the REST interfaces and automate the Excel creation using the Excel interfaces (which is pretty easy with .NET) and generate a custom Excel.
Also note that the current export from JIRA is actually not a valid Excel files rather an HTML file renamed as .xls which is accepted by MS Excel with a warning.
As Renjith pointed out, the Excel fileformat (due to its tabular nature and limitations with embedding) may not be the best choice to support this use case.
PDF View Plugin can do everything you wanted, albeit with PDF documents. This is able to display and embed image type attachments, plus it can embed any other type of attachments!
The PDF format supports the concept of embedding, and the PDF readers handle this really intelligently. You can open the embedded files right in the reader, or even save them for further processing. The JIRA plugin allows exporting all-inclusive snapshots of issues and JQL result sets easily.
I'm not quite sure how to support your "filter and sort" use case, I must admit. I think a better approach could be doing that within JIRA, setting up saved filters and exporting their results. This may be more efficient than massaging the data in Excel.
Read the "embedding attachments in PDF" tutorial, and this is how the result looks in Adobe Reader:
Thanks for your response.We are using JIRA for requirements and need to include Visio diagrams as well as other digrams that are in jpg format.
I work as a business analyst and tend to create and add diagrams to issues.I know that JIRA does not allow you to copy paste images directly into the text boxes.
That is the reason I wanted to know if the attachments can be embedded in excel.Some people in our company also have a preference for using excel so that the can filter and organise requirements.Thanks
With JExcel PRO you can export your issues to Excel (or HTML) with the images, comments and attachments.
Feel free to try it:
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs