I am performing easy import on custom table , issues with reference field

[Mishu]

I am performing easy import on the custom table, but the string field from Excel' u_owner' is not getting mapped to the reference field 'Owner' on the target table. It is mapping the other fields but the owner field just does not get copied and leaves blank.

Need Urgent help on this. 

[Mishu]

@Amit Gujarathi -- I am doing it through easy import ,I have not created any transform map for this, where I am supposed to write this?

[Amit Gujarathi]

For this scenario it will be pretty easy if you do it with load data and transform map

[Tai Vu]

Hi @Mishu 

It's important to ensure that the input value for the string field 'u_owner' in Excel aligns with the "Reference value field name" specified in the Field Map.

Example:

In this scenario, 'u_owner' should be populated with the user's email address.

If you can provide more information about what was your input for the u_owner column and how you configure for the field map, it will be easier to figure it out.

[Mishu]

I am setting the reference value fieldname but with every easy import, it becomes empty again

[Tai Vu]

Hi Mishu,

I can see that you set the "Reference value field name" as "app_owner".

I believe that the 'app_owner' field is a reference field to the User table. So the "Reference value field name" should be the field name from the User table, which match incoming source values to existing records in the reference field's source table.

What type of information you put into the app_owner column in excel file? User's Email, Name or Display Name or User ID?