Reference 360 > Manage code values > Exporting code values
  

Exporting code values

Export code values in a code list to a CSV file. You can configure the format of the data and the attributes that you want to include in the exported file.
    1Open a code list.
    2Optionally, filter code values or search for specific code values in the code list.
    After you filter the code values, Reference 360 displays the complete hierarchy of the matched code values for hierarchical code lists.
    Note:
    Reference 360 displays the attributes that you selected in the column settings as filters.
    3Optionally, to view the code values at a point in time, select the date and time using the calendar or enter the date and time in the Point in Time field.
    4Click Export Values.
    The Export dialog box appears.
    5On the General tab, enter a file name.
    6To export the parent code value for each code value in the hierarchy, select Include hierarchy.
    This option is available only for hierarchical code lists.
    7To export the display attributes of the code list, select Include Display Attributes.
    8To export the metadata of the code list, select Include Metadata Attributes.
    You can export the following metadata attributes:
    Note:
    You can export the last updated date of parent relationship and last updated user of parent relationship attributes only for hierarchical code lists.
    9In the Values to Export option, select one of the following options:
    10Optionally, configure how you want the data to be formatted in the file that you export.
    Field
    Description
    Delimiter
    Character used to separate values.
    Date Format
    Format used for dates.
    Decimal Mark
    Decimal separator used for numbers.
    Thousands Separator
    Grouping separator used for numbers.
    11If you export the code values to back up attribute data before enabling the multilingual property, select Prepare for Localization in the Localization section.
    When an export file isn't prepared for localization, you have to manually add the Language field and its values to the export file.
    For more information about using the exported file for import, see Import multilingual code values into code lists.
    12Optionally, click Columns, and then select the attributes to include in the exported file.
    For example, you might want to only include the Name and Code attributes for code values.
    13Click Export, and then save or open the exported file.
The export file displays internal field names based on the attribute names that you defined. For more information about internal field names of attributes, see Step 2. Define the structure, attributes, and display settings of code lists.
In the exported CSV file, the number of rows is based on the number of target languages, and the file includes the _language and _localizedContent fields. During import, the import process automatically maps the _language and _localizedContent fields.
The following table lists a sample exported CSV file that includes _language and _localizedContent fields:
_language
_localizedContent.Name
Code
Description
status.status.key
effectiveDate
en-US
Female
F
Identifies a person as female.
18-06-2025
pt-BR
Feminino
F
18-06-2025
en-US
Male
M
Identifies a person as male.
18-06-2025
pt-BR
Masculino
M
18-06-2025
en-US
Unknown
U
Indicates that the gender is unknown or not specified.
18-06-2025
pt-BR
Ignorado
U
18-06-2025