Jira Insight, importing with CSV linking to multiple object types

[Alex McKerron]

Hello,

I was hoping for advice regarding importing from a CSV file.  I am attempting to import this object as a Server object type which I have created. Currently I also have Make which is the parent object type and model which is it's child. Model has a reference to make as an attribute.  I have created matching objects for my example make and model.

Server Object Type attributes:

Name | Default | Text

Created | Default | DateTime

Updated  | Default | DateTime

Make | Object | Make

Model | Object | Model

Model Object Type attributes:

Name | Default | Text

Created | Default | DateTime

Updated  | Default | DateTime

Make | Object | Make

My CSV file looks like this.

ServerName, Make, Model

Server1, "Cisco Systems", CATALYST 3750

My CSV import configurations is as follows.

Import from: File

Empty Values: Ignore

Unknown Values: Ignore.

Concatenator: -

Date Format: dd/MMM/yy

My object type mapping  is as follows.

Filter data source by IQL: No Value

Missing objects: Ignore

Missing objects outbound references: Ignore

Empty Values: Ignore

Unknown Values: Ignore

Match Identifier: Case insensitive

Data Locators

Identifier:True | Data Locator: ServerName  | Insight Attribute: Name

Identifier:True | Data Locator: Make  | Insight Attribute: Make | IQL: Name = ${Make}

Identifier: True | Data Locator: Make, Model  | Insight Attribute: Model | IQL: Name = {Model} AND Make.Name = ${Make}

 **EDIT** I have also tried using the IQL mapping "objects having outboundReference(Name=$Make}) AND Name=${Model}"

With all this I am unable to have the import successfully link to both the Make and the Model. Currently it is successfully linking to Make but not model. I get a reference to Make but Model is not linking.

Any advice you could give would be greatly appreciated, please let me know if anything above is unclear.

Thanks Alex