An action file is a text file which contains a set of Exportizer command line parameters, one parameter per line. Lines with a semicolon at the beginning are ignored as comments. Blank lines are allowed. Such files can have any extension. The file encoding must be ANSI or UTF-8 with BOM.
Action files offer an alternative way to pass parameters to the application using command line. They allow to shorten the command line and thus make it easier to read and work with.
The command line
exptizer.exe /export /ExportType=DATABASE /IncludeMemo /SrcDBInterface=ADO /SrcPassword=m980 "/SrcDB=<DSN>BOOKS" "/SrcTableName=<MASK>*" /TrgDBInterface=ADO /TrgDBKind=FILE /TrgDBDriver=Access "/TrgTableName=<MASK>*" /TrgDB=c:\MyBooks.mdb
exports all tables from an ODBC data source to a Microsoft Access file. It can be rewritten using an action file:
Here, the contents of ExportAction22.txt file should be like the following:
;action /export ;options /IncludeMemo ;source definition /exporttype=DATABASE /SrcDBInterface=ADO /SrcPassword=m980 /SrcDBKind=DSN /SrcDB=BOOKS /SrcTableName=<MASK>* ;target definition /TrgDBInterface=ADO /TrgDBKind=FILE /TrgDBDriver=Access /TrgDB=c:\MyBooks.mdb /TrgTableName=<MASK>*
Action files can be created using several ways:
- Manually in any text editor using the command line specification;
- Automatically from Exportizer GUI: open your source dataset, click Build Command Line button, go through the all steps and select Action file option on the final step;
- Automatically, using Tools button from Export dialog.
Action files can be executed either from command line or from Exportizer GUI by choosing Tools | Execute Action File....
In the action files and the files they refer to (SQL files or field and table mappings files), it is possible to use environment variables.