How To Create and run custom Scrips in Jira

[Michael Sproch]

I am a new user to Jira and very basic on OOP but have written Java in the past. My question is more from an interface with Jira, and where and how to write scrips. In my situation we are using Jira as a engineering management tool to ensure drawings are being review and acted on appropriately. In our system we will need to extract data from a pre-formatted Excel Sheet which tells us which drawings are coming. So I was going to extract data from the excel sheet into Jira Tasks. I know that Jira uses SIL and we are looking at purchasing JExcel Pro. There are tons of documents explaining the various functions, classes, ect that are created so I know what I want to do but I can't figure out where to start editing code. Also, is there a role above Admin?

I am sorry that these are probably very basic questions, but I have mostly worked with C code and OOP in a new system is not clear to me.

Thank you in advance.

[Krister Broman [Advania] · Accepted solution]

If you want to execute code in Jira you need to use one of multiple apps that adds that functionality. Some options: 

SIL Groovy Connector (as you mentioned SIL): https://marketplace.atlassian.com/apps/1220177/
Scriptrunner (one of the most used apps for scripting): https://marketplace.atlassian.com/apps/6820/
MyGroovy (is a free app): https://marketplace.atlassian.com/apps/1218755/

There are more, just search on the marketplace if these does not suit your needs. 

However, if you are looking to add external excel files then you might want to write that as an external function that fetches the data from the excel files and then use the rest interface to add the data into Jira https://developer.atlassian.com/server/jira/platform/rest-apis/ 

[Michael Sproch]

Krister Broman, 

Thank you for the feedback. I will start looking into those.

Regards,

MS.