Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


1. Importing CSV files

Valid formats: UTF-8 (default), UTF-16, ISO-8859-1, ISO-8859-15, Windows-1250, Windows 1252.

  • Header. The CSV file must have a header as it is used to create the data locators for the imports.

  • Delimiter. The CSV file must include a single-character delimiter. The default delimiter is, naturally, the comma. You can select a custom delimiter in the Delimiter field when you create an import configuration. To include a delimiter character, place the value between double quotes. To include a delimiter or a double quote character, place each value between double quotes. You can also enter “\t” to use a tab-delimiter.

  • Divide values. To divide multiple values (for the Assets attributes with multiple cardinalities), you can use “||” (2 pipe characters) within the CSV file.

  • Join values. If you wish to join multiple values into one Assets attribute, you can use a concatenator in the CSV file. The default is a dash symbol “-”. If the data is concatenated with a space, you can enter “\s” in the Concatenation field when creating an import configuration.

  • Identifier. If you are importing objects from a CSV file into Assets, you must identify the objects by the attribute that is assigned as a Label, not their Name or Key.

  • Jira users or groups. If you are importing Jira users or groups into Assets, you must identify the users or groups by their IDs, not their Name(s).

  • URLs. If you are importing URLs into Assets they must begin with with http:// or https:// to be converted into the URL attribute type. If the http:// or https:// prefix is not included, they will be imported as the String attribute type.

  • Google Sheets link. If you are importing CSV data from a Google Sheets link, the URL you use must be edited before it will work properly. Remove /edit#gid=0 from the ending of the URL and replace it with /export?format=csv.

Expand
titleCSV Sample #1

Here’s some sample CSV data that contains information about three business services. Note that multiple values for a single attribute are included by separating them with the double-pipe “||” characters:

Code Block
"Name", "Owner", "Service Category", "Hosts"
"Confluence", "Ellen McDonald", "Finance", "Oracle-E-Business-Server"
"Email Service", "Bea Owenstein", "Infrastructure", "http://exchange.prod.main1"||"http://exchange_mssql_2012"
"Partner portal", "Les Weinen", "Infrastructure"||"Marketing", "http://mysql.prod.app7"
Expand
titleCSV Sample #2

Here’s CSV data which I created for my demo CRM/ERP development project. This file I uploaded to populate an empty object schema

2. JSON files