| Database Explorer (DbExplorer) | |
|
|
Syntax:
usage: dbexplorer
Description:
DbExplorer is an interactive tool, which allows you to interactively:
a) export data from one or all tables to XML, CSV, HTML or TXT format
b) import data into a database from XML, CSV and TXT format without
duplication
c) View table data with smart automatic column width setting
d) View query data with smart automatic column width setting
e) Add new Queries to the database
f) Analyze current table or external DBF, XML, CSV or TXT files
f) View relationships between tables
g) Register your DbTkXml license
Note that In demo mode up to 100 records can be exported
and 500 records can be imported and 20 viewed.
Startup:
When DbExplorer start first time it will work with the Sample.mdb
database
and show all tables with their current records stored:
Note that DbExplorer automatically resizes each column width to fit the longest
text,
so you never have to do the cumbersome manual resizing of columns;
also the numeric columns (Records in this example) are automatically right
justified!
To switch to a different database click
on the 
button or use
Ctrl+O or File/Open.
DbExplorer will remember your last database at the next startup.
View
Table Data/Columns and Export/import
To view a table simply click on the table name (i.e. Products) and
DbExplorer will
display each record up to the specified limit (10000 by default or 20 in demo
mode).
Click on the 
to expand
and view the columns for the table (or on the 
to collapse).
To export/import etc right click on the table name and select from the
menu:
To export ALL table data right click on the "Tables" item and select
from the popup menu.
View/Edit Query and Export
To view a query first click on the
next to "Queries" and simply click on the query name
(i.e. Catalog) and DbExplorer will display each record up to the specified limit.
To export/edit etc right click on the query name and select from the
menu:
To export ALL queries data right click on the "Queries" item and
select from the popup menu.
Entering Query
Parameter
Some queries might require entering one or more parameters before the
query can be run.
Example: Click on the "Employee Sales by Country" query and the
"Parameter Box" will appear:
Double click on the first Value cell and enter for example "11/1/94"
and hit ENTER.
Click on the 2nd Value cell and press F2 to start edit and enter
"11/15/94" and hit ENTER.
To start the query click the "Run Query" button (or ENTER) and
DbExplorer will display the result:
Changing your DbExplorer Preferences
DbExplorer allows you to adjust your preferences. Click on the 
button or "Preferences":
If the column width is 0 DbExplorer will not limit the column width,
but here you can limit the maximum column width (in screen pixels).
Detailed table views will show more info for each table.
Enabling System Objects will also show internal database tables.
Note that In demo mode up to 100 records can be exported
and
500 records can be imported and 20 viewed.
Logfile:
DbExplorer writes all diagnostics to a log file "logs/yyyymmdd/DbExplorer.log"
If you run this command on Feb 18th, 2001 the logfile
would be created in:
logs/20010218/dbexplorer.log
INIT |12:19:51.352 |====== Opening
C:/DbTkXml/logs/20020309/dbexplorer.log ======
DbTkXml|12:19:51.442 |ExecCmd: chk1818
DbTkXml|12:20:05.573 |ExecCmd: opendb C:/DbTkXml/sample.mdb
DbTkXml|12:20:47.823 |ExecCmd: setcallback 4223056
DbTkXml|12:20:47.893 |ExecCmd: opendb C:/DbTkXml/sample.mdb
DbTkXml|12:20:47.933 |ExecCmd: table -s Shippers
DbTkXml|12:20:47.983 |ExecCmd: CSVEXPORT
DbTkXml|12:20:48.024 |3 'Shippers' Record(s) written to 'C:/DbTkXml/Shippers.csv'
DbTkXml|12:21:33.369 |ExecCmd: setcallback 4223056
DbTkXml|12:21:33.419 |ExecCmd: opendb C:/DbTkXml/sample.mdb
DbTkXml|12:21:33.459 |ExecCmd: RUNSQL |EmpSales||TXT|
DbTkXml|12:21:45.386 |ExecCmd: setcallback 4223056
DbTkXml|12:21:45.466 |ExecCmd: opendb C:/DbTkXml/sample.mdb
DbTkXml|12:21:45.516 |ExecCmd: RUNSQL |Employee Sales by Country||CSV|
DbTkXml|12:21:58.395 |ExecCmd: setcallback 4223056
DbTkXml|12:21:58.435 |ExecCmd: opendb C:/DbTkXml/sample.mdb
DbTkXml|12:21:58.485 |ExecCmd: RUNSQL |Invoices||TXT|
RunSQL |12:21:59.106 |Written 2155 record(s) to C:/DbTkXml/Invoices.txt
