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.
Note: Based on the filter or search criteria, Reference 360 displays only the matched code values without listing the related code values for hierarchical code lists.
3Click Export Values.
The Export dialog box appears with a warning message indicating that you check the formatting of the exported file.
4In the General section, enter a file name.
5To export the parent code value for each code value in the hierarchy, select Include hierarchy.
This option is available only for hierarchical code lists.
6To export the display attributes of the code list, select Include Display Attributes.
7To export the metadata of the code list, select Include Metadata Attributes.
You can export the following metadata attributes:
- Last updated date
- Last updated by user
- Created date
- Created by user
- Last updated date of parent relationship
- Last updated by user of parent relationship
Note: You can export the last updated date of parent relationship and last updated user of parent relationship attributes only for hierarchical code lists.
8In the Values included in export option, select one of the following options:
- All. Exports all the code values in the code list.
- Currently displayed. Exports only the filtered set of code values or specific code values based on the search results.
9Optionally, 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.
10Optionally, click Columns, and then select the attribute columns that you want in the exported file.
For example, you might want to only include the Name and Code attribute columns for code values.
11Click Export, and then save or open the exported file.