Object schema import

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

You can import structured data from an Assets object schema, such as Object Types, Attributes, and Objects. You can also import data from another schema on the same server, or from an object schema on an entirely different server. More about importing

Some use cases could be:

  • Synchronize two different servers, each running a different object schema.

  • Create a staging instance containing a subset of the full data from an object schema.

  • Synchronize data between a master server and a set of child servers that contain a subset of the full data.

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

Skip to:

Before you begin

Here are some additional details that you might need to know to import an object schema:

  • This import type doesn’t include your schema's automation rules, roles, import configuration, object history, object comments, reports, and object-issue relations.

  • Because of the possibility that the two synchronizing servers might contain objects with the same name, to prevent an object collision, every object imported from another server is assigned an External Hash Key as an attribute. This hash key is built by appending the URL, schema ID, and the object key to create a longer, unique hash.

Importing object schemas

When you configure a new object schema import to retrieve assets from another instance or from the same instance, the import process regularly synchronizes to keep the data up-to-date. Assets will copy all object types and create mappings automatically.

To create an Import structure:
  1. From your service project, go to Assets, then Object Schemas.

  2. From the Object Schemas list, select More actions and then select Configure.
    Configure an object schema window

  3. In the Schema configuration view, open the Import tab.

  4. Under the Import tab:

    • If there’s no import structure, you’ll see the message “You don't have any import connections yet”. Select Create Import configuration to create a new import structure.

    • If an import structure has already been created, select Create Configuration.
      Create import configuration window

  5. Select CSV import, then select Next.

  6. Fill in the General, Module, and Scheduling import fields.
    General fields of the import configuration

General fields

Here are general fields, common for every import type:

Name

Description

NameThe name of the import.
DescriptionThe description for your convenience.
Concatenator

You can specify a default concatenator. When joining multiple data locators into one Assets attribute, this will be the default concatenator. One example could be to join two columns like "First name" and "Last name" into one attribute. So "Mathias" (first name) and "Edblom" (last name) will be concatenated as "Mathias Edblom" if using \s as concatenator.

Enter \s for space-concatenated. To include a concatenate character, place the value between double quotes (i.e "\s").

Empty Values

Defines what should happen when a Data Locator is empty:

  • Ignore - the existing value in the object will be retained and not overridden by an empty value.

  • Remove - the existing value for the object will be removed, and replaced with an empty field value.

Defines what should happen if a Data Locator is unknown. This could happen with attribute types like "Status" and "Select". 

  • Ignore - the value from CSV will be ignored and the object attribute will be left empty.

  • Add - the value passed in the CSV file will be added to the list and the object attribute will be updated with the new value.

Format for date fields in import source to convert dates into Insight. If left empty, Insight will automatically try to find correct format. 
The format should be specified according to the Java SimpleDateFormat guidelines.

Format for date/time fields in import source to convert dates into Insight. If left empty, Assets will automatically try to find correct format. 
The format should be specified according to the Java SimpleDateFormat guidelines.

Module fields

These fields are specific to an import type (module).

Setting

Description

URL

The URL of the server that is running Jira with Assets.

UsernameThe username for authentication with the other server.
Password

The password for authentication with the other server.

Object SchemaThe Name or Object Schema ID for the target server.

Scheduling fields

Scheduling fields are responsible for keeping your data in sync:

NameDescription
Synchronizing Account

The Jira user to use when synchronize data into Assets.

For LDAP and database imports, the account used for synchronization must have Jira admin permissions.

Cron ExpressionThe interval for the automatic synchronization.
Automatically SynchronizeIf the import should be scheduled for automatic synchronization.

7. Select Save Import Configuration.

Next, you can create a predefined structure and configuration for your import.

Pre-defined structure and configuration

In the next step, you can create the predefined structure and configuration manually or Assets can create them automatically. To make this process automatic, select:
  • Create predefined structure – this will create object types with attributes and relationships in the schema

  • Create predefined configuration – this will create type mappings in the import configuration.

Create predefined structure and configuration window

Additionally, for the object schema import, the predefined structure and configuration will be based upon the existing configuration of the target Assets object schema. Some object type mappings might be disabled by default. Ensure that all object type mappings are enabled.

Import configuration created

You can now view your import configuration, but it's not ready yet. You still need to map any object references or attributes between your source and Assets.

When you're ready, go to 2. Create object type and attribute mapping.

Before you go

Object type mapping

In the next step, you'll create the object mapping settings. Here are some settings specific to the object schema import type.

Name

Description

Selector

The data locators are only available if you’ve indicated a Selector for the object type map. The Selector should be <objectTypeName>;<objectTypeSourceId>

For example, if your <objectTypeName> is “Server” and <objectTypeSourceId> is “205”, your Selector would be Server;205.

Last modified on Dec 30, 2024

Was this helpful?

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