Database Software

Exportizer Frequently Asked Questions

Here, you can find the answers on popular questions about Exportizer. Click '+' button to expand the needed answer.

General questions

What are the differences between Exportizer Enterprise and Database Tour (Pro) exporting?

All the tools, Exportizer Enterprise and Database Tour (Std and Pro), use the same export engine and have almost the same export possibilities. But Database Tour has a lot of other possibilities, while Exportizer Enterprise is designed for export purposes mainly. Here is a brief comparison of the main features:

Feature Exportizer Enterprise EE Database Tour DT Database Tour Pro DTP

Exporting data from GUI

supported supported supported

Exporting data from command line

supported not supported supported

Other command line operations

not supported not supported supported

Database reports

not supported not supported supported

Executing custom SQL queries

supported supported supported

Executing multi-statement SQL scripts

supported supported supported

Transaction support

only on target side supported supported

Other capabilities like searching and replacing text, creating tables in GUI, editing BLOB data etc

not supported supported supported

Other characteristics

Data export speed the same
Data access speed Exportizer sometimes (not always) is a bit faster
Operating memory use Exportizer requires a bit less operating memory
Data export interface Exportizer has more flexible interface
SQL support Both applications are equal in executing SQL commands, but Database Tour has more functions for special SQL code generation
What version to choose: 32-bit or 64-bit?

Choosing which version to download and install is the question of compatibility between Exportizer software and: 1) your operating system (OS); 2) other database components the application works with.

Compatibility with OS

You can use Exportizer 32-bit on Windows 32-bit and Windows 64-bit, but Exportizer 64-bit should be used only on Windows 64-bit.

Anyway, on Windows 64-bit, if you do not want to dive into these details, you can install both Exportizer 32-bit and 64-bit on the machine and switch between them whenever you need. Please note that on Windows 64-bit, Exportizer 32-bit must be installed into Program Files (x86), and Exportizer 64-bit into Program Files. The application installer can decide this by itself, so it is not recommended to change the default path suggested by the installer.

Compatibility with other database components

Let's explain it with some examples...

If you want to work with dBase (.dbf) files, Exportizer can use different ways to open such files new tab. No matter what way you choose, all involved database components (drivers, OLE DB providers, and Exportizer) have to be of the same bitness. For example, when you will work with those files through the Microsoft dBase ODBC driver, the bitness of Exportizer must match the bitness of the ODBC driver.

Similarly, if you need Exportizer to work with .accdb databases (Microsoft Access 2007 and above), the Exportizer bitness must match the bitness of the ACE OLE DB provider or Access ODBC driver depending on what component (OLE DB or ODBC) you choose.

To work with Oracle, SQL Server, PostgreSQL, Firebird, MySQL, and other server databases, the bitness of Exportizer should be the same as the bitness of the corresponding client; if you plan to work with such databases via ODBC, the bitness of Exportizer should be the same as the bitness of the corresponding ODBC driver.

If you for some reason prefer to work with databases via old BDE, you should install 32-bit version of Exportizer.

Pre-purchase and post-purchase questions

I purchased Exportizer Pro (Exportizer Enterprise) and I need support. Where should I place the support ticket?

Please contact us using the online form here.

I purchased Exportizer Pro (Exportizer Enterprise), but after entering the activation key, I see error message 'Exportizer Pro has already been registered on another computer'. What does it mean?

Note, that you may use your purchased product on the number of computers for which you purchased a license.

For example, if you purchased one license, you may use the application on one computer only, as it is described here.

In your case, it means you have already activated Exportizer Pro (Exportizer Enterprise) with your activation key on other computer(s) and you are trying to activate it on extra computer. So, you should uninstall Exportizer Pro (Exportizer Enterprise) on some other computer(s) and try again. If the problem still exists, please contact us with specifying your activation key.

I purchased Exportizer Pro (Exportizer Enterprise), but cannot activate it. I entered my activation key and the application said it is valid, but every time it starts, the activation window appears. What am I doing wrong?

The activation of Exportizer Pro (Exportizer Enterprise) is done in two steps: validation of your activation key, and the activation itself.

You usually should not have problems with first step, if you have a valid activation key.

The second step (activation) is used to prevent casual piracy. Note, that you may use your purchased product on the number of computers for which you purchased a license. Activation just ensures that your activation key was used in compliance with Exportizer Pro (Exportizer Enterprise) license; in other words, it ensures, that amount of computers, where your activation key is used, is not larger than amount of copies purchased.

For example, if you purchased one license, you may use the application on one computer only, as it is described here.

The activation is usually done automatically behind the scene, after you enter your activation key and if you have Internet connection.

