XML Data Source

Create a table from an XML data source file.

Properties of the XML connection details:

• XML Namespace

  The connection details screen contains a list of namespaces.

  Add or remove rows pressing the Add Row button, or the delete icon respectively.

  Prefix

  If the source xml has XML namespaces, this is the namespace’s prefix

  This field is compulsory if the source xml has XML namespaces

  Example: If the namespace is: xmlns:sp=http://some.namespace.uri then the prefix is sp.

  URI

  If the source xml has XML name spaces, this is the namespace’s URI.

  This field is compulsory if the source xml has XML namespaces

  Example: If the namespace is: xmlns:sp=http://some.namespace.uri then the URI is: http://some.namespace.uri

• Fields

  Define the fields within the XML source

  Add or remove rows pressing the Add Row button, or the delete icon respectively.

  Name

  Example: The name in this record would be "Job"

  <record><job>fireman</job></record>

  XPath

  Example: the XPath for this record would be "Job/text()"

  <record><job>fireman</job></record>

  Type

  Example: System.DateTime, System.Int32

  Format

  If the columns is of a Date type, can set the date format

  Example: DD’/’MM’/’yyyy

• Source XML File Path

  The path to the source Xml file. This is a local path, from which the "File Access Manager User Interface" service is installed

• Record Base XPath

  This XPath query defines the reoccurring element to use as a base record. The different field definition query from inside this base record.

  For example, if the xm is:

  <someData xmlns:sp="http://some.namespace.uri"><record><name id="1">john smith</name></record><record><name id="2">john doe</name></record></someData>

  Then the record base xpath is .someData/record