Hello,
We'd like to scrub our copy-down so that it no longer contains personal information. We don't want to lose data as it is good for training and development; however, we want the personal information to be removed. Are there any conversion scripts we can utlize.
Thank you,
Lou Ann
Thanks for replies and the offer Gawain. Having a Testing constituency or attribute is a good idea. For a procedure I was thinking:
1) stripping login, emails, and phone
2) modifying everyone's address to be same fake one
3) mangling names and salutations
4) running credit card deletion utility (not worrying about pledges as cc's are tokenized)
Depends on your usage: you'll not be able to run operations in Test that look at logins and emails, or anything where you are looking at different addresses in bulk (i.e. reporting on zip code). I guess I think that wiping those things completely could make it harder to build and test reports, new criteria or utilities. That's why I generally favored mangling, and in the case of addresses mangled out unique addresses and kept the City/Zip untouched.
Are you a RAMP client? Your credit cards will be wiped automatically. This will also, I'm pretty sure, wipe out tokens, including tokens used by pledges.
For the dev mangling we used Customer Number, so
First Name: F[Customer #]
Last Name: L[Customer #]
Street 1: S1[Customer #]
etc.