Import data into Group Member table

saidarao
Tera Contributor

Hi,

I am trying import date into group member table by using UserId . But i am not getting UserID in transform Map table. how we can achieve it

6 REPLIES 6

Jaspal Singh
Mega Patron
Mega Patron

Hi Saidarao,



Transform map table would be a custom table & you will have to get the necessary fields created. Once done then map it with necessary table.



Refer link Transform maps for better understanding.


saidarao
Tera Contributor

In excel file i have group name, userid . But in group member table   we have group name and user name. Here i want   to map to userid in the exel to group member user id field.



The main problem here is   in the excel file couple of users have same name or some names have spelling mistakes. so i want to map   users to group by using user id.



Is it possible?


There is reference to sys_user table in sys_user_grmember table.


Please map your source table field to user field on sys_user_grmember table.



find_real_file.png



Also, you don't need to create trasnform map to import data in group membership table.


You can use easy import to import date in sys_user_grmember table.




Easy import



Regards,


Sachin


I am not getting   User ID in Target table while doing field mapping in Transform map.... i have userid in source table and i want to map with userid in target table
Screenshot f1-50.png