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:
- Do it in Jira. Jira already has exports to Excel, so you can simply click on those and get the data you need. It's a simple generic export, so you'd need to manipulate it after download, or write something in Jira that includes your business rules and does the more complex stuff for the end-suer
- Do it in the target system. In this case, that sounds like Excel. In which case, your best bet probably is to brave the horrors of VBS because that's embedded in it already and you can probably write something that can get the data from Jira and do all the work. When I say "get the data from Jira", I don't know if VBS in Excel can fetch data via REST (which is the best way to do it), process an XML or RSS feed (which is a pretty good way to do it), or simply trigger the Excel export I mentioned above and add all the stuff you need to it there.
- Use an external system to pull and push. Pull from Jira (ideally via REST), push to the target system using whatever that can use to import data. This frees you up from "what language is supported where" and you can write it in whatever you want.
In other words, the "possible options" are pretty much "you can do what you want, as long as it supports interaction with both systems"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.