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
Since our Test environment has pretty much the same security as our Live environment, we only make limited modifications to it. This also helps users doing testing, allowing them to easily find accounts that they know have interesting features for whatever it is that they are testing.
We did have an elaborate script for mangling PII in our Development environment, when we had one. We moved to RAMP at the same time that we upgraded to v11, and never wound up setting up a Dev after that, so the scripts I have are hopelessly out-of-date (no household handling, for instance). I could dig them up, just to give a sense of all the tables I found PII or potential PII in (back then).
I do have a set of scripts that I run whenever we do a Live->to->Test copy which make a bunch of changes. Mostly these are to configuration variables (so that, for instance, confirmation emails sent from the Test environment are sent from different addresses than they are in Live), TNEW configuration is updated, etc. I also do two things to customer accounts. First, I mangle all of the login passwords in Test (except for customers marked with a "Testing Account" Constituency). Second, to prevent testers from accidentally emailing customers, I mangle all email addresses (again, save those marked for testing). Since our email service is from Google, I take the previous email address, replace the special characters with periods, then add them after a "+" to an internal IT mailing list email address, so that any actual mailing of a customer will come to us for review.