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.
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.