Best Practice for Changing a Field Type

Amanda Jennewein
Amanda Jennewein
  • Updated

Author: Carmen Santos

Updated: June 27, 2024

Audience: Jama Connect® Users

Products Applicable: Jama Connect®

Use Case

Best Practice for Changing a Field Type in Jama Connect®.

Best Practice

It is possible to change the type of a field containing data by replacing it with a new field using the Round-Trip export.


To start, you need to create a new field. Navigate to Admin > Item Types > Select the item type > Add Field to create the new Field.

When creating a different field type, it's essential to consider the kind of data already added to the original Field. For instance, text content cannot be stored in an Integer, as an Integer can only store numbers.

Screenshot 2024-06-27 at 11.21.13 AM.png

After creating the new field, you need to make it visible in the Project List view so that it can be exported. You can achieve this in one of two ways:

1. Navigate to Admin > Item Types > Select the item type > View, then add the field to the list on the right.

Screenshot 2024-06-27 at 11.22.52 AM.png

Alternatively, you can use the "Show/hide fields" option in the List View to make the new field visible only to you.

Screenshot 2024-06-27 at 11.24.37 AM.png

You can find the items you want to change by creating a filter or opening the container. Then, from the List View, open the Export Menu > View all export options: Screenshot 2024-06-27 at 11.25.31 AM.png

Select and Run the Excel Export for Roundtrip:

Screenshot 2024-06-27 at 11.26.02 AM.png

This will generate an Excel export in the Reports history view:

Screenshot 2024-06-27 at 11.26.52 AM.png

Download and open the export in Excel. Then, copy and paste the data from the old field's column to the new field's column.

Screenshot 2024-06-27 at 11.27.24 AM.png

Save the spreadsheet and import it back into Jama Software. Check the Round-Trip box during import.

Screenshot 2024-06-27 at 11.28.17 AM.png

Screenshot 2024-06-27 at 11.28.46 AM.png

This method can be used to update items in all projects, and all items in the import file will be updated, regardless of the selected project for the import. If the new field type is compatible with the imported data, you should see identical data in both field types. Otherwise, the new field will be empty.


After importing the data to the new field type and confirming its success, the old field must be removed to finalize the change. Please make sure to carefully read these important notes before deleting the field. Add, edit, or delete fields.



Please feel free to leave feedback in the comments below.

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Please sign in to leave a comment.