CSV file format to import information asset values
You can create a comma-separated value (CSV) file to import or to change property and custom attribute values of information assets.
Syntax
The following syntax rules govern how to correctly define values. The CSV file must contain
values for assets of only one asset type.
Tip: To ensure the correct syntax, go to the
Browse page of the asset type that you want to export. Select all assets on the
page so that the CSV export file contains a full amount of context, properties, and custom
attributes. Click Export Asset Values, and then save the CSV file to your
local disk. Use that export CSV file as a guide to syntax.
Note: Assets
imported by using a CSV file are case-sensitive. It means that for example Business Labels
number
and NUMBER
are treated as two distinct labels, not
one.- Asset type begin and end
- The first row must contain the name of asset type. For example, +++ Database Table - begin +++.
- Columns and column headings
- The second row contains the column headings. Column headings are required. They are case-sensitive.
- Multiple values for a property
- If a property has multiple values, type the values in this format:
- 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]
- Special characters and language support
-
- Commas
- A comma (,) is the only accepted delimiter between columns.
- Quotation marks
- Quotation marks are required around the entire text if the text includes non-alphanumeric
characters, such as mathematical symbols or commas. For example,
"red, white, blue"
. - Language support
- The import file must be in UTF-8 or in ANSI encoding to be compatible with all languages.
- Comments
- Rows that begin with #REMARK are treated as comments and are ignored.