nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fetch User Data from Excel and fill into Custom field automatically when user Enter Emp iD only.

Vikrant Yadav

Hi Guys,

Need Help

I have an Excel field on Share Drive containing User details like EmpID , Email , Username etc...

In JIRA i have created the all field with Email, empID , Username etc. In JIRa when User input EmpID only than all other details like username,email get filled automatically picking data from excel. Can you please suggest how can i achieve this. Any solution please

I have scriptrunner plugin installed. Please suggest me all possible solution.

Accepted answers

Vikrant Yadav

Hi @Alexey Matveev @Ravi Sagar _Sparxsys_ @DPKJ @Kristian Walker _Adaptavist_ @Nic Brough -Adaptavist- @Martin Bayer _MoroSystems_ s_r_o__

Can you please suggest.

DPKJ

@Vikrant Yadav I can give you couple of suggestions,

Using ScriptRunner (@Nic_Brough__Adaptavist_ is authority here)
- You can write post functions where you can do some database/file look-up, and fill-in data for remaining fields.
Using custom add-on
- This require some Atlassian development experience
- You can create special custom field type plugin,
- Or you can simply add custom Javascript + API, to allow filling in data in field while editing/creating issue.

I hope this clarify some information.

All comments

Vikrant Yadav

Hi @Alexey Matveev @Ravi Sagar _Sparxsys_ @DPKJ @Kristian Walker _Adaptavist_ @Nic Brough -Adaptavist- @Martin Bayer _MoroSystems_ s_r_o__

Can you please suggest.

DPKJ

@Vikrant Yadav I can give you couple of suggestions,

Using ScriptRunner (@Nic_Brough__Adaptavist_ is authority here)
- You can write post functions where you can do some database/file look-up, and fill-in data for remaining fields.
Using custom add-on
- This require some Atlassian development experience
- You can create special custom field type plugin,
- Or you can simply add custom Javascript + API, to allow filling in data in field while editing/creating issue.

I hope this clarify some information.

Vikrant Yadav

Hi @DPKJ Thanks for the response.

I need this on Create Screen.

Do i need any java script in field description ?

Can you please help me script syntax or any example of the script so that i can modify it accordingly and use. As i am not a developer not much knowledge of scripting.

Thanks

Vikrant Yadav

DPKJ

No, you don't need any Javascript in field description (script doesn't work here).

I can help you with small add-on but might need 3-4 days for this.

Better way for you is to look for options in ScriptRunner using Post functions. I think that will be easier for time being.

Martin Bayer _MoroSystems_ s_r_o__

hi @Vikrant Yadav another solution would be to use Behaviours functionality (field conversion) https://scriptrunner.adaptavist.com/4.3.5/jira/behaviours-conversions.html

which can help you to convert simple text field to field which can be filled with values based on the REST API data.

I agree with @DPKJ that development experience is needed to do this as you need to

read binary file from Share Drive
parse data from XLSX
use data in your custom fields
- insert data to custom field options (and eventually dynamically update them based on the changes in XLSX)
- OR
- implement REST API which will provide values from XLSX file and implement field conversion

I don't know what the use case is. If the list of values in excel file is stable, you can write one time script which will insert values as options of your custom fields. It would not be so difficult, but if you need something "smarter", you will probably need some Atlassian / Java developer.

Julie d_Antin _Elements_

Hello @Vikrant Yadav ,

I see you're looking to fetch user data from an Excel file and populate a custom field in Jira. This is a common need when integrating external data with Jira issues, and I’d love to help you achieve this smoothly!

Did you have a look at Elements Connect for Jira ?

With our app, you can connect your Jira instance to external data sources, including Excel files, and dynamically populate custom fields based on that data. It's worth a try if you want to achieve your goal with less work and an easier maintenance (no scripting)...

Cheers,

Julie

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server