1.how to add a 100 users at a time to group.

saikrishna mail
Tera Contributor

how to add 100 users   at a time to group? its possible?How?

12 REPLIES 12

Deepa Srivastav
Kilo Sage

First save user details in CSV or xls format file only...Give the Column name as Group and User.


find_real_file.png
Then Goto Load data.Choose option of create a new table and create a temp table..Then Load file and click on sumbit.


find_real_file.png
Click on "create Transform Map" .Then choose target table as sys_user_grmember table and click on automap matching fields.


find_real_file.png


After that click on tranform ...


find_real_file.png


Let me know if you face any other issue.



You can check transform history in Transform History of transform is complete.



Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.



Thanks,


Deepa


Thanks Deepa It's very useful . it's working correctly, Regards Satya

santy1
Giga Contributor

Hi Sai,



Alternative way is....



Go to the table(in list view) where you want to add records. Rt-click on any of the fields and select "import" as shown below.


test1.png



Then click "insert" and attach your excel file(in xls or csv) as shown below and select preview imported data.


test2.png


The uploaded data will be displayed and if it is as you expected then click 'complete report" else click "back".



Navigate to your table and check for updates.



Note: Field names in excel should match with the table.



Thanks & Regards,


Santhosh.





Pls Hit/like based on the impact.