How to copy a custom field definition, changing field type but keeping the allowed values

Amir Katz (Outseer)

I defined a custom field, Customer Name, of type Select List (single choice), and defined, manually, 140 values for the choice.

I need to define another custom field, Other Affected Customers, with type Select List (multiple choices) using the same list of 140 values.

What I see is that once a custom field is defined, you cannot change its type, so this rules out the option of copying the first field to a new one.

Any idea? Thanks

Amir Katz (Outseer)

What I actually did is this (sounds complicated, but it's not):

1. Created the two custom fields
2. Created a CSV file for System Import for first field (Customer Name)
3. Performed a system import, specifying the first custom field, which generates a dummy issue (with key=PROJ-1), and adds all 140 values to the custom field
4. Modified the CSV file to use another issue (key=PROJ-2)
5. Ran the import again, use the modified CSV file, but specifying the 2nd custom field. This adds another dummy issue (key=PROJ-2), and populates the values for the 2nd custom field.
6. Delete the two issues (or mark them as rejected, obsolete, whatever).

 

Note that for cascade select list, the value should be "FIRST -> SECOND" (the single spaces around the '->' are mandatory!)

The import process is explained here: LINK