Skip to end of banner
Go to start of banner

Import Data Specifications

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


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.

 CSV 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:

"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"
 CSV 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

  • No labels