This plugin supports anonymization of all types of personal data using all-purpose transformations. These transformations always work, but you may loose the syntax, format or structure of the original data.
To keep anonymized data closer to the original, the plugin also provides data specific transformations for common types of personal data:
- email address
- person name
- nickname
- nicename (WordPress specific data type)
- phone number
- age
- birthdate
- IBAN (bank account number)
- street address
- city
- URL
- IP address
- HTTP agent
All-purpose transformations
- One value
Fills a table column with one value as defined by you, the same for all rows. - Empty
Fills a table column with empty values for all rows. - Random characters
Fills a table column with different random characters per row. - Random digits
Fills a table column with different random digits per row. - Random pattern
Fills a table column with different random digits or characters per row according to a pattern. Example:###-aa/#generates123-fj/4. - Lorem ipsum
Fills a table column with a lorem ipsum text fragment with a random number of words per row.
Special transformations
These transformations are crafted for specific data types and create different values per record.
- Email pattern [Enterprise Edition]
Generated an email address per row according to a pattern.
A pattern likef[.]l[@test.]dgenerates values asmia.garcia@test.virtualvortex.nebula - Consistent email [Enterprise Edition]
Each existing email address in the database is transformed to one anonymous address consistently (across all occurences of that address in the database). The new address is generated according to a pattern.
When the transformation has completed, the mapping of the real address to the anonymous address is deleted so that anonymous addresses cannot be traced back to the original ones. - JSON / Serialized Array Key specific [Enterprise Edition]
JSON and serialized data are processed as arrays with keys per database row. With this transformation you can choose a specific transformation per key. - Random email
Generates an address like[name]@[domain].[extension]per row using a predefined list for fake domains and extensions and random characters for the name. - Copy user_email
If you have a table that contains the WordPress user id, this transformation copies the corresponding value of user_email in the WP users table. It requires that user_email has been anonymized in a previous step. - Derive user_nicename from user_email
Derives the value for the column user_nicename from the column user_email in the WP users table. Requires that user_email has been anonymized in a previous step.
This transformation keeps those related columns in the WP users table consistent. - Username from email
Derives the username from the email address in the same table row. Requires anonymization of the email address first. - Random full name
Generate a full name per row combining random selections from predefined lists for first and last name. - Full name from user table
If you have a table that contains the WordPress user id, this transformation generates a full name combining first name and last name copied from the WP usermeta table. It requires that those columns in the WP usermeta table have been anonymized in a previous step.
This transformation helps to keep related records in separate tables consistent. - Random nickname
Generates a nickname per row using a random selection from a predefined lists combined with random characters. - Random first name
Randomly selects a first name per row from a predefined list. - Random last name
Randomly selects a last name per row from a predefined list. - Random phone number
Generates random digits combined with predefined characters and digits per row. Example:+1 ##-####-#### (###)generates+1 59-6291-5282 (302). - Random_age
Generates a random age per row with a specified minimum and maximum. - Random birthdate
Generates a random birthdate per row derived from a random age with a specified minimum and maximum. - Random IBAN
Randomly selects a non-existing International Bank Account Number per row from a predefined list. The format and checksum are valid. - Random street name
Randomly selects a street name from a predefined list. - Random street name and house number
Randomly selects a street name from a predefined list and combines this with a street number per row using a specified pattern. Example:###-a sgenerates627-d Fake Street. - Random city list
Randomly selects a city name per row from a predefined list. - Random URL
Generates a URL likehttps://www.[domain].[extension]/[path]per row using a predefined list for fake domains and extensions and random characters for the path. - Random IP address
Generates a random IP address per row in the so called local range from10.0.0.0to10.255.255.255. - Random agent string from list
Randomly selects an agent string per row from a predefined list of fake entries. - JSON / Serialized – Empty array values
Sets an empty string for all values in a JSON or serialized array per database row. - JSON / Serialized – One array value
Sets one specific string for all values in a JSON or serialized array per database row.