How to import multiple object types in a single import configuration in Assets

Summary

This article details steps to import multiple object types in a single import configuration/file.

Example

Based on a CSV Import file similar to the example below:

Using the single import file, you would like each object to be imported to its relevant object types.

Solution

1. Create an object schema to which the objects will be imported.

2. Configure the object schema with the object types layout as intended.

3. On the object schema, configure the relevant attributes for each object type where objects from the CSV file are to be imported. Make sure to add an extra attribute (Type) to map the object type; this is required for the import to filter the object type accordingly.

4. Create a new import configuration with mappings for every object type to import objects into.

5. On the Create Import configuration screen, under Define import structure, disable the Automatically create object types and attributes option.

6. For each object type, configure the mapping for each of the attributes. Map the 'Object Type' data source to the 'Type' attribute created in Step 1.

7. For each of the object type mappings, set the Filter data source by IQL to the relevant object type.

8. Once the import is correctly configured, start the import.