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

[Shambhu5]

Hi,

Why are you using a script here? You are trying to map User table emp_ID with your Templates' Prsn_no and then setting active as true, is my understanding right?

Also, I can see 2 fields in your excel as Prsn_no & emp_Id, these are 2 seperate entities which should be mapped seperately in user table.

- Vishrut

[swethaa]

yes, correct.

[Shambhu5]

Hi,

So just map them seperately in Transform Map. Map your Prsn_no with Target tables employee_number OR vice-versa. Why script is there, I still don't get that.

Is there any special requirement you are trying to achieve?

-Vishrut

[Ct111]

Hi sujithap,

The  script given by you is for wrong field it is for Business Unit(Target Field) and your code should be in Active(Target Field)

     Moreover , I feel that somewhere in code you have done something wrong

Q1) if you are comparing  pers  with employee_number  in addQuery     then what is the use of  empid that you are obtaining from  excel.

Please, confirm and revert back .