CSV file format for custom attribute valid values and descriptions

You can use a comma-separated value (CSV) file to define a list of valid values and their descriptions for custom attributes that are assigned to specific types of assets. Only custom attributes of type String can use the CSV file to import the value-description pairs.

Syntax

The following syntax rules govern how to correctly define values and their descriptions.

Columns and column headings

Do not use column headings.

Use only two columns:

The first column is for custom attribute values. This field is mandatory.
The second column is for a description of the custom attribute value. This field is optional.

Special characters and language support

Commas: A comma (,) is the only accepted delimiter.
Quotation marks: Quotation marks are required around the entire text if the text includes non-alphanumeric characters, such as mathematical symbols or commas.; If quotation marks occur in the text, they must be enclosed within quotation marks (" " ").; The quotation marks (') are not valid and the row is ignored during import.
Language support: The import file must be in UTF-8 or in ANSI encoding to be compatible with all languages.; You can type the values and their descriptions in any language.

Multiple values for a custom attribute

Use a semicolon (;) between the values. Put brackets ([]) before the first value and after the last value.

The following examples use correct syntax for a custom attribute with multiple values:

["red, white, blue"; "red, white"; "red, blue"; "white, blue"]
[yes; no; "n/a"]
[Day count basis; Deferred fees; Final maturity date]