how to change a text field to a statable field

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
Larry Brock Community Champion Oct 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!

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)

Larry Brock Community Champion Oct 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
Community showcase
Published Feb 13, 2019 in Jira Service Desk

What's new in Jira Service Desk Server: Introducing 4.0 & more - Feb 2019

Hello Atlassian Community!  I'm Teresa, the Product Marketing Manager   for Jira Service Desk Server at Atlassian. I'm excited to announce two exciting releases for Jira Service De...

387 views 1 1
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you