Selecting XML data structures

Use the Select XML Data Structures page of the wizard to select one or more XML data structures to use to define your ACL table.

XML data structures consist of elements, nested child elements, and attributes that ACL identifies when it analyzes an XML file. They are displayed in the XML Data Structures pane, which is a hierarchical representation of the XML file. Each XML data structure is represented by a table icon , and the name of the XML element and nested elements or attributes that it contains.

Prior to selecting one or more XML data structures you should review the XML file and determine a suitable ACL table structure for your audit objectives. With that table structure in mind, select only XML data structures with columns that match columns in the intended table structure. You can use the subsequent pages in the wizard to select the individual elements to include and modify column properties.

If you need to analyze an XML file with a complex structure, you may need to import the XML file more than once. You can select different data structures for each ACL table you define, and then relate the tables in ACL.

To select data structures:

  1. In the XML Data Structures treeview, select a data structure you want to use to define the ACL table.

    The column names with sample data are displayed in the Sample Structure pane. Names preceded by the @ symbol are derived from an XML attribute rather than an XML element.


    If more than one instance of a nested element exists within the data structure, the repeated element may not be listed in the data structure in the treeview. You can select the specific instances of the repeated element in a subsequent page of the wizard.

  2. Click Add.

    All the displayed elements in the selected data structure are added.

    The corresponding table columns are displayed in the Preview pane. The data is displayed if Auto Preview is checked.

  3. Repeat steps 1 to 2 to add any additional data structures that you want to include in your ACL table.
  4. Click Next.

(C) 2015 ACL Services Ltd. All Rights Reserved.