Revert Massive update

[Gaug]

Hello.

Accidentally I did a massive update assigning all the Prospects/Potential Clients and Accounts to one user, I wonder, is there any way to revert this massive update and reassign them back to the users that had them? I guess its possible, since theres a way to see the summary of changes and there you can see the old value before it was changed, I mean the user that had the Account, so it saves it in another place in the database. I hope you can help me.

Thanks in advance.

[rafael.q.g@hotmail.com]

I don't know if there is some automatic way to do it, but if I was in your situation I will try to do the following:
1. The easiest thing is if you have a database backup (normally we have it daily) then you could take the old values from your backup and assign to your current database fields.
2. If you have no backup is possible that in tables that is named with "_audit" the old values keep stored (it works just for fields marked as auditable=true). Then you could write some code to recovery the values from this table and update your current records.

Maybe someone else has some other solution.

[andopes]

If you have some good SQL knowledge you can do that in 1 or 2 hours.
SugarCRM stores informations about updated fields in <table_name>_audit, and assigned_user_id is an auditable field.
You can look for all records updated by Mass Update, identify the previous assigned user and do the update by sql query.

Best regards

[Gaug]

I did that taking the values from the "_audit" tables, thanks a lot!