Usage-Guide.md

Usage Guide

Supported tables

See TablesConfiguration for a full list of supported tables and columns. The list can be customized using this guide.

Adding your tables

If the list of supported tables doesn't meet your needs, you can modify the anonymizer_tables.json file to add your own tables. This file is automatically generated when running the tool for the first time, and can be found in the directory the tool is executed from. If the directory doesn't contain this file, you can run the tool and cancel (CTRL+C) before answering the prompts.

Each record in this JSON file contains the table name, the AnonymizeColumns property indicating which columns to anonymize, and the NullColumns property indicating which columns to set to null:

{
  "TableName": "CMS_UserSettings",
  "AnonymizeColumns": [
    "UserNickName",
    "UserSignature",
    "UserRegistrationInfo",
    "UserDescription",
    "UserSkype",
    "UserIM",
    "UserPhone",
    "UserPosition"
  ],
  "NullColumns": [
    "UserGender",
    "UserDateOfBirth",
    "UserTimeZoneID"
  ]
},

For example, you may want to anonymize data entered in your forms:

{
  "Tables": [
    {
      "TableName": "DancingGoat_ContactUs",
      "AnonymizeColumns": [
        "Name",
        "Email",
      ]
    },
    // Other tables...
  ]
}