When you add a new drop-down or multi-select ticket field, you may have a large number of field values to include. For example, a new field that lets agents choose a software version or product type might include hundreds of choices. Rather than add field values manually one at a time, you can add many field values in a bulk import. You can also export ticket fields and values to archive or use in other applications.
Creating the CSV field value file
Before you import, create a CSV (comma separated values) file that contains the ticket field values you want to add to a new ticked field. You can download a template CSV file and use it as a model for adding your own field values. See example below.
The following table lists the fields to include in the file. The first row of the CSV file is the header row, and you must include it in the file.
|value||Value that appears in the drop-down or multi-select field.|
|tag||Tag associated with the field value. The tag is used as a ticket property that can be included in triggers and other business rules.|
|default||Identifies the default value for the drop-down or multi-select field. Use true to identify the default value. Use false for all other values. (Drop-down fields only. Remove this field for all other field types.)|
When you create a list of field values to import, you'll probably generate this list of values from some other ticket or product management system. Most of these systems have some facility for creating a CSV export file. If you need to create the list from scratch you can use a program like Microsoft Excel or Google Sheets.
The file must be properly formatted CSV and saved using UTF-8 character encoding. The import CSV data file must contain no more than 3,500 rows of data (one row for the header and the rest for the field values).
Importing the CSV field value file
After you create the CSV file, you can import these values into a new ticket field.
- Navigate to Manage > Ticket Fields to display a list of ticket fields.
- Click Add Field.
You can only bulk import values for new ticket fields. You cannot import field values for existing ticket fields.
- Choose the type of field you want to create (Drop-down or Multi-select).
You can only import field values for drop-down or multi-select fields, CSV import for other types of fields is not supported.
- In Field values, click Upload CSV.
- Click Choose File and open the CSV file you want to import, then click Upload.
Note: If you prefer, you can Download the template CSV file to use as a model to prepare your CSV file before you upload it.
- When you successfully upload the CSV file, Field values are updated to include the new data.
- Finish adding information about your new field, then Save your changes. For more information, see About Ticket Fields.
Exporting ticket fields and values
As your list of ticket fields and field values expand, you may find it useful to export ticket fields and values to a CSV file. For example, you may want to use the CSV file as a checklist to verify that the latest product types or software versions are available for your tickets.
- Navigate to Manage > Ticket Fields.
- Select a Drop-down or Multi-select field.
- In Field values for the ticked, click Download CSV to export a list of values in CSV format.
See example below.
To export a list of ticket fields:
- Navigate to Manage > Ticket Fields.
- Click the download icon (next to the Add Field button) to export a list of ticket fields in CSV format.
The exported file includes the following information for each ticket field: Title, Field ID, Field Type, and Date (when the field was last modified). See example below.
The file is ready to open in spreadsheet applications, like Microsoft Excel or Google Sheets, for further processing.Note: Before exporting, you can update the ticket fields list by filtering results or changing columns (adding, deleting, sorting). Only the columns and fields that appear in the list are exported.