Recent Changes to Swift XML Converter
Swift XML Converter 1.7
Apr 20, 2009
Swift XML Converter version 1.7 released.
- Import XML from common encodings including: windows-1252,
ISO-8859-1, UTF-8, UTF-16, etc.
- Support for exporting CSV in Unicode encodings including UTF-16
and UTF-8.
- Import XML from secure web URLs(HTTPS).
Swift XML Converter 1.6
Oct 29, 2008
Swift XML Converter version 1.6 released.
- Minor user interface enhancements.
- Bug fix in generating table names for repeated XML elements.
- Bug fix: Fixes crash in specific circumstances when adding column
to a table for repeating XML elements.
Swift XML Converter 1.5
Sep 29, 2008
Swift XML Converter version 1.5 released.
- Enhancements to the user interface.
- Bug fix: when exporting more than one table to Microsoft Access
with the primary keys included causes problems since a database table
can have at most one primary key.
- Bug fix: properly abort download data from a URL for XML
import.
- Bug fix: fixed crash when adding XML_DOCS_PKEY to column list in a
query.
Swift XML Converter 1.4
June 3, 2008
Swift XML Converter version 1.4 released.
- Bug fix: fixes crash when a query is deleted if the query window
is open.
- Bug fix: fixes crash on right-click for context menu in the query
bar.
Swift XML Converter 1.3
May 21, 2008
Swift XML Converter version 1.3 released.
- Export multiple tables and queries in a single step. Relationships
are properly created for Microsoft Access when exporting parent and
child tables. [Select Main Menu -> File -> Export after importing an
XML].
- Delete all data from one or more imported XML files (cascaded
delete). All the data imported from the specified files will be
deleted, including from any children or grand children tables to any
depth. However, created tables and queries will not be
deleted. [Select the "Files Imported" tab, right-click for the context
menu, and select "Delete Data"].
- Added support for file filters to restrict the output of a query
to one or more imported XML files. For example, if you have imported
10 XML files and want to search the data from a couple of files, you
can apply a file filter to get the desired results. [Open a table or
query in the Data Browser, right-click for the context menu, select
"Edit Filters" and click "Add" under "Query Output restricted
to"].
- Improved performance of merging a table with its children (Flatten
operation). Should be much faster, upto 10 times faster in some
situations.
- Added ability to recursively select all XML files matching a
pattern from a directory. No more browsing to each directory and
selecting individual files! [Select "Import XML" from the File menu,
click "Add URL" in the "Select XML Files" window, and select the radio
for "Enter multiple XML files or URLs" and click Next].
- Specify multiple XML file URLs for import in a single step. [Same
as above].
- Added ability for exporting CSV and text output from each table
and query to a separate file. [From the main menu, select "File" ->
"Export". Select the tables and/or queries to export, click "Next" and
then select "CSV" or "Text" output].
- Bug fix: properly interrupt an XML file being imported. [The
"Cancel" button changes to "Abort" when parsing an XML file. Click it
to abort processing].
- Bug fix: Eliminated truncation of text fields longer than 255
characters when exporting to Microsoft Excel.
- Bug fix: Fixed issue with truncation of data fields larger than
255 chars when exporting XML data to Microsoft Access (Data type
should be "Memo" instead of "Text").
- Bug fix: Invalid file name characters in the title of a query
replaced with acceptable characters. This problem was causing errors
in showing the File Selection Box for selecting the output file.
- Clear column filters as well as file filters from restricting XML
output in a single step.
- Can export tables soon after importing XML. Previously a Data
Preview window had to be open for exporting data. [From the main menu,
select "File" -> "Export"].
Swift XML Converter 1.2
Apr 02, 2008
Swift XML Converter version 1.2 released.
- Enhancement to quickly
add a filter based on a column value in the currently selected row
added.
- One-click operation to clear current filters added.
- Functionality to flatten all data in a table and all its child
tables added. When invoked on the root table, a flat view (grid view)
of all data in the loaded XML is shown.
- Bug fix: After the XML is parsed and queried for a substring, the
condition was incorrectly specified to match only data ending with the
specified substring.
- Speed improvement in queries.
- Bug fix: After a document is closed, the list of columns was not
flushed out.
Swift XML Converter 1.1
Mar 22, 2008
Swift XML Converter version 1.1 released.
- Support for processing Zip archives added: import XML from within Zip archives
without having to unzip the archive first.
- Improved interface for specifying XML file URLs.
- Data from remote file URLs cached so it is fetched only once per
invocation.
- CSV and plain text output improved.
- Bug fix in merging data from multiple data tables to account for
non-existent (NULL) data in child tables.
- Option added for normalizing data from repeated XML elements. Data
can be inserted into the original table, or can be normalized to a
child table (which is linked with the original table).
- Bug fix: adding more columns to the query causing crash.
- Bug fix: improved handling when selecting multiple XML files in
one batch.
Swift XML Converter 1.0
Jan 22, 2008
Swift XML Converter version 1.0 released.
- Swift XML Converter is an application which allows you to easily
extract information from XML files into a Microsoft Excel Spreadsheet
(XLS file), Microsoft Access Database (MDB or ACCDB file), CSV (comma
separated values file), Text or HTML.
- Import one or more XML files and extract selected information to
the output format.
- Can handle arbitrarily complex XML files.
- Extract information from large XML files without running into
memory problems.
- Information within the XML is handled in an intuitive manner and
extracted to separate tables as needed without requiring user
intervention.
- Select and extract information from specific columns only.
- Imports Attribute information too when loading XML.
- Apply filters to select the rows for extraction.
- Merge and extract data from two or more tables. Merge conditions
are automatically figured out depending on the structure of your
XML.
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel
(XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or
ACCDB), or CSV.
Shred and import XML into SQL Server.
Import XML data into automatically created MySQL
tables.