Database Custom Field : changing the content of the CSV resource file

[Stéphane Genin]

Hi,

I want to use a CSV file to populate a dropdown list custom field.

I would like to know if the dropdown list is populated only when JIRA starts, or if it is automatically synchronized with the CSV content if a new CSV is copied on the server.

Thanks

Stéphane

[Alexandru_Iacob · Accepted solution]

Hi,

You can connect a database field to a CSV file like any database source, using the text tables feature of hsqldb, as described here: http://confluence.kepler-rominfo.com/display/DBCF/Retrieving+Data+From+CSV+files

As long as you keep the same name and location to the csv file configured in the datasource, as well as same column names, you can make any change in the file and they will be reflected in the database field.

Kind Regards,

Alex