Last year the Export Excel CSV (all fields) allowed me to pull comments for issues. I can prove it because I saved an old export. Granted it was ugly because a if there were 100 comments on any one issue it added 100 comment columns to the export. Still it was better than what I have right now, which is nothing.
Yes, I know that you can export to Word and see comments, but my boss doesn't want a 100-page report. Yes, I know you can export to RSS with Comments, but that's a mess and not presentable to the boss. The boss wants a simple spreadsheet with about 10 columns of data and then to see the comments (typically less than 5 comments per issue) with each issue.
Yes, I know there are marketplace apps out there that will do this quite nicely and we've looked at them. Unfortunately, we only need to make this report a few times each year and it doesn't warrant spending $3000 each year on an app.
So, are there any other ways that I haven't stumbled across to get issue data with comments to Excel for free or less than $500/year?
Try using Skyvia (https://skyvia.com/data-integration/integrate-jira-excel). It’s a cost-effective no-code platform that efficiently handles this task, allowing you to export Jira issues with comments seamlessly.
If you can invest time into that, then develop a script that gets the issue and its comments from the corresponding REST API endpoints, and compiles a spreadsheet from those.
It costs time (it isn't extremely complicated though), but no money.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm not a developer. My time is money from both my perspective and my employer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.