About XMLWizard

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 has some features that make it a unique tool:

Data load as easy as 1, 2, 3...

Easy to use wizard interface allows you to select the input file and database parameters in just a few steps. If the table to store data in Firebird does not exist, you can create it with a few mouse clicks.

setup wizard

Powerful data comparer

Compare data from input file against the database and cherry-pick the desired changes to the database.

firebird data comparer

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.

link master and child XML nodes

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.

field properties

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.

XMLWizard | More info | Download | Order now