Log export

Log export configuration

Log Export dialog

param

Enable log exporting

Check this field to enable the log export module. The log export module stores DNC-Max activity logs in either an Excel spreadsheet or in a database

param

Log storage

Use this field to select the data source that should be used to export activity logs.

To store activity logs in Microsoft Excel or Microsoft Access, just select the appropriate entry from the list. To export data to any other database (like Microsoft SQL server), you must first define a system ODBC Source and then select the source from this list.

param

Log database/filename

Use this field to specify the spreadsheet/database name.

When exporting logs to Microsoft Excel or Microsoft Access, this is the name of the file used to store the information.

When exporting to a database (ODBC source), this is the name of the database used.

To store activity for each port in a different file/database, include $PORTNAME or $PORTGROUP in this field.

To store activity for different time periods (days/weeks/months) in different files/databases, include on or more of the $DATExxxx variables.

Example: To store weekly reports for each port in a separate table/worksheet, specify $PORTNAME-$DATEYEAR-$DATEWEEKNO

Table/worksheet names cannot contain spaces.

When exporting logs to Excel or Access, DNC-Max will automatically create the specified file if it does not exists.

When exporting to any other data source, DNC-Max assumes that the specified database exists. It is therefore not recommended to use a database name that includes environment variables.

param

Real name (example)

This field shows an example of the specified table/database name, after expanding environment variables.

param

Log table/worksheet name

Use this field to specify the table/worksheet name.

To store activity for each port in different tables, include $PORTNAME or $PORTGROUP in this field.

To store activity for different time periods (days/weeks/months) in different tables/worksheets, include on or more of the $DATExxxx variables.

Example: To store weekly reports for each port in a separate table/worksheet, specify $PORTNAME-$DATEYEAR-$DATEWEEKNO

Table/worksheet names cannot contain spaces.

param

Real name (example)

Use this field to specify the table/worksheet name.

To store activity for each port in different tables, include $PORTNAME or $PORTGROUP in this field.

To store activity for different time periods (days/weeks/months) in different tables/worksheets, include on or more of the $DATExxxx variables.

Example: To store weekly reports for each port in a separate table/worksheet, specify $PORTNAME-$DATEYEAR-$DATEWEEKNO

Table/worksheet names cannot contain spaces.

param

Template file

Use this field to specify a template file for the Excel file/Access database