How to dynamically populate custom field with values from excel

Maryam Nadir August 3, 2022

I need help!!!

I am new to JIRA...and I am setting up a new project.... One of the custom fields in my issue needs values to be populated from excel sheet.

I have no clue about how to get this done

I would be grateful if some kind soul guide me on this

3 answers

0 votes
Bharathi
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 5, 2022

Hi @Maryam Nadir,

Since you've mentioned that the list of users in the excel are the employees of your organization, if you need them all to be onboarded to Jira as well, you can check the possibilities of turning on automatic Jira access for all new hires which will in turn onboard them into Jira. This will in turn keep the user base up to date.

The custom field can then be configured as a user picker field which can automatically fetch its values from Jira's user base.

Thanks!

0 votes
Maryam Nadir August 4, 2022

@Nic_Brough__Adaptavist_ I saw you reply in one of the threads. Could you kindly help 

0 votes
Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 3, 2022

Hi @Maryam Nadir 

 

Do you need to add value to custom field in issues or you need to set values for custom field?

For add values in issues you can use csv import - https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

 

Regards,

Seba

Maryam Nadir August 4, 2022

Thanks a lot for your reply!

I need to set values to custom field... like when creating new issues, this custom field should fetch values dynamically from a excel or csv file. 

Laura Campbell _Seibert Media_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 4, 2022

Hi @Maryam Nadir 

Are the values in your Excel/CSV file being regularly updated by people? Or is it just that the list of values is very long? Is that the reason you don't want to add the custom field options within Jira?

You mention fetching the valus dynamically: do you need to set the value of the custom field based on another field? For example, if component is X, set custom field to Y ?

Maryam Nadir August 4, 2022

Yes, you are right...the values of EXcel/CSV gets updated regularly. It basically has the list of employee names of my organisation. 

Radhika Rajendran May 7, 2024

@Maryam Nadir Did you get answer for this? I exactly have the same requirement.

Like Charlotte MacRae likes this
Charlotte MacRae
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 7, 2024

Ditto!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events