Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Insight: import reference object seems not working

Xavier
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2018

Hi all,

I have a strange behavior when importing data on an Insight Object :

I have 3 Insight Objects Type with attributes (I follow this tips, but not working https://documentation.riada.se/display/ICV50/Import+Concept+-+Object+Type+Reference) :

Person
   Name (text, Label)
   Address (text)
   City (Object "City")
   Gender (Object "Gender")
   Father (Object "Person")


City
   Name (text, label)

Gender
  Code (text, Label)

I fill City and Gender with data (same As Import SQL result)

On import settings, I put this:
Object : Person

Data Locator     Insight Attribute     Object mapping (IQL)
Name                Name
Address             Address
City                    City                        Name=${City}
Gender              Gender                   Code=${Gender}
Father                Father                     Name=${Father}

 

I have no IQL error message, and I know this working before I change the label (And empty "Person" data).

So, starting from an empty "Person" Object Type, I launch the import, and Only Name, Address are fill. 

I have no data for City, Gender, and Father, except of course when I go directly to Object and update the value.

My SQL Query retrieve City like on "City" Object, Gender like "Gender" Object...

 

Where I failed on my settings ?

 

Thanks in advance.
Regards,

 EDIT : 

Ok, I change my IQL with Label=xxx for all, and it works.

regards,

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events