• Products
  • Get started
  • Documentation
  • Resources

Prepare your data for importing into Insight

Insight in Jira Service Management is a Premium and Enterprise only feature. It is compatible only with company-managed projects. Learn more about Insight.

To ensure that Insight can understand your data it should follow some basic specifications. These specifications are different for each data type. Some attribute types may also require specific formatting to be properly imported.

Importing CSV files

  • You can use any of the following formats: UFT-8 (default), UFT-16, ISO-8859-1, ISO-8859-15, Windows-1250, Windows 1252.

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

  • 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.

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

  • If you wish to join multiple values into one Insight 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.

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

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

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

1 2 3 4 "Name", "Owner", "Service Category", "Hosts" "Confluence", "Ellen McDonald", "Finance", "Oracle-E-Business-Server" "Email Service", "Bea Owenstein", "Infrastructure", "exchange.prod.main1"||"exchange_mssql_2012" "Partner portal", "Les Weinen", "Infrastructure"||"Marketing", "mysql.prod.app7"

Importing JSON files

  • JSON files that are imported into Insight must have properly formed headers and follow JSON standards.

  • The selector for the JSON import must be in the format [Attribute.*[Attribute]. Only JSON arrays are valid as a selector.

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

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

Here’s some sample JSON information that contains 3 hosts:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 { "Hosts": [ { "Name": "exchange.prod.app7", "Status": "Running" "Environment": "Production", "Server Owner": "Bea Owenstein", }, { "Name": "exchange.prod.main1", "Environment": "Production", "Server Owner": "Ginger Rogers", }, { "Name": "Mail Server", "Environment": "Production", "Server Owner": "Bing Crosby", } ] }

Importing Insight Discovery files

Insight Discovery is a network scanning tool that can be used with or without an agent. It detects hardware and software that is connected to your local network, and extracts detailed information about each asset. This data can then be imported into Insight in Jira Service Management to help you manage all of the devices and configuration items within your local network.

  • If you are importing data from Insight Discovery, it must be in the correct ZIP file format.

  • You are not required to specify a date pattern in the Create Import configuration - General fields screen, but specifying a date pattern may result in improved performance:

    • Example date pattern: dd/MM/yyyy

    • Example date/time pattern: dd/MM/yyyy hh:mm

Next steps

  1. Create an import configuration.

  2. Map your data into Insight. There are two options:

    1. Map your data automatically, using a Predefined structure and configuration, or;

    2. Map your data manually:

      1. Use object type mapping to create Insight object types

      2. Use object type attribute mapping to create Insight attributes and references

      3. Use child object type mapping to create hierarchical parent and child structures.

  3. After you have created your object type mappings you must enable them. The import configuration will not be executable until all object type mappings are set to ENABLED. Right-click on your object type mapping and click Enable to enable the new object mapping(s).

  4. Execute the import.

 

Last modified on Apr 13, 2021
Cached at 8:59 PM on Jun 12, 2021 |

Additional Help

Ask the Community