Updating fields from a Spreadsheet

Calisa Hughes

We have a server based JIRA setup with Service Desk, Portfolio, Confluence, Software and X-Ray license.  

I would like to develop a project that our facilities management team can use to email external vendors.  

Goal:  

Pass location and issue type (fields in JIRA) to a spreadsheet, SharePoint List or JIRA table (that can be maintained by a non-Admin) and receive back Vendor Name and Vendor Email.

Our issue is we do not want to maintain an ever changing vendor list for the department.

We are new to JIRA and have not written any code or utilized any APIs yet.  Do  you have any recommendations on a plugin that could accomplish this? Even better, do you have any recommendations for a company we could hire to do this simple task for us?

Mikael Sandberg

There are multiple options here, you could use REST API and write your own integration, you could use an external database and a app that uses this external database to populate fields (I use Elements Connect but there are other apps that does the same thing). You could also use Excel Connector to have your facility team update issues directly in Excel and sync it back to Jira. Another option would be one of the many CRM apps available. I have used Insight before, it is not listed as a CRM app, but it can be used as such.

If you want someone to help you with the implementation, I would suggest you contact one of the many Atlassian partners.