• Products
  • Get started
  • Documentation
  • Resources

Jira Automation docs have moved

All content related to Jira Cloud Automation, previously under the Automate your Jira processes and workflows section, have moved to the new Cloud Automation docs.

Go to Cloud Automation documentation | Why did we do this?

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 Insightattribute, 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 three 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 three 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

How to import data into Insight

  1. There are four steps when importing your data into Insight:

    1. Prepare your data.

    2. Create an import structure;

    3. Map your data. There are two options:

      1. Map your data automatically by automatically creating object types and attributes, or;

      2. Map your data manually by:

        1. Using object type mapping to create Insight object types

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

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

    4. After you have created your object type mappings you must enable them. The import structure will not be executable until all object type mappings are set to ENABLED. If your object type mappings are not enabled, right-click on your object type mapping and click Enable to enable them.

    5. Execute the import.

 

Additional Help