<< Click to Display Table of Contents >> Navigation:  General Functions > Import / Export > Import > XML Specifications

The MIE can import data from XML files, as long as the XML contained in the file conforms to the following rules:

1. If more than one table of data is contained, then the tables are assumed to be related and hierarchical, with the first table as the top-most table, and each successive table a child of the table before.

2. There are no peer-level tables contained in the XML

3. The first column defined for each table is the primary key value column for that table.

4.  Related tables contain a foreign key column that is named exactly the same as the primary key column of its parent table.

 

If the XML file conforms to these requirements, the MIE can import any number of levels of related tables within the XML.

The MIE import engine first converts the XML file to a CSV file, which is then imported.