Customize default common import options

Format of imported fileDefault format; be aware that this list depends on location (database, table) and only SQL is always available	csvdocsqlldisql
Character set of the file	iso-8859-1iso-8859-2iso-8859-3iso-8859-4iso-8859-5iso-8859-6iso-8859-7iso-8859-8iso-8859-9iso-8859-10iso-8859-11iso-8859-12iso-8859-13iso-8859-14iso-8859-15windows-1250windows-1251windows-1252windows-1256windows-1257koi8-rbig5gb2312utf-16utf-8utf-7x-user-definedeuc-jpks_c_5601-1987tis-620SHIFT_JIS
Partial import: allow interruptAllow interrupt of import in case script detects it is close to time limit. This might be a good way to import large files, however it can break transactions.
Partial import: skip queriesNumber of queries to skip from start

Customize default options

SQL compatibility mode	NONEANSIDB2MAXDBMYSQL323MYSQL40MSSQLORACLETRADITIONAL
Do not use AUTO_INCREMENT for zero values

Customize default options

CSV
Replace table data with file
Do not abort on INSERT error
Columns terminated with
Columns enclosed with
Columns escaped with
Lines terminated with
CSV using LOAD DATA
Replace table data with file
Do not abort on INSERT error
Columns terminated with
Columns enclosed with
Columns escaped with
Use LOCAL keyword	autoyesno

Customize default options

OpenDocument Spreadsheet
Column names in first row
Do not import empty rows
Import percentages as proper decimals (12.00% to .12)
Import currencies ($5.00 to 5.00)