There are several log and other options to control your exporting process. Most of the options are available either from GUI or in the command line mode. For command lines, there are some additional log parameters.

GUI Options

When you are finishing your data export preparations, there is a step where you can specify optional export logs and error handling options.

Please note that using detailed logs can slow down the exporting process for large datasets. We recommend to use record logs only for debugging (i.e. to find erroneous data etc.). Anyways, this step can be skipped.

Record Log

Log file - Specifies the name of the file to write export log of detail (record) level. Available when exporting one table or query.

Log expression - Specifies expression which result will be written to log file for each exported source record.

Append log entries - If you select this option, and the log file already exists, the log will be appended to the end of the file; otherwise the existing file will be overwritten.

Bad Record Log

Log file - Specifies the name of the file to write export problem log of detail (record) level. Available when exporting one table or query.

Log expression - Specifies expression which result will be written to the log file for each erroneous source record.

Append log entries - If you select this option, and the log file already exists, the log will be appended to the end of the file; otherwise the existing file will be overwritten.

Error Handling

On error - Specifies how export errors are processed. Possible values:

Stop

The exporting process is stopped when an error occurs.

Stop on critical error count

The exporting process is stopped when the error count reaches the critical level. Works for errors of record level only.

Ask

If an error occurs, a dialog is shown, allowing user to stop or continue. Works for errors of record level and target file creating errors.

Ignore

If an error occurs, it is ignored and the process tries to continue with the next record (or next table, if error occurred on table level during multi-table exporting). Not recommended.

Skip table

If an error occurs, current source table is skipped and the process tries to continue with the next table. Only for multi-table exporting.

Default value: Stop.

Critical error count - Specifies the critical number of errors, required to stop the exporting process (when the corresponding error handling option is set).

Command Line Options

All above-mentioned GUI options have their equivalents when exporting data from command line. Please read about /RecordLogFile, /RecordLogExpression, /AppendRecordLogFile, /BadRecordLogFile, /BadRecordLogExpression, /AppendBadRecordLogFile, /ErrorHandlingType, /CriticalErrorCount command line parameters.

In addition, you can use /LogFile and /AppendLog parameters, which add a log of upper level (not detailed) to your exporting process. These additional options are especially useful when exporting data from command line in silent mode.

See also

 Command Line Usage