How to insert and update the records of user table using import set?

[tyagisu]

Hi,

I need to update the sys_user table. There is a custom field on the sys_user table called "Person ID". I need to update the User IDs based on Person ID and vice-versa. Here are the steps I followed:

1) Loaded Data in xlsx. (source of data is a file)

2) Created a Transform Map.

3) Defined Person ID as the coalesce field.

4) Transformed the map.

But I could only see the new inserts, nothing updated on the existing records.

Does anyone know what could be the reason?

Any help would be appreciated!

Thanks,

Su

[Ankur Bawiskar · Accepted solution]

Hi Tyagi,

Is person ID a unique field on sys_user table? I don't think so. on sys_user table user ID field is unique at dictionary level.

I believe you are trying to do vice-versa. Ideally you should update person ID based on user ID and in this case user ID would be coalesce field.

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[tyagisu]

Thanks, Ankur for your quick reply.

That's it! You are right! 🙂

Thanks,

Su