Handling usernames in Sandbox copy.

Related products: None

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

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

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

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.

@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.

Terms & ConditionsCookie settings