This documentation is for Insight for Server/Data Center only.

This import type will import objects into Insight with a CSV file that holds the data to import.

Some use cases could be:

  • Still using Excel and need greater support for impact analyses?
  • Having CSV files for all of your IT assets and need more transparency?
  • And so much more...

Import Type Fields

This are the module type specific fields needed to be configured for this import type

Setting

Description

Import fromChoose if you want to import from an uploaded file or if you want to import from a URL

URL

Protocol, Hostname and Port of where to find the external CSV file. Example: http(s)://example.com/file.csv or file:///opt/csv/example.csv

FileChoose from your uploaded files (or upload one file directly). Note that the file will be uploaded to the Jira server and needs to be replaced if new data should be imported.

Username

Optional username for basic authentication 

Password

Optional password for basic authentication

Delimiter

The delimiter used in the file. Enter \t for tab-delimited. 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.

CSV Headers

The CSV file needs to have headers, as they are used to create the data locators for the imports. An empty header value is not allowed.

Multiple values

To divide multiple values (for the Insight Attributes with multiple cardinality), use || (2 pipe characters). This may be changed in the future, for you to define your own divider.


Object Type Mapping Settings

NameDescription
SelectorThe selector for the CSV import is not used. Use IQL to filter any data from the CSV file

Predefined Structure & Configuration

The predefined structure and configuration will be created based on the CSV file present in the configuration. Each column will be created as an Insight attribute of type Default Text and the configuration will be mapped accordingly. The object type created will always be the same.

If you want to have different attribute types created by the import of the data from the CSV file create the predefined structure and then change the attribute types.