In your case, it seems, the serial number validation passed successfully, but activation failed due to either your activation key is used on other computer(s), or you have not Internet connection on your computer.

If you have not Internet connection on the computer where you want to use Exportizer Pro (Exportizer Enterprise), you should obtain the activation code using another computer, which has Internet connection, and then enter it in the application; just follow instructions, which appear after unsuccessful activation.

I purchased Exportizer Pro (Exportizer Enterprise), but now I want to purchase another copy. Can I expect a discount in this case?

Yes. Before purchasing, please contact us and send your order number and activation key. The discount amount will depend on amount of copies, purchased before, and amount of copies, you want to purchase, as it is described here.

I installed and registered Exportizer Pro (Exportizer Enterprise), but now I need to move it to another computer. What is the right way to do this?

One Exportizer Pro or Exportizer Enterprise license allows you to use the application on one computer only. To move installed and activated application to another computer, you should uninstall it on the old computer (using the Control Panel) and then install and activate it on the new computer.

Optionally, you can backup your registered databases before uninstalling, and then restore them after installing the software on the new computer.

I want purchase several your products. Can I expect a discount in this case?

Yes. You should start your order process here. You will be able to select more than one product to purchase by lower price than they are usually sold separately. If the product combinations offered are different as you would like to purchase, or if you want purchase multiple licenses of certain product, please contact us.

Technical questions

Can Exportizer export data in 'silent' mode (without showing any GUI windows)?

Exportizer Pro and Exportizer Enterprise can export data from command line with optional use of /silent switch. More details can be found in Exportizer documentation new tab.

Exporting to local files is really fast, but how can I speed up the exporting to databases?

1. Before exporting, make sure you fetch all records from the source dataset by moving to the last record in the grid. This makes sense for server databases.

2. Whenever possible, use FD interface and Batch mode option for your destination databases. This turns on bulk data loading mode and can speed up the export process up to hundreds times.

In the batch mode context, the Commit interval option sets the size of one data batch. The bigger its value, the higher is the export speed. But very big values may cause memory overflow during the exporting. Play with this value to find the optimal one for you.

Notes: 1. Exporting to databases is possible only in Pro and Enterprise editions. 2. Using FD engine is available in Enterprise edition only.

I need to export the result of calculating formulas. Is it possible?

Yes. This is possible in Exportizer Pro and Exportizer Enterprise. You can do this two ways.

1. If your database allows such formulas in SQL, using SQL query would be the most effective way. In SQL editor, type the code like this:

SELECT
  column1,
  column2,
  column3,
  column1 + column2 as MyFormula1,
  column2 || column3 as MyFormula2
FROM MyTable

2. Another way is to specify your formulas at Field Mappings step of Export dialog. In formulas here, you can use columns of your source table, special functions, and even local files.

So, click Add button in Field Mappings. A new table row will appear for a new field mapping. Click ... button in the first column and specify your expression (formula). Examples:

a. Get sum of two numeric columns

vle_expr(dataset_field_val(1, 'column1') + dataset_field_val(1, 'column2'))

b. Replace specific characters in the column's data

vle_expr(string_replace(dataset_field_val(1, 'column3'), char(0), ' '))

c. Get the size of a file, referred in the column's data

vle_expr(file_size(dataset_field_val(1, 'column3')))

In the column to the right, specify the target field name as you usually do for exporting physical fields.

How to export very large tables to another database?

It can be a challenge to export large tables or queries from one database to another. Sometimes, you may get an Out of memory error during the export process or even when opening such a table.

In Exportizer Pro and Exportizer Enterprise, it is possible to solve the problem. You can try different approaches. See more in Exportizer documentation new tab.

How to export BYTES fields?

If you export data to another BYTES database field, then everything is quite simple. All you have to do is to match the source and target fields in Field Mappings step of Export dialog.

If you export data to some of file formats, e.g. Excel or HTML, the result will be in a hexadecimal format string, which will start with 0x.

If you export data to database fields of CHAR or CLOB (i.e. text compatible) types, a bit more work is needed. In Field Mappings step of Export dialog, match the source and target fields, then specify the following expression instead of the source field name:
vle_expr(dataset_field_hex_val(1, 'YOUR_SOURCE_FIELD_NAME'))
As a result, the data will be exported to the destination as a hexadecimal format string, which starts with 0x.
Note: Using expressions is possible only in Pro and Enterprise editions.

And you can export data from the hexadecimal format string to BYTES field too. Just make sure your source string starts with 0x: this will indicate that the source data is the sequence of bytes in a hexadecimal form.

How to export images from a BLOB column to individual image files?

