Bring Data Manager objects into a schema in Assets

Data Manager (or Assets Data Manager) is a feature for Assets Cloud Premium and Enterprise that enables you to connect to multiple data sources, and then cleanse and reconcile this data and ensure it is Complete, Current and Correct.

You can bring Data Manager objects into a schema in Assets by using the import feature in your schema in Assets to connect to a Saved Search in Data Manager.

To import objects from Data Manager into Assets, you need to be logged in as a Jira admin or schema admin in Assets AND have Data Manager admin access:

1. Go to Assets, then Object schemas.

2. Select an Object schema.

3. Select Schema settings, then choose the Import tab.

4. Under the Import tab:

   1. Select Data Manager import

5. In the Define import structure screen:

   1. Enter a Name for this import structure (Required).

   2. Enter a Description for this import structure.

   3. Select a Saved search to import from the list of saved searches that you have created in Data Manager.

   4. Select either:

      1. Enable Automatically create object types and attributes to automatically create object types and attributes based upon the information retrieved from Data Manager.

      2. Disable Automatically create object types and attributes if you want to manually create object types and attributes for this import structure, or import into an existing structure.

   5. More options – modify the default values here to change how Assets will deal with delimiters, encoding, empty or unknown values, concatenation, and date formats.

      1. Empty values – When an object is updated, choose if empty values from the external source should remove the existing value. Select from:

         1. Remove – remove the current value. If the attribute is a status, select, or reference type attribute with more than one value, all of the values will be removed.

         2. Ignore – keep the current value for this object type. If the attribute is a status, select, or reference type attribute with more than one value, all of the values will be kept.

      2. Unknown values (required) – If a Status or Select attribute receives a new and unknown value from the file, choose if the import should add these values to the options for that attribute or ignore them.

      3. Data Manager Values - this section contains options that are only available when importing from Data Manager:

         1. NULL values - If a NULL value is imported from Data Manager, choose if the existing value should remain unchanged, be removed, or be updated to a literal NULL value in Assets (an empty string).

         2. NOT MAPPED values - If a NOT MAPPED value is imported from Data Manager, choose if the existing value should remain unchanged, be removed, or be updated to NOT MAPPED in Assets (A string that contains “NOT MAPPED”).

         3. Values with Compute issues - If a value is imported from Data Manager that is found in the list of Computed Issues, choose if the existing value should remain unchanged, be removed, or be updated to the new value.

6. Select Create.

7. The Imports tab should now be populated with your new import structure. To import data into Assets you must now run the import.