Here, we describe and show the most interesting and powerful parts of Exportizer GUI.
Exporting to a Database
Exporting Several Tables to One File
Exporting Huge Tables
Source-to-Target Field Mappings
Source-to-Target Table Mappings
Exporting Images and Other Blob Data
Export Data to HTML Using Template
Selecting Data Source
SQL Query Tool
Building Command Line for Data Export
[Click images to enlarge them]
In Exportizer Pro and Exportizer Enterprise, in addition to exporting data to different file formats, you can also export to relational databases: either to the same database or to another one. It can be Access to SQL Server, Interbase to Oracle, CSV to PostgreSQL, or almost any other database-to-database conversion.
There is a set of database specific export options. For example, Export mode controls the export actions:
|REPLACE+INSERT Target table is created and filled with incoming rows; if target table already exists, it is overwritten.
|CREATE/REPLACE Blank target table (using appropriate structure) is created; if target already exists, it is overwritten.
|APPEND Target table is appended with incoming rows; if target table does not exist, it is created.
|EMPTY+INSERT Target table is emptied before inserting incoming rows; if target table does not exist, it is created.
|UPDATE The records in the target table that match incoming records, are replaced with incoming records.
|APPEND+UPDATE The records in the target table that match incoming records, are replaced with incoming records. Unmatched incoming records are appended to the target table.
|DELETE The records in the target table that match incoming records, are deleted.
Exportizer Enterprise has a powerful Batch mode option which can increase the speed of the data transmission for some database types up to several hundred times.
In Exportizer Enterprise, you can export a set of selected tables at a time. They can be exported either to files or to a database of your choice.
When exporting the tables to files, you can choose either to export them to different files (one table per file) or to one target file. The latter option is available for XLSX, HTML, and RTF destination formats.
To export multiple tables to another database (e.g. MySQL, Oracle, Access, SQLite etc.), pick Database target format and choose the needed destination database.
In many export tools, exporting huge tables requires extensive memory usage and can sometimes cause the operating memory overflow and the application crash.
Exportizer Enterprise can solve this by utilizing a Live Data Window mode. In this mode, only current screen of records is kept in memory, and memory usage does not increase when scrolling and exporting the table. This mode not always can be applied and works slower but can help in most cases.
For other solutions, please see in Exportizer documentation.
Before exporting data, it is possible to specify the mappings between source and target fields.
Here, you can also add custom calculated fields and even specify an individual destination file for each source field. For some export formats (e.g. Excel or HTML), it is possible to add expressions for calculating column totals. [Pro, Enterprise]
If you remove any mapping from the list, the corresponding item will not be exported.
If you skip this step, the software builds the mappings itself according to destination file format or database type.
When exporting to relational databases, this data export tool can convert the source column types to target column types (see example of Access to PostgreSQL data migration on the screenshot). But anyway, it is possible to specify full target columns' specifications manually. [Pro, Enterprise]
The field mappings can be saved to file and loaded from file.
When exporting multiple tables, it is possible to specify the mappings between the source and target database tables. [Enterprise]
If you skip this step, the software builds the table mappings automatically according to destination type.
For each pair of the source and target tables, the corresponding field mappings can be added.
The table mappings along with the associated field mappings can be saved to file and loaded from file.
Exportizer Pro and Exportizer Enterprise can automatically detect the most known image types (JPG, PNG, GIF, BMP, ICO) in BLOB fields of a source database and export them, for example, to HTML, Excel, or RTF. They can also convert image format on the fly.
There is a possibility to export Blob data (images, large text, etc) into separate files in one export operation. In general, you can export each field in each record to an individual file.
Using HTML template allows producing highly customizable output, therefore target HTML file can be used directly in frontend without any further tuning.
It is possible to choose the output format and specify many common export options as long as options specific to selected target format.
Once you prepared a working export configuration, you can save it to file for future use.
In Select Data Source dialog, you choose the database engine which you want to use for opening your data source and the data source like a folder with data files (e.g. .dbf or .csv), multi-table database file [Pro, Enterprise], ODBC DSN [Pro, Enterprise], ADO connection string [Enterprise] etc.
Some database types can be opened by different database engines. For example, Oracle databases can be opened by FD [Enterprise], ADO, or BDE. We recommend to use FD whenever possible, but you might want to try different engines and compare which is better for your work.
Exportizer Pro and Exportizer Enterprise contain a built-in tool, which allows you to write custom database queries. The result of the SQL query can be exported like it is done for a table from the table list.
The SQL editor gives you all you need to comfortably write the queries: SQL syntax highlighting, UNDO feature, loading and saving files, supporting of SQL parameters, storing history of executed queries etc.
Export menu gives you an ability to choose what to export: current table or SQL query result, several selected tables [Enterprise] or even all tables [Enterprise] of the database at once. You can also copy the data from the opened data source to clipboard.
In Tools menu, there is a set of useful functions to operate with data: bookmarking, duplicating data, pasting tabular data from clipboard (copied from Excel, for example), printing data etc.
Export operations can be performed via command line too. You can easily build needed command line directly from the GUI using interface which is very similar to regular Export dialog.
For your convenience, the command line parameters can be saved to action file. It is possible to execute action files either from command line or from GUI. You can create action files for different export cases and use them whenever you need to repeat your export actions.
The command line and action files can contain environment variables, which makes them very flexible.