import data ignored

[swethaa]

Hi All,

We have import data in to our database, there are few records were ignored with this message " Invalid map target u_active does not exist in table ( xxx-table) " . plz help

Thanks,

sujitha

[Ct111]

Hi Sujitha,

Can you give few more details like 

Have you imported data via template (i.e downloaded from create EXCEL template from context menu)

or

Are you importing via Load Data module.

Also can you please check whether any business rule is applied during an insert of data on that table , which checks few condtions and throws this error

"Invalid map target u_active does not exist in table ( xxx-table) "

PLEASE mark my answer as CORRECT if it served your purpose

[swethaa]

Hi,

we have imported excel sheet with user id's through data source for scoped applicatioon.

Thanks,

sujith

[Shambhu5]

Hi Sujitha,

Because on your target table, there is no field named 'u_active', and that is why its throwing such kind of Error.

Also, please check that in your Excel template (source) you have used proper field (having values as 'true' or 'false').

If still this issue pertains, please share field mapping/transform map screen-shot, so that I can help you with that.

Regards,
Vishrut

[swethaa]

Hi vishrut,

the excel shet which we have imported to source table, active field is there but there is no values, it is empty data for this field. by using this source table, we will import only members user id for custom application

here is the snapshot of field map :

when I click on script for u_active target field , here is the script we have written