Reference 360

Back Next

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.

Open a code list.

Optionally, filter code values or search for specific code values in the code list.

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.

Click

Export Values

The

Export

dialog box appears with a warning message indicating that you check the formatting of the exported file.

In the

General

section, enter a file name.

To export the parent code value for each code value in the hierarchy, select

Include hierarchy

This option is available only for hierarchical code lists.

To export the display attributes of the code list, select

Include Display Attributes

To 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

You can export the last updated date of parent relationship and last updated user of parent relationship attributes only for hierarchical code lists.

In 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.

Optionally, 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.

Optionally, 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.

Click

Export

, and then save or open the exported file.

The exported 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.

Rename Saved Search

Table of Contents

Reference 360

Reference 360

Exporting code values

Exporting code values