XMLWizard is a tool used to import and compare data from files against Firebird databases. It supports XML, CSV and flat
(fixed-width column) textual files.
XMLWizard is a utility which can be used to load XML, CSV and flat textual files into Firebird databases. CSV is acronym for
Comma Separated Values, but various forms of these files are supported (for example, TSV or Tab Separated Values), with user
configurable delimiters, qualifiers and record separators. It supports multilevel XML files with unlimited depth of nesting.
Beside importing, XMLWizard has a powerful data comparer which can be used to compare the data in input file against the data
in the database and show the difference in a grid. In this grid, user can cherry-pick individual rows or even fields to be
inserted, updated or deleted from the database.
- Windows 2000/2003/2008/XP/Vista/7
- glibc 2.3.2, gtk+2.0, fontconfig/xft, libstdc++6
- 500MHz processor
- 128 MB of RAM
- 50 MB of hard disk space
|License:||Free to try, $39.99 to buy|
|Download Size:||2.68(2.91) MB|
Key Features of XMLWizard:
- Powerful data comparer
Compare data from input file against the database and cherry-pick the desired changes to the database.
- Able to load data from nested XML files
XML files often contain data for multiple tables. The structure can either be flat, where each table is separate,
or nested, where child tables are represented as sub-nodes of master table's XML node. XMLWizard supports both formats.
- Automatically detects datatypes from input file
Many times you will get an XML file without XSD or XSLT schema. You might also get a CSV or flat textual file without
any documentation about the datatypes that can be found in each column. XMLWizard reads in the whole file, reports what
it detected and suggests the datatype that matches the field.
- Load data from MS Excel, Access or OpenOffice
Although it is not possible to open such files directly, all spreadsheet programs have an option to Save as or Export
data to CSV, TXT and XML formats. XMLWizard has been tested with various outputs generated from those three programs
to ensure quoted identifiers, multi-line values and other special cases get imported properly.
- XMLWizard in action
This 5-minute video shows typical usage of XMLWizard. It is also available in high definition - if you have a fast
Internet connection, just click the HD button after it starts.
| RELATED SOFTWARE DOWNLOADS FOR XMLWIZARD
- ABC Amber DBX Converter
converts Outlook Express databases (DBX files) to DBF, CSV, XLS, XML and MDB.
- Data Port Command
copies Access or SQL Server 2000 databases into SQL CE 2.0.
- My CSV to XML Converter
The My CSV to XML Converter program has been tested with Java 1.4 and can convert CSV files into XML format quickly.
is a visual XML differencing tool.
- D-Softs Database Comparer
is a database schema and data comparison tool.
- RazorSQL for Mac OSX
is an SQL query tool, database browser, SQL editor, and database administration tool for Mac OS X.
- SQL Server Comparison Tool
quickly analyzing, comparing and documenting SQL Server databases.
- SQL Uniform
database query, comparation, export, convert, admin tool.
- Database Application Generator
creates user interface for database applications.