How to download all options of a selection field (simple or cascaded)

[Amir Katz (Outseer)]

I have a cascaded selection field with ~ 40 options, some of them having 2nd-level options (cascaded).

I need to import all the options into a new field on a different Jira server.

The import would be easy - use ScriptRunner built-in script 'bulk import custom field values' - I've done it several times and it works like a charm.

The problem I'm facing how to export the options from the source server into a text file that is structured for the abovementioned script.

I know it's possible to access the Jira database and get the data using a (possible simple) SQL query, but I don't have access to the DB.

[Amir Katz (Outseer)]

Here's a kludgy method that works.

Let's say the field is called Brand-Model and has these options:

• Ford
  • Explorer
  • F150
• Chevrolet
  • Camaro
  • Corvette
• Tesla
• Jeep
  • Defender
  • Cherokee

You do this:

1. Admin -> Custom Fields -> Brand-Model -> Configure -> Edit Options
2. Select all the options with the mouse
3. Copy & paste into a text file
4. Click on Cancel to get out of the Edit Options.

In the text file, you will get this output:

Ford

ExplorerF150

Chevrolet

CamaroCorvette

Tesla

Jeep

DefenerCherokee

Now edit the file in a text editor, indent & separate the sub-options, as required by ScriptRunner:

Ford

   Explorer
   F150

Chevrolet

   Camaro
   Corvette

Tesla

Jeep

   Defender
   Cherokee

Now you can import the options into another field, same server or different one.

[Amir Katz (Outseer)]

But I'm looking for a better solution which will not require editing...