I'm looking for JIRA batch script support to get tickets information that are open, search them for key words, sort them, extract certain fields from the tickets and put it in a file that can be imported into Excel, and create an Excel spreadsheet with a Pivot table containing the information from the tickets.
I think scripts can be written to create and manipulate Microsoft Office files (Excel, Work, etc.). The most common language to do this is Visual Basic, but I would like to know what options there are. Ideally I would like to use Python, Please let me the possible options.
This one is a little hard to give a firm answer for.
You've not defined where you expect this to run, so we can't really advise you on the best way to do it. To make that decision, your best bet is to ask what is best for your users.
To explain this, you've got three basic routes here:
In other words, the "possible options" are pretty much "you can do what you want, as long as it supports interaction with both systems"
Hi Nic Brough, My requirement is I would like to be able to create a program or script that will create JIRA reports. I will use this to get daily reports on certain tickets and metrics on certain classes of tickets. Having a program that can be scheduled automatically is essential so that I do not have to open JIRA in a web browser and create the reports before I can look at them.
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