Insight Documentation - Version 8.7 > CSV Import > importCSV.png 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 from

Choose 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

File

Choose 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

You can set a password when you create a CSV import configuration.

If you then come to edit your CSV import later, the password field will be disabled. If you want to edit the password, you have to check the Change value checkbox provided adjacent to the Password field as shown in the screenshot below.

Insight Documentation - Version 8.7 > CSV Import > Screenshot 2020-06-01 at 15.32.20.png

To save your edited password, make sure you keep the Change value checkbox checked until you click on the Next button. If you uncheck it accidentally, the password field is disabled again with its original value retained and the newly entered password will not be saved.

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

Name	Description
Selector	The 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.