To import data from an XML file

  1. Open the Data Transfer Tool.

  2. Select Import XML File from the main console or the Transfer menu. The Welcome to Import from XML File Wizard window will open, displaying a summary of the steps to be taken in the wizard.

  3. Click Next. The Choose a Source XML File window will open.

  4. Enter the full path of a text file to import or click the browse button to search for a text file.

  5. Click Next. If the XML file has a structure acceptable to DBMaker's parser, the Specify Base Element window will open.

  6. The nodes of the tree structure represent the elements in the XML file. Click the nodes on the tree until they are fully expanded. Select a parent element to be the table name. The child elements will become the columns of the table. Check Column as attribute if appropriate.

  7. Click Next. The Choose a Destination Data Source window will open.

  8. Select the database to import data to from the Database menu.

  9. Enter a user name and password into the appropriate fields.

    Note: DBA authority or higher is required to import a text file.

  10. Click Next. The Transfer Setting window will open.

  11. Enter a new table name into the Table Name field, or select a table from the menu. Selecting a table from the menu will allow you to choose to replace the destination table, delete rows in the destination table, or append new rows to the destination table. Click Execute to import the XML file. A confirmation dialog box will appear.

  12. Click OK.


Related topic:

Importing Data from XML