Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

how to change a text field to a statable field

Laura Scott October 10, 2017

I want to change a text field to a statable field to use the field in statistic type for a gadget.  

1 answer

1 vote
LarryBrock
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 10, 2017

Found this answer in a similar question. It wasn't the Accepted answer but it doesn't require any Add-on and  I believe it's applicable here:

This method can be used without any add-ons or plugins tested on JIRA OnDemand (Cloud). Also note you can probably use excel format for import but I prefer CSV. I tested this first by creating 3 issues before updating live data, I would suggest you do the same to become comfortable with the process. JIRA Administrator rights are needed for this method.

  1. Go to Search for Issues in JIRA.
  2. Identify all the issues you wish to update.
  3. Adjust the columns to show your summary, issue key, and field with values(Due) to use.
  4. Click export and select a format, for this example Excel (current fields).
  5. Clean up the file, removing unnecessary columns, and everything but the header and data rows (export adds extra rows of footer/header content).
  6. Go to JIRA Administration drop-down and select "System".
  7. On the left pane under the heading "Import and Export" select "External System Import".
  8. Choose CSV.
  9. Choose file and select your CSV.
  10. Select your project. Note you may need to adjust date format at this step.
  11. Map your fields. You must have issue key and summary!
    1. Issue Key (CSV field) => issue key (JIRA field).
    2. Summary (CSV field) => Summary (JIRA field).
    3. Field to use values (CSV field) => Field to update values (JIRA field). In my case it is "Due Date" => "Original Due Date".
  12. Click next and it will perform the update and indicate the result.

Hope this is helpful and if it is, please click the Accept check-mark - thanks!

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 11, 2017

In case this is not 100% clear, it is not a "change" to the field, it is extracting the current data from it, and re-importing it into a new field that you will need to create (choose a select list instead of text)

LarryBrock
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 16, 2017

Thanks Nic and you're right that one cannot change the field, only move the data to a new one (then remove the old one if appropriate).

Laura - Do these posting answer your question?  If so, please click the "Accept as Solution" button so others know it does.  Thanks!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events