Understand importing concepts

Still need help?

The Atlassian Community is here for you.

Ask the community

In Assets, you'll import your data by creating an import configuration, which consists of three elements:

  • Base import configuration
  • Object type mapping
  • Attribute mapping (goes in pair with object type mapping)

Once created, such a configuration keeps importing your data (if synced) from updated data sources, and you can always make edits to it to make it even better. This page will help you understand the parts of your import configuration and the mappings you'll need to create. It's a good start before jumping right into importing your data.

You need to be an Assets Manager for an object schema to create, configure, and enable imports.

Complete import configuration

Here's what a sample import configuration looks like after it's created in Assets. This should help you understand the concepts described on this page:

  1. Base import configuration: That is – from where, and when, will your data be collected. Your data source.
  2. Object type mapping: Target object type for your data. You need to create a separate mapping for every object type that your data concerns.
  3. Attribute mapping: Mapping between the data locators in your data source and Assets attributes. This mapping always goes together with the object type mapping, because these attributes are for your specific, target object type. 
  4. Another object type mapping (collapsed): Another object type mapping. It also has attribute mapping, when expanded. You can have as many object type mappings (and related attribute mappings) in one import configuration as you need.

Import configuration

Creating the base import configuration is the first step you do when you access Import in your object schema. When following the steps, you'll configure the following details:

tip/resting Created with Sketch.

If you'd like to see the import types, available fields for each type, and the predefined structure and configuration, head to 1. Create your import configuration, and choose the import type.

Import types

Import type is the type of your data source. It can be CSV, database, Jira users, JSON, and so on. Depending on which import type you choose, the details you have to fill in will differ.

Import fields

Import fields are fields that define your import type. From simple name and description to concatenators and date formats, these fields will instruct Assets how to treat your data source. Import fields are specific to import types.

Scheduling

Details on whether your data source should be synced on a regular basis to keep the objects up to date. You can always enable it on the ready import configuration.

Predefined structure and configuration

The last step before creating your import configuration will be choosing whether you'd like Assets to create a predefined structure and configuration. These are optional and even if created can be modified after importing your data.

  • Predefined structure: The import module will create an Assets object type structure, together with attributes, based on your data. This will only be available if you haven't created any object type mapping.
  • Predefined configuration: The import module will create mappings between attributes and data locators, AQL references, and any other configuration items. Based on the name of the object type as well attribute names supplied from the import module, Assets will determine which object types(s) that should be added to the configuration. You can use the predefined configuration without using the structure.

Object type and attribute mapping

Assets needs to know where your data is going. Unless you created the predefined structure and configuration and are happy with it, you'll need to create object type and their related attribute mappings. Even with the predefined structure, you'll most likely need to make some edits and reviews.

tip/resting Created with Sketch.

If you'd like to have a closer look at what fields are required when configuring the mappings and what they mean, head to 2. Create object type and attribute mapping.


A pair of object type and attribute mapping

Here's an example of an object type mapping and its attribute mapping. These will always go in pairs.

In the example above, the mapping is specified for the Employees object type. It means that the attribute mapping will import data from your data source to the mapped attributes only for this object type. If your data is for multiple object types, you'll need to create such mappings for every one separately (still within the same import configuration). 

This example is based on a simple CSV file that looked like this:

Source CSV file
Name,Computer
Alex,PC
Sara,Mac

The CSV headers (Name, Computer) are mapped to related Assets attributes (Name, Computer). "Name" was a text field, so it doesn't need additional object mapping (AQL). As for "Computer", it's a reference to another object type, so we used an AQL with placeholders:

<Referenced object type identifier, Label> = {Header from the CSV file where Assets should look for data, Computer}
Configuration steps used to create the above example
  1. Create a CSV import configuration without using any of the predefined structures.
  2. In the Create a new object type mapping dialog, select Employees in the Object Type list and keep the default values populated in the other fields and select Save.
  3. In the Data Locator field of the Identifier row, select Name as that is the required label for this object.
  4. On a new row, select Computer and add the Object mapping IQL Label = $(Computer) or Name = $(Computer)so the import engine can identify the object type mapping and associate it with the label of the Computer object and the items found in the .csv file can be mapped accordingly during the import.
    If multiple computers are associated, modify the IQL to Label IN (${Computer${0}})
  5. Enable and synchronize the import for Employees to fetch the data.

Learn how to create object type and attribute mapping


Importing objects with references

Although importing data for default attributes (text, dates, etc) shouldn't be an issue, it might get tricky with data for objects that have references to other objects. It helps if you have created a structure of object types in Assets, because you know them, and can map them one by one. If you're having problems, see Object type reference for some examples.

Next steps

When you're ready, go to 1. Create your import configuration.

Last modified on Aug 23, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.