2.3 Convert XML to CSV (Comma Separated Values)

Exult makes converting XML to CSV very easy. It works by parsing the XML for data, automatically creating tables and columns, and identifying relationships between tables as dictated by the XML structure. These relationships are built using primary and foreign keys. Though primary and foreign keys do not have any special significance for CSV files, they are very important when loading the data into a database. By exporting the XML relationships as primary and foreign keys, Exult gives you the option of carrying these relationships over to whatever the intended target of the CSV export.

Exult also includes options to merge data from two or more tables into a single table. The merge takes into account the relationships between parent and child tables. This is very useful if you want to flatten the XML data.

After XML parsing is complete, you can preview the data and select the tables you want to export.

An important feature of Exult is that it can handle large XML files without running into memory restrictions. This is due to the fact that Exult parses the XML data to an embedded database, so the entire XML file is never loaded into memory.

Note that Exult supports different output formats in addition to CSV, including saving directly to a Microsoft Excel spreadsheet (XLS file), Microsoft Access Dataabase (MDB or ACCDB files), HTML or Text.

1. The Welcome Screen
2. The Trial Screen
3. XML File Selection Screen
4. XML Processing Screen
5. The Data Preview Screen
6. Merging Tables to create a view
7. The Output Type Screen
8. CSV and Text Output Options Screen
9. The Finish Screen