JIRA Custom Field value from CSV, JIRA service DESK

Question

Hi Community.

this is my requirement.

I have Custom Fields Site Licence#, Site Name, Address, Zip. I have all these values in CSV.

There are 6000 records. I would like to import all these records to corresponding custom fields. There will be huge performance impact when I import all these 6000 records to each custom field(my feeling).

Is there other way round where we can get the custom field value from external source?

Also when someone select Licence #, it should give me the details of Site Name, Site Address, Site Zip.

JIRA 7.10

Service Desk Project 3.10

unknown · Answer

There are indeed ways to access data from external sources, but 6000 values will surely have an impact in performance.

Have you tought in not using a select list, but a free text field and the call the external data with a post function? Or use some code to call the external source after losing focus.

Also, it should be possible to code a call to the external source after some data has been introduced, for example, 2 characters... I remember seeing this in a customer instance once, and the impact was around 3 seconds to load the data

Gregory Van Den Ham_2hc9n5 · Answer

As a pick list?   I can see why that would load.  Mine is a custom field, but is not a single select list.

Frank_2xwa6x · Answer

@Gregory Van Den Ham Thanks for the replay. My project is similar to your workflow. I have Serial Number(Single Choice) which has 6000 values. Importing 6000 Values is effecting the performance.  It it taking 5 minutes to get the list of Serial Number.