• Products
  • Get started
  • Documentation
  • Resources

Create attributes and references from your data

Assets in Jira Service Management is a Premium and Enterprise only feature. Learn more about Assets.

To import data into Assets in Jira Service Management, you must first create an import structure, and then you must map the data into Assets using object type mapping.

Next, you can map attributes from the data using object type attribute mapping. Additionally, if you want to create references in your object schema you can use object type attribute mapping and placeholders to map these references into Assets.

Before you begin

  1. You must prepare your data for importing into Assets.

  2. You must create an import structure.

  3. For each type of object that you want to map in Assets, you must create an object type.

  4. For each attribute or reference that you want to map in Assets, you must create an attribute.

 Create attributes from data using object type attribute mapping

  1. From your service project, go to Assets > Object schemas.

  2. Select an Object schema.

  3. Select Configure, then choose the Import tab.

  4. In the Import tab, select on Edit mapping on your import structure to view the object type mappings.

  5. Select Edit attributes mapping to view the attribute type mappings.

  6. Every object imported into Assets will require at least one piece of information - the data source field that lets Assets know where to find objects in the data source. Learn more about the data source field.

    1. Select a Data source field. The data source field specifies the location of the objects in the data file. Your attribute mapping will be disabled until you supply a data source field for each mapped attribute.

    2. Select a Destination attribute to map to the data source field.

    3. Optionally, you can modify the default settings for this attribute mapping:

      1. AQL - enter an AQL statement here to create references from data.

      2. Concatenator - enter an alternative concatenator here that applies only to this attribute mapping.

      3. Regular expression - enter a regular expression here (regex) that applies only to this attribute mapping.

      4. Base 64 - enter an alternate Base 64 value here.

  7. Select one of the attributes as an identifier. An identifier uniquely identifies each object, and will become that object’s new label when it is created. You must have exactly one identifier to run your import. The identifier is also important when you are updating data - any object with the same identifier in the destination schema will be updated, while objects with identifiers not found in the destination schema will be created.

  8. Click Add, at right.

Create references from data using object type attribute mapping and placeholders

  1. From your service project, go to Assets > Object schemas.

  2. Select an Object schema.

  3. Select Configure, then choose the Import tab.

  4. In the Import tab, select on Edit mapping on your import structure to view the object type mappings.

  5. Select Edit attributes mapping to view the attribute type mappings.

  6. Every object imported into Assets will require at least one piece of information - the data source field that lets Assets know how to differentiate objects in the data. Learn more about the data source field.

    1. Select a Data source field. The data source field specifies the location of the data in the import configuration.

    2. Select an Assets Attribute to map to the data source field.

    3. Use the Object Mapping (Assets Query Language (AQL)) column to enter AQL that maps the label of the reference to a placeholder for the data locator.

      1. If you are mapping only one reference from the data, enter Label = ${Locator} where Locator is replaced by the name of the Locator.

      2. If you are mapping multiple references from the data, enter Label IN (${Locator${0}}) where Locator is replaced by the name of the Locator.

      3. Click Add, at right.

If you want to create multiple references from a single field in your data source, use double pipes “||” (CSV or JSON format) or a comma “,” (JSON format only) to separate multiple values.

How to import data into Assets

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

    1. Prepare your data.

    2. Create an import structure. There are four different types of import available:

      1. Discovery. Learn more about how to bring data from Discovery into Assets.

      2. CSV. Learn more about how to configure your CSV for importing.

      3. JSON import. Learn more about importing data from a JSON file.

      4. External import. Learn more about how to develop an app to import data into Assets.

    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