How to import Insight references in CSV?

Tim_7i2tz0

I have an object type with two references defined like this:

The color and shape objects are simply:

Using the following as input:

ashape,acolor,anobject,number
Square,Blue,Widget SB,1
Circle,Blue,Widget CB,1
Square,Red,Widget SR,1
Triangle,Green,Widget TG,1

I'm unable to populate the two reference type attributes using this import configuration:

The color and shape object types populate objects as expected, but the objects added to the Widget type does not import the referenced fields.  I'm assuming the Data Locator is the CSV column heading and that it should match the locator in the Object mapping IQL.  No errors are reported.

 

Thanks,

-tim

Björn Gullander

Hi,

Try IQL mapping Name = ${ashape} 

Name is the attribute in the Shape object type you want to use to find the matching Shape object. 

label = ${ashape} should also work but without the plural s in labels. 

And likewise Name = ${acolor}