Key Fixer


Key Fixer is a simple yet powerful program built to mass replace Database keys with new values.  

The first step in preparation for running KeyFixer is to verify that you have a good backup of your database.This is absolutely essential because Key Fixer does exactly what you tell it to do, so any user errors in the CSV generation could theoretically render your database inoperable.

To use Key Fixer, open Enterprise for Windows and navigate to either Processes | Key Fixer | Fix Single Key or Processes | Key Fixer | Fix Batch.

  • Fix Single Key is exactly as indicated: if you have a single field that needs to be changed - a single customer number that happens to be wrong, for example - this is how you do so. When using Fix Single Key, you do not need to generate a CSV. Note that the Old and New Values must match full Macola format - 000000000001 for customer number 1, for example. While useful, this option is far less helpful than fixing a batch.
  • Fix Batch is what you are more frequently going to use as this will allow you to make changes across the database to ensure that you have updated everywhere the old value was referenced. Changing a General Ledger account number, for example, would fit here.
    • The first step here will be to click on the Import Keys button at the top. This will open a new popup that allows you to Generate Sample File (in Comma Separate File (CSV) format) which you can then populate according to your needs.
  • The next step is to populate the above Comma Separated File (CSV) with the Batch Name and Key mappings in it. The easiest way to do this is to create it in Microsoft Excel and then save it as a CSV file. Population of this data presumes familiarity with your Macola database; remember: if you haven't backed up this database already, you're doing it wrong.
  • The Key Fields must be formatted exactly like the would look in a Macola Database. When typing numbers in Excel, it attempts to format them...make sure and put an apostrophe at the beginning to keep it from formatting the number. For example, let us presume that we're going to change a G/L account from 7900 to 7010 in a Macola ES database. Our Excel format would look like this:

After saving your Excel file as a CSV, return to the Import Keys popup (which should still be up unless you closed it), and enter the path to your CSV file. This will import this CSV file and you should get a Import Complete button.

Once the Keys are imported verify that your Batch matches exactly the what you entered into your CSV file. Plugin the first batch id and Tab out of the field:

Clicking Fix Keys will cause Key Fixer to begin replacing Keys. Depending on the size of your database and the number of Keys being replaced Key Fixer could run for a few minutes up to many hours. Repeat this for additional Batches you may have.

One last option that Key Fixer has is under Settings/ Use 'like' instead of 'equal' on key match.

This function when checked will replace all key values that contain the value you specified in 'Key'.

As an example if you said you want to change Cus_No and this is checked it will change the values in every field name that contains Cus_No. If it is not checked it will only change field names that match Cus_No exactly.