XML Conversion Examples

To understand how the XML Import technology behind Exult works to convert the XML, it helps to take a look at some samples. Among the samples listed below, some are simple, many are complex. Some of the XML files refer to resources available on the internet that you may have an interest in loading into a database, or consuming with another application. Most important to keep in mind is that, these XML files are not the only ones that can be processed. Exult can handle any well-formed XML file and is especially suitable for data-centric XML files.

Converting Customer Information into a Microsoft Excel Spreadsheet
Here is a simple but very typical XML file containing a list of customers with address information and other details which need to be loaded into a MS Excel Spreadsheet.
XML containing Customer and Order Information
This example shows how Exult handles multiple levels within the XML. The example is an XML database of customers and the orders placed by those customers. The Order information for each Customer appears as one or more child elements within the Customer element. Some customers have placed more than one Order so there could be multiple Order elements under each Customer element.
Batch conversion of XML to XLS
Exult XML Conversion Wizard includes a command-line program which can be used for batch conversion and conversion of more than one XML file at a time. While it is useful to use the wizard interface for interactive conversion and one-off conversions, it is sometimes useful perform scheduled conversion of XML to XLS. This is where the command-line interface to the Exult XML Conversion Wizard comes in.
Mapping XML elements and attributes: Example 1
Check out this article to understand how Exult maps XML elements and attributes to database tables and columns for reasonably simple XML data. The XML data contains multiple Customer elements contained in a single Customers element, with each Customer element containing many fields of information.
Mapping XML elements and attributes: Example 2
This example deals with a more complex XML structure and shows how XML elements and attributes are mapped to tables and columns.
CDATA section handling in Exult
Exult treats CDATA sections in XML just as any other text content. In this example, <Title> and <Description> elements contain CDATA sections which are extracted in a manner similar to text content.

Argon DataViz

Create Pivot Tables and Pivot Charts from Large Datasets.

Swift XML Converter

Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult Standard

Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.