Import Users, Groups and Group Memberships using Single Import Set

[Kishore47]

Hi Team,

I have an Excel file with the following columns and approximately 300 rows:

• Owners (Users)

• Groups (Group Names)

• Active

Example:

Owners | Groups
User 1 | SSO Group A
User 1 | SSO Group A
User 1 | SSO Group A

User 2 | SSO Group B
User 2 | SSO Group B
User 2 | SSO Group B

User 10 | SSO Group J
User 10 | SSO Group J

Like this, there are approximately 300 rows with duplicate user-group combinations.

I want to achieve the following from scratch using Import Set:

1. Create Users in sys_user (if not exists) — I was able to create successfully using Coalesce

2. Create Groups in sys_user_group (if not exists) — I was able to create successfully using Coalesce

3. Create Group Membership in sys_user_grmember — I am unable to create

4. Avoid duplicate records

I tried using multiple Transform Maps, but group membership is not getting created properly. The Group value is populated, but the User field is empty in sys_user_grmember.

Any guidance or example would be very helpful.

Thanks in advance.

[GlideFather]

Hi @Kishore47 

The cell split into two columns can be done directly in the excel as well. I never remember the formula but google can help.

So it all worked good? 🙏