Download View PDF Documentation

Transcript
Table Action
The action to take before starting the import:
Confirm Create New Table The table is recreated on every import. If the table
already exists the table will be deleted after confirmation by the user.
Create New Table The table is recreated on every import. An existing table will be
deleted (dropped).
Record Action
The action to take upon storing a record:
Insert The record is appended to the end of the table.
Output Field Names
If set to True the field names are stored in the first row in the output table.
HTML File
Creates a HTML file that contains the output table.
Requirements: None.
Limitations: Only Create/Append and Insert are supported as Table and Record actions.
Property
Description
Output File
The name of the output HTML file.
Table Action
The action to take before starting the import:
Confirm Create New Table The table is recreated on every import. If the table
already exists the table will be deleted after confirmation by the user.
Create New Table The output file is recreated on every import. An existing output
file will be deleted.
Append to Table If the output file exists the new table will be appended to the
file, otherwise a new file is created.
Record Action
The action to take upon storing a record:
Insert The record is appended to the end of the table.
Output Field Names
If set to True the field names are stored in the first row in the output table.
Date Format
Sets formatting for numbers. See Date and Numeric Format Strings for detailed
specification.
Numeric Format
Sets formatting for numbers. See Date and Numeric Format Strings for detailed
specification.
MySQL Database
Connects to MySQL 4.1 or later, no external drivers are required. For MySQL 4.0 or earlier use the ODBC output
in combination with the MySQL ODBC driver that can be downloaded from www.mysql.com.
Requirements: None.
Property
Description
Database
The name of the MySQL database.
Table Name
The table where the imported data is stored.
Table Action
The action to take before starting the import:
Append to Table If the table exists new records will be appended to it, the table
structure is not modified not even if the import model defines other fields than exist
in the table. If the table does not exist it is created.
Confirm Create New Table The table is recreated on every import. If the table
already exists the table will be deleted after confirmation by the user.
Create New Table The table is recreated on every import. An existing table will be
deleted (dropped).
Empty Existing Table If the table exists it all records in the table will be deleted
before the import starts. If the table does not exist it will be created.