| Navigation: Templates > Guide to all Templates > Extension Templates >====== DbAuditing ====== |    |
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 
and 
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 
and 
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 
and 
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.