I can "Export Issues" via the UI without any issues, but I am attempting to connect to JIRA using the CData JDBC driver.
Testing the Connection Fails:
Error: You are not authorized for this operation
I need to access via JDBC to the same data produced by the Jira.csv file, when select “Export Excel CSV (All Fields)”, I suspect that this data resides in the jiradb.jiraissue table.
Is this a permissions issue?
It is possible with Scriptrunner on a Server install of Jira.
Apology/Disclaimer: I work for Adaptavist, so, of course, it's part of my job to sell Scriptrunner.
There may be other tools that can do this in the marketplace, but I do not know if there are. Because I've got SR "on tap", I have not needed to look.
I do know there are tools that can produce far better exports than the Jira native stuff that SR would just call. I don't know if they could be automated this way.
Without other tools, SR could be used to build a filter, run through all the issues it returns and belt out a csv file, but I do not think this is a good solution.
However, that is very vague. What problem are you trying to solve by having regular exports to CSV? There's a good chance we could suggest a better solution, if we knew what the underlying problem or reporting hole is?
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
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