How can I push the Values from an Excel Sheet, automatically into Jira Custom Fields?

Dennis Pajak

Hello Everybody!!

I have several Excel sheets in which contains information like material number and description etc. If I now enter the material number in a custom field, I want the rest of the custom fields to be filled automatically from the Excel sheets.Is that possible?

My Plug Ins are: Script Runner, Insight, JMWE

Thanks for your help:)

Ravi Sagar _Sparxsys_

Hi @Dennis Pajak 

You have few options.

Convert Excel to CSV and use ScriptRunner

Convert the Excel to CSV and you can write a Groovy script to update those issues in Jira. It again requires Groovy skills. The CSV file should be accessible by Jira.

Create Insight Schema (probably a better solution)

You can store this Material Number and other details in an Insight schema and create am Insight field instead of normal field. So based on the material number you can see other details. This is proper asset management and you can import your Excel files into this Insight Schema.

I hope it helps.

Ravi