Creating a table collection

To create a table collection in the XML to IDO Wizard, you must have the wizard open to the first page and an XML document already selected and parsed.

In the “Collection Type” group box, select the “Table” option.
In the “Table Selection Type” group box, select the “Table Element” option.
In the XML parser window (where the XML code is displayed), locate and double-click the XML node that you want to use as the basis for creating the table and IDO.

This must be an element that contains the children elements you need as properties.

The wizard displays the specified XML node in the edit window, indicating visually that it is a collection element. Notice that the field to the right of the name field displays the xpath for the specified node.
Optionally, change the name for the collection in the name field.
Optionally, to indicate that this is to be the primary collection, select the check box at the end of the line.
In the “Table Selection Type” group box, select the “Property Element” option.
In the XML parser window, locate and double-click each XML node that you want to use as the basis for creating the table columns and IDO properties.

You can select multiple XML nodes for this.
Designate at least one property element as a primary key, by clicking the key icon to the right of that element's line.

When you are finished creating the table collection specifications, either:

Create any additional collections you might want.
To continue with the wizard, click “Next”.