Product Logo

CNS Audit

An Audit Trail Plug-in for FileMaker Pro.


Prepare the database

Creating the CNS Audit Tables

Before CNS Audit can start tracking changes to your database, a few tables need to be created. CNS Audit can do this for you from the CNS Audit Configuration Dialog. Open your database in FileMaker Pro and make sure you log in with an account that has [Full Access] privileges. Next, open the CNS Audit Configuration Dialog on Mac by choosing Preferences from the FileMaker Pro menu, switch to the Plug-Ins tab, then double-click on CNS Audit. On Windows, choose Preferences from the Edit menu, switch to the Plug-Ins tab, and double-click on CNS Audit. In the CNS Audit Configuration Dialog, switch to the Basics tab and press the Create Audit Tables button. A dialog should come up telling you that the tables were created.

Removing Layout Name / Table Occurrence Name conflicts

If your database will be used with any version of FileMaker Pro prior to version 11, regardless of the version of FileMaker Pro you develop with, you will need to prepare it for use with CNS Audit under those versions. In Order for CNS Audit to work properly with versions of FileMaker Pro prior to version 11, there cannot be any Table Occurrences with the same name as Layouts in the database. CNS Audit is capable of keeping track of the fields in the database even if their names are changed, but to do this in versions of FileMaker Pro prior to version 11, it needs to use the FieldIDs calculation function. This function allows for retrieving the Field IDs of all the fields in a specific Table Occurrence, so long as there is not a Layout with the same name as the Table Occurrence. If there is a Layout with the same name as the Table Occurrence, the FieldIDs function returns the Field IDs of all the fields on the Layout instead of in the Table Occurrence. Since all the fields in the Table Occurrence may not be on the Layout, this causes CNS Audit to not see, and therefore not Audit, all the fields in the Table Occurrence.

Unfortunately, when creating a table, FileMaker Pro automatically creates a Layout with the same name as the table. To prepare your database for use with CNS Audit under versions of FileMaker Pro prior to version 11, these duplicate names must be changed. Either rename the Table Occurrence or rename the Layouts. It is probably easier to rename the Layouts because when renaming a Table Occurrence, if the automatically generated Layout has never been manually renamed, FileMaker Pro updates the automatically generated Layout to have the same name as the Table Occurrence. Consider renaming the Layout by adding the word “Entry” to the end. For example, if a Table Occurrence is named Contacts, the associated Layout would be named Contacts Entry. However, this is only a suggestion.

CNS Audit makes it easy to determine which Layouts have the same name as Table Occurrences in your database. Open your database in FileMaker Pro and make sure you log in with an account that has [Full Access] privileges. Next, open the CNS Audit Configuration Dialog. (See the Creating the CNS Audit Tables section above for instructions on how to open the CNS Audit Configuration Dialog.) In the CNS Audit Configuration Dialog, switch to the Basics tab and press the Check for Layout Conflicts button. (Note: This button is not visible when running under FileMaker Pro 11 or above.) If there are any Layouts that have the same name as any Table Occurrences, the plug-in will present you with a list of those Layouts. After renaming those layouts, you can use the Check for Layout Conflicts button again to ensure all the conflicts have been resolved.