Populating a DBCF field from CSV

[salman_kagzi]

Is there any way to populate a custom field of type select using a CSV?

Basically what I have is an excel file (which can be easily converted to CSV or something similar) from which I want to populate a Select list. Based on the value selected, I want to populate 2 other fields (read only). The DBCF Field gets me very close to this. But instead of having to query a database can I look up values from a CSV file available on the Jira server?

[Alexandru_Iacob · Accepted solution]

Take a look at this page, which describes how to retrieve data from CSV files using Database Custom Field and the text tables feature of hsqldb:

http://confluence.kepler-rominfo.com/display/DBCF/Retrieving+Data+From+CSV+files

Kind Regards,

Alex

[Maria Cirtog]

Hello Salman,

At the moment a database custom fied can be populated only from a database. The workaround would be to import your file into a database table and use that database to configure the database custom field.

Maria