• Products
  • Get started
  • Documentation
  • Resources

Prepare your data for importing into Assets

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

To ensure that Assets 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 Assets attributes with multiple cardinalities), you can use “||” (2 pipe characters) within the CSV file.

  • If you wish to join multiple values into one Assetsattribute, 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 Assets, 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 Assets, you must identify the users or groups by their IDs, not their Name(s).

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

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 Assets 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 Assets, 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 Assets, 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 Assets Discovery files

Assets 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 Assets 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 Assets 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 Assets

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

    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 Assets object types

        2. Using object type attribute mapping to create Assets 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