How to change all emails in Acumatica

Hello everybody,

today I want to leave a post on how to change all emails, which are contained in Acumatica. For this purpose you may use script below:

UPDATE contact SET    email = email + '.ts'

UPDATE socontact SET    email = email + '.ts'

UPDATE apcontact SET    email = email + '.ts'

UPDATE pocontact SET    email = email + '.ts'

UPDATE crcontact SET    email = email + '.ts'

UPDATE arcontact SET    email = email + '.ts'

UPDATE fscontact SET    email = email + '.ts'

UPDATE crcasecontacts SET    email = email + '.ts'

UPDATE crcontact SET    email = email + '.ts'

UPDATE pmcontact SET    email = email + '.ts' 

If you wonder, what can be the usage of such SQL, consider following scenario. You've restoed from back up some database. And you need to see if Automation schedules work fine. How can you do it without deletion of all of them and spamming of all customers of your customer? The only way would be updating emails in your database.

If you know any other table that contains e-mails which I've missed, let me know, I'll update this SQL script accordingly.

No Comments

Add a Comment