468151 - Should be a way to populate large numbers of legal values for a custom field at once

Status: NEW

(Bugzilla :: Administration, task, P2)

Description

[Kent Rogers [:mrbball]]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.12) Gecko/20071126 Fedora/1.5.0.12-7.fc6 Firefox/1.5.0.12
Build Identifier: Bugzilla/3.2

It would be very useful if there were a mechanism to populate a custom
field with all valid values at once.

If a custom field of type "Multiple-Selection Box" or "Drop Down" is
added to Bugzilla and there are large quantities (i.e. hundreds) of
legal values, adding them one by one in the standard admin interface, as
described in section 3.11 of the Bugzilla Guide, can be prohibitively
time consuming.  But, that is the only "official" mechanism available
for getting the values into the database.

There is obviously the option of going directly to the database, but
there is no guidance in the documentation for doing that and it is
unclear whether any considerations need to be made other than simply
adding the values/sortkeys to appropriate cf_<field_name> table.


Reproducible: Always

Comment 1

[Frédéric Buclin]

Makes sense.

Comment 2

[Max Kanat-Alexander]

For what it's worth, yes, all you have to do currently is add them directly to that DB table.

Comment 3

[Max Kanat-Alexander]

By the way, the solution to this is probably allowing people to enter a newline-separated list in a textarea, and just giving them successively higher sortkeys as we insert them. This should be particularly easy to do now that we have Bugzilla::Field::Choice.