Hi everyone,
We are doing some database cleanup and I have a very long list of constituent ids that need to be merged into one keep id (old tnew guest checkout records with no identifying info on them). I know I can inactivate all of these records,but people would rather they be merged. Has anyone done a bulk merge in SQL? I'm having some trouble when I test it out in Test, and if anyone was willing to share some code, I would be eternally grateful. (we're on 15.0.3).
thanks,Kathleen
Dear Kathleen,
Happy to share the code we use for merging TNEW guest accounts!! If you give me your e-mail address, I will be happy to send it over.
John
ksmith@intrepidmuseum.org
Much appreciated!
Hey John,
Could I grab that script from you as well? I’ll be doing some similar hygiene projects in the Spring.
enash@2st.com
Please and thank you!
May I get a copy too, please?
lgrim@gettysburgfoundation.org
Thanks!
Hi John,
May I get it too please? martin.keen@nida.edu.au
TIA!
Martin
I would like to see this as well. tnelson@smm.org
I would be interested in this as well John if possible! derrek.bentley@humanrights.ca
John A. Moskal II Thank You me too...
tgbrown@lsc.org
Can you please send that script over to me as well? Thank you!
cwink@georgiaaquarium.org
Best,
Colette
Could you please share this with me as well?
jessica.jelinek@houstonsymphony.org
Thank you!
Hi John, Hoping I can get on the ban wagon here! martellar@perthconcerthall.com.au Thanks!