Here is an instruction:

  1. Open your source table with the BLOB field and click Export.
  2. Choose the export format. If you want only export images from the BLOB field, the target format does not matter. Let's choose Text.
  3. Specify a file name for the target text file. This file will not contain any useful information, so you may delete it after all.
  4. Go to the Field Mappings step. Delete all field mappings except the mapping for the BLOB field. Empty the target field name in the mapping table.
  5. Write the formula for the target image file name(s). This is the most interesting and most important step. Go to Target File column and click '...' button to the right to invoke the Expression Builder. As you can see, Exportizer already created a default formula:
    vle_expr(extract_file_path(target_file_name(1)) + 'Name_' + to_string(dataset_row_count(1, 0)) + '.???')
    Here, extract_file_path(target_file_name(1)) extracts the directory path from the target text file name; if you want, replace it with the constant path from your computer (don't forget to add the backslash at the end!).
    The to_string(dataset_row_count(1, 0)) part of the formula adds the current record number to the end of file name to ensure that the name is unique within the record set.
    Replace the ??? with desired file extension.
    If the source dataset already contains unique file names in some field, just remove the default formula and write something like this:
    dataset_field_val(1, 'file_name')
    (replace file_name with the actual name of the field containing the file names).
    Click OK to apply the formula.
  6. Click Save button to save the field mappings to file for future use.
  7. Click Export and check the results.

Note: Existing files are overwritten without asking.

See also: Example of exporting PDF from BLOBs to individual files new tab.

How to export text from some column(s) to individual text files?

You can export the content of any column to an individual file. The process is very similar to the exporting BLOBs to image files, described above:

  1. Open your source table or query and click Export.
  2. Choose the export format. Let's choose Text.
  3. Specify a file name for the target text file.
  4. Go to the Field Mappings step.
  5. Write the target file name formulas for each column, which content you need to save to separate files. In Target File column, click '...' button to the right to invoke the Expression Builder. You will see the default formula:
    vle_expr(extract_file_path(target_file_name(1)) + 'Name_' + to_string(dataset_row_count(1, 0)) + '.???')
    Here, extract_file_path(target_file_name(1)) extracts the directory path from the target text file name; if you want, replace it with the constant path from your computer (don't forget to add the backslash at the end!).
    The to_string(dataset_row_count(1, 0)) part of the formula adds the current record number to the end of file name to ensure that the name is unique within the record set.
    Replace the ??? with desired file extension.
    If the source dataset already contains unique file names in some column(s), just remove the default formula and write something like this:
    dataset_field_val(1, 'file_name')
    (replace file_name with the actual name of the field containing the file names).
    Click OK to apply the formula.
  6. Click Save button to save the field mappings to file for future use.
  7. Click Export and check the results.

Note: Existing files are overwritten without asking.

See also: Example of exporting PDF from BLOBs to individual files.

I'm building source-to-target mappings for exporting many tables to another database. The source table and column names contain spaces, and default mapping builder preserves them in target names too. Is there a way to quickly replace the spaces in target names?

Yes, you can do that in a few clicks:

  1. Open your source database, select the needed tables and click Export.
  2. Choose the Database export format and select the destination database from the list.
  3. Proceed to the Table Mappings step.
  4. Click Utilities button and choose Operations for Target Attributes....
  5. In the list of target attributes, select Target Table and Field Mappings.
  6. Click Replace text checkbox and specify the text replacing parameters.
  7. Click Execute. Check the results and click Save button to save the table mappings to file for future use.
I use a stored procedure to prepare data for exporting. Can I edit it in Exportizer?

Pro and Enterprise editions can work with stored procedures in PostgreSQL, Oracle, SQL Server, MySQL, Interbase and Firebird databases.

To load the procedure definition into Exportizer's SQL editor:

  • Open a new SQL window. Load the procedure text from a file.
  • or
  • Open a new SQL window and type procedure or function and then type the name of your stored procedure or function, respectively. Then click the procedure name holding Ctrl down to load its definition directly from the database. Note: the same can be done for Oracle packages.

After changing the procedure, you can compile it in Exportizer.

Can I add totals when exporting a table to Excel or ODS spreadsheet?

Yes, in Pro or Enterprise edition. But note that it will not be an Excel or ODS formula, it will be an Exportizer formula, calculated during the exporting and put in the target document as a number or text.

Please see the full example for HTML from the sister product (Database Tour) documentation. Everything is quite similar for Excel, ODS, HTML, or PDF in Exportizer Pro/Enterprise.

Is it possible to set dark mode in the application interface?

The dark mode and supporting different styles is under development. For now, you can use a hybrid color scheme forcing main interface elements like table list, table grids and SQL editor to use dark scheme while other elements remain light:

Using Hybrid Color Scheme

Cannot find your question? Please contact us.