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.