| **Navigation:**  [[templates.htm|Templates]] > Guide to all Templates > Extension Templates >====== DbAuditing ====== | [[tplextensiondatetimedisplay.htm|{{btn_prev_n.gif|Previous page}}]][[templates.htm|{{btn_home_n.gif|Return to chapter overview}}]][[tplextensionformvcrcontrols.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

The DbAuditing template is a global extension used to track updates to specific data tables. This extension is added to the global properties of an application.

The DbAuditing template provides the following prompts:

**Log Files**

This tab contains a list box that lets you define log files and options for the files used in an application. Add a new log file definition by pressing the **Insert** button. This displays a dialog where you name the log file and define its contents. Use the {{c6h0058.jpg|C6H0058.jpg}} and {{c6h0059.jpg|C6H0059.jpg}} to change the order of the log files.

**File to Log**

Choose a file from the drop list that consists of all files defined in the dictionary. Any updates to this data file are written to its associated log file.

**LogFile Name**

Specifies the name of the log file to update.

**Username Logging**

The username logging option is used to track which user is making the update to the specific data file. It does this by adding an extra column to the log file for the user's login name.

**Username variable**

Specifies the variable which contains the current user. The value of this variable gets written to the log file to indicate the user who made the change to the data file.

**Username Header**

Specifies the header to be used in the log file for the user column.

**Username picture**

Specifies the format to be used for the user column in the log file.

**File Fields to Log**

This option gives the ability to customize a log file for each data file. For example, you may wish to log changes to certain fields and allow changes to others without logging them. Press insert to select a field to write to the log file. Use the {{c6h0060.jpg|C6H0060.jpg}} and {{c6h0061.jpg|C6H0061.jpg}} to change the order that the fields are logged to the log file.

**Field**

Specifies the field name for the data that is writen to the log file.

**Field Header**

Specifies the header to be used in the log file for the data column.

**Field Picture**

Specifies the format to be used in the log file for the data column.

**Miscellaneous Fields to Log**

This option gives the ability to customize a log file for miscellaneous data. Press insert to add a field to the log file. Use the {{c6h0062.jpg|C6H0062.jpg}} and {{c6h0063.jpg|C6H0063.jpg}} to change the order that the miscellaneous fields are logged to the log file.

**Field**

Specifies the field name for the data that is writen to the log file.

**Field Header**

Specifies the header to be used in the log file for the data column.

**Field Picture**

Specifies the format to be used in the log file for the data column.