Skip to main content

Handling usernames in Sandbox copy.

  • April 28, 2021
  • 4 replies
  • 46 views

prathap
Forum|alt.badge.img

Hi Team,

 

In prod users have usernames like "user@xyz.com” But in sandbox they have usernames like "user@xyz.com.invalid" or appended with a keyword.

So when a Sandbox copy is done all the usernames in prod are loaded into Sandbox causing duplicates and all of these should be made either Inactive or usernames should be updated with “.dev”

It will be great if this is handled in the product too which will be very helpful to the users during sandbox Copy.

 

Thanks,

Prathap

4 replies

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • April 30, 2021

@prathap agree with you. What would be the quantity of users(I meanduplicates)? 


soumitrasahu
  • Helper ⭐️⭐️
  • May 17, 2021

@prathap We are looking into this and will give an update as soon as we have designed a solution.


Forum|alt.badge.img+2
  • Expert ⭐️
  • May 17, 2021

Is a solution required?

 

I assume this is a SFDC to MDA sync. If that is the case the issue is you have username selected as your identifier/upsert key. 

 

If it is a full copy sandbox you can simply change the upsert key/identifier to SFDC id, run it  to update the user names, and switch it back. Or leave it as SFD id, there’s no reason not to utilize it instead.


soumitrasahu
  • Helper ⭐️⭐️
  • June 7, 2021

@Wayne The SFDC ID cannot be used as an identifier as it maps to the SFDC ID in the avatar object (an object which is not same as the User object). The avatar object is created when a connection is created with an external system and Users are brought into Gainsight.