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_ · Accepted solution]

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

[Dennis Pajak]

Hi Ravi,

thanks for your help!

Insight is a good idea for that, thanks!

Maybe you can help me with my other question too! That would be awesome:)

Best Regards,

Dennis