Exportizer allows to view and edit databases (for example, DB, DBF etc.) with ability to copy open database to clipboard or export it to file. Export / copying can be executed either in interface or via command line.
There are several destination formats supported: XLS, HTML, XML, TXT, CSV, DBF, RTF.
Exportizer has two releases: Standard (or simply Exportizer) and Professional (Exportizer Pro). While the Exportizer is freeware, the Exportizer Pro is shareware with test period of 15 days and price of $19. Exportizer Pro has the following extra features comparing with Exportizer:
- Opening tables from XLS, MDB, HTML, GDB, IB and UDL files.
- Exporting data from all files, which are located in one folder, at a time (via command line).
- Ability to specify custom increment number for Increment Field Value function.
- Ability to specify a custom encoding in command line for XML and HTML export.
- Exporting data to dBase 5 format.You can buy Exportizer Pro either directly from the program's About section or by visiting
http://store.eSellerate.net/s.aspx?s=STR2885291359.
Database can be opened by two ways: via BDE (requires Borland Database Engine 5.0 or above) or via ADO (Microsoft ActiveX Data Objects). You can switch between these ways by using Connect via ADO option when opening database.
To open database click Open button or simply drag database file to Exportizer main window.
There is also the third way to open files, which were already opened recently. Opened file names are stored in the special list, which is available in dropdown list near Open button, where you can easy open it again without needing to browse it. When you move mouse over the list, the status line will display full path of the file name below the mouse.
There are several interface and export options, which are available under Options button.
Export options
Include column names* - check this item to include the column names when exporting (copying) the data.
Include MEMO* - check this item to include data of MEMO fields when exporting (copying) the data.
Include images* - check this item to include the graphics when exporting (copying) the data. Meaningful only for RTF or HTML destination formats. This option is not recommended for large databases.Export and interface options
Autodetect BLOBs - this option have influence on the view and export data of BLOB fields. When it is checked, Exportizer tries to detect the actual data type of such fields in each record and show/export it depending on this data type. Using this option may slow down performance, so it is not recommended for large BLOBs. Note, that Exportizer can automatically detect only several graphic formats (bitmap, metafile, icon, JPEG) and some other formats (for example, RTF) and only if the data contains all needed information for this.
Interface options
Button hints - check this item to view button hint, when mouse is over the button. If not checked, then you still can view the hint in the left part of the status bar.
Column hints - check this item to view column hint, when mouse is over the column title. This hint shows the actual name and type of database field of the column.
Data hints - check this item to view data hint, when mouse is over the grid cell and text of the cell does not fit the cell. It is useful to view data of MEMO fields or long text data.Flat buttons - check/uncheck this item to change the view of buttons in Exportizer interface.
Case Sensivity in Filter* - check this item to specify that the literal strings in the filter are compared to string-valued fields case-sensitively. This option is meaningful only for BDE connections..
Partial Comparing in Filter* - check this item to specify that the strings in filter condition that end in an asterisk signify a partial string match with the asterisk matching any number of characters. This option is meaningful only for BDE connections.* These options are available also through the command line.
Database grid
The data in Exportizer is shown in a convenient database grid, which allow to edit data, rearrange and fix columns, sort data, autoscroll, increase row heights (this is useful for viewing long text, MEMO or graphic data).
To sort the data by any column just click the column title. To sort in descendig order simply click it again. To sort by several columns click their titles in neded order holding [Shift] down.
Note: this feature always work for ADO connections and can work for BDE connections only if indexes are defined for selected table.To rearrange columns just click the column title and move it to new place holding left mouse button down.
To fix any column (to prevent it's horizontal scrolling) use the corresponding button.
To autoscroll the table click mouse wheel and than slightly move the mouse in the needed direction. This will cause the data to be scrolled automatically. To stop autoscrolling just press any key or click the mouse button. This feature is useful for large databases.
To increase row heights roll the mouse wheel holding [Shift] down.
See also: Shortcut keystrokes
Filter and search
You can prepare data for copying / exporting by using filter and search features.
To filter the data in open table enter the filter condition in Filter window and click the correspondinh check box.
To search the text for the first match in any column focus this column (by selecting any cell in it) and enter your text in Search window and click [Enter].
Data functions
There are several special functions for data manipulating. These are available under Data functions button. You can duplicate records, duplicate and increment field values from current record to the next one, paste cells from clipboard. There are also several functions for bookmarking records.
To copy or export the data use Export or copy button.
When copying / exporting, it is possible to specify the number of records, which will be copied into one line.You also can specify the destination format, field separator for TEXT destination, version (level) for dBase destination, schema for XML destination, range of data to export (copy) and some other options.
Notes for exporting to dBase format
- No text data encoding is performed. Code page 437 is used by default (US English). So, if you export columns with text in native (non-English) encoding, you will need to specify correct language driver for the new .dbf table in external program.
- When exporting BLOB columns to dBase version 5 or above, then except main .dbf file the additional file with the same name and .dbt extension will be created and already existing .dbt file will be overwritten.
- When exporting data to dBase version 3 or 4, then BLOB columns are ignored (not exported).
Here Exportizer command line specification is described. The keys and parameters, enclosed in square brackets [], are optional, and the keys, enclosed in arrow brackets <>, are required. Symbol | separates possible values for command line keys. Strings in red or blue color shows examples or possible values for command line keys. Order of the keys is not meaningful.
[-ado] [-filter=FilterCondition] [-FilterSensitive] [-FilterPartial] [-sort=Field1,Field2,...|-index=IndexName] [-SrcUserName=UserName] [-SrcPassword=Password] [-e[xport]] [-closeafter] [-opendestination] [-[include]images] [-[include]memo] [-[include]colnames] [-exporttype=TEXT|HTML|XML|RTF|XLS|CSV|DBF] [-separator=;|,| |#9|...] [-xmlschema=ado|standard|simple] [-encoding=Windows-1252|...] [-dbfversion=3|4|5] [-recordsperline=1|2|...] [-columns=column1;column2;...] <SrcFileName> [DestFileName]Examples:
1. exptizer -export -encoding=Windows-1252 "c:\my db\customer.dbf" "c:\my db\customer.htm"
2. exptizer -ado "-sort=payername,paymentsum DESC" -export -includememo -exporttype=RTF "c:\my db\dbdesrc.dbf" "c:\my db\dbdescr.rtf"
3. exptizer -index=ByPriceDesc -export -exporttype=HTML -columns=SERVICENAME;DESCR;PRICE "c:\my db\advert.db" "c:\my db\services.htm"
4. exptizer "-filter=BillSum > 200 and Name <> 'Parker'" -export -exporttype=TEXT -separator=#9 "c:\data\*.dbf" "c:\dest\*.txt"
5. exptizer -export -SrcPassword=leo12 "c:\my db\stores.mdb|price" "c:\my db\price.htm"
6. exptizer -export -exporttype=DBF -dbfversion=5 "c:\my db\types.db" "c:\my db\types.dbf"
Description of the options:
| Option | Description |
SrcFileName (required option) | Database file to open. File name that
includes spaces must be enclosed in quotes. |
| -ado | Use it to open SrcFileName by ADO. If not specified, or if opening by ADO is failed, the program will try to open by BDE. |
| -filter | Filter condition, which must be applied to database after it's opening. Filter condition that includes spaces must be enclosed in quotes (with the key key itself, as shown in Example 4). |
| -FilterSensitive | Specifies that the literal strings in the filter are compared to string-valued fields case-sensitively. Ignored, if -filter option is not specified. This option is meaningful only for BDE connections. |
| -FilterPartial | Specifies that the strings in filter condition that end in an asterisk signify a partial string match with the asterisk matching any number of characters. Ignored, if -filter option is not specified. This option is meaningful only for BDE connections. |
| -sort | List of fields, by which the database should be sorted. Field names must be separated by commas. If the list contains spaces, then whole key must be enclosed in quotes (see example 2). For local databases (DB or DBF), opened via BDE, the corresponding index must exist to sort. For ADO connections, ASC and DESC modifiers can be used. For example, using the key from example 2 will cause sorting by two fields: by payername (in ascending order) first and then by paymentsum (in descending order). |
| -index | This is an alternative for -sort key. The difference is in specifying an index name instead of a field list. |
| -SrcUserName | User name to connect source SQL database (Exportizer Pro only). |
| -SrcPassword | Password to connect source Paradox or SQL database. |
| -e[xport] | Use it to export data. |
The following options meanigful only if -e[xport] option is used: | |
| DestFileName | Destination
file name. File name that includes spaces must be enclosed in quotes. You can also use file mask instead file name to export group of files consequently (Exportizer Pro only); In this case SrcFileName must also be a mask, not a file name; Destination file mask must match source file mask, except extension (if any). |
| -exporttype | Specifies destination format. Possible values: TEXT, HTML, XML, RTF, XLS, CSV, DBF. If not specified or erroneous, then program tries to define it from DestFileName extension. TEXT format is used by default. |
| -separator | Specifies the field separator for TEXT destination format. Ignored for other destination formats. Can be any character or character code, followed by # symbol. For example, if you wish to specify a tab character as the field separator, then -separator=#9 option must be used. If not specified, then tab character is used. |
| -xmlschema | Specifies
the schema for XML destination format. Ignored for other destination formats.
Possible values: |
| -encoding | Encoding for XML or HTML destination format (Exportizer Pro only). Ignored for other destination formats. Possible values: Windows-1251, Windows-1252, UTF-8 and so on. |
| -dbfversion | Specifies version (level) for DBF destination format. Possible values: 3, 4, 5. If not specified or erroneous, then 3 is used. Note, that version 5 or above can be used in Exportizer Pro only. |
| -closeafter | Cause the program to close after successfull export execution. |
| -[include]images | Specifies either to include graphic data when exporting. Meaningful only for RTF or HTML destination formats. This option is not recommended for large databases. |
| -[include]memo | Specifies either to include MEMO fields when exporting. |
| -[include]colnames | Specifies either to include field / column names when exporting. |
| -recordsperline | Specifies the number of source records, which must be placed per one line in destination. If not specified or erroneous, then 1 is used. This option is ignored for XML and dBase destination. |
| -opendestination | Cause the program to open destination file after successfull export execution. |
| -columns | Specifies column names to export. If not specified, then all source columns are exported. Column names must be separated by semicolons. |
Shortcut keystrokes of Exportizer database grid
| Keystrokes |
Description |
|
Up Arrow | Move to the previous row. In Select Group of Records mode, select it. |
| SHIFT + Up Arrow | In Select Group of Records mode, select the previous row without deselecting the current one. |
| CTRL + Up Arrow, CTRL + Page Up | Move to the first row in the grid. Deselect any selected rows. |
| Down Arrow |
Move to the next row. In Select Group of Records mode, select it. |
| SHIFT + Down Arrow |
In Select Group of Records mode, select the next row without deselecting the current one. |
| CTRL + Down Arrow, CTRL + Page Down | Move to the last row in the grid. Deselect any selected rows. |
|
Page Up | Move up by the number of records shown in the grid. Deselect any selected rows. |
|
SHIFT + Page Up | In Select Group of Records mode, select up the number of records shown in the grid. |
| Page Down | Move down by the number of records shown in the grid. Deselect any selected rows. |
| SHIFT + Page Down |
In Select Group of Records mode, select down the number of records shown in the grid. |
| Left Arrow |
Move left one column. In Select Group of Records mode, move to the previous row without selecting it. |
| CTRL + Left Arrow | Move to the first column in the current row. |
| Right Arrow |
Move right one column. In Select Group of Records mode, move to the next row without selecting it. |
| CTRL + Right Arrow | Move to the last column in the current row. |
| Home |
Move to the first column of the current row. In Select Group of Records mode or the grid has only one column, move to the first record in the dataset. Deselect any selected rows. |
| CTRL + Home | Move to the first record in the dataset. Deselect any selected rows. |
| SHIFT + Home | In Select Group of Records mode, move to the first record in the dataset and select all rows between the current and the first ones. |
| End |
Move to the last column of the current row. In Select Group of Records mode or the grid has only one column, move to the last record in the dataset. Deselect any selected rows. |
| CTRL + End | Move to the last record in the dataset. Deselect any selected rows. |
| SHIFT + End | In Select Group of Records mode, move to the last record in the dataset and select all rows between the current and the last ones. |
| Tab |
Move to the next cell in the grid. |
|
SHIFT+ Tab | Move to the previous cell in the grid. |
| CTRL + Delete | Delete the current selection. |
| Insert | Insert a new row above the current one, and move to it. Deselect any selected rows. |
| Escape | Cancel any unposted edits. Deselect any selected rows. |
|
F2 | Put the grid in edit mode. |
| CTRL + SHIFT + 0 |
Set bookmark on current row. |
| CTRL + 0 | Go to bookmark. |
|
CTRL + mouse wheel | Like Page Up, Page Down |
| SHIFT + mouse wheel | Increase / decrease row heights. Use for viewing long text (including MEMO) or graphic data. CTRL + Add/Substruct keys (numeric keypad) does the same. |
|
Mouse wheel click | Move to the autoscrolling mode. |
| CTRL + F5 | Copy value of selected field, move to next record and then set the value of selected field to copied value. |
| CTRL + I, CTRL + ALT + I | Copy value of selected field, move to next record and then set the value of selected field to copied value, incremented by 1 (CTRL + I) or by custom number (CTRL + ALT + I, Exportizer Pro only). |
| CTRL + ALT + V | Paste cells from clipboard to the current column. Carriage return character is used to separate rows and a tab character is used to separate columns. This function is useful to paste tabular data, which was previously copied in Exportizer or other program (for example, Microsoft Excel). |
| CTRL + H | Hide current column. |
| CTRL + ALT + H | Show all columns. |
Exportizer is a program by Vitaliy Levchenko.
Author's web sites:
Exportizer web page: