Add or modify column specifications for an XML document data source

  1. Go to Step 2 Define InfoSet of the InfoSet wizard.
    Note: You must be an administrator to perform this procedure.
  2. Click Add Data Tag Alias to specify an alias for a node in an XML document.
  3. Specify alias nodes when similar data is stored under different tags.
    Tag Name

    Type a tag name for the alias.

    XML Tag

    Type the location of the parent node.

    For example, if you had a document with the sales data listed by quarter, such as <sales><q1>100000<q2>200000<q3>15000, you would want to define an alias for the q1, q2, and q3 fields and specify Quarter as the Tag Name and Sales as the XML Tag Location.

    Any references to Quarter in the Data Item section would find values that are below the salesq1, salesq2, and salesq3 node.

  4. Click Add Data Item to specify a data item for each InfoSet column.
    Name

    Type or select the name of the column.

    Type

    Specify from where the data comes.

    For example, <gross-sales>10,000</gross-sales>.

    If you specify tag, the name of the tag is used as the value. For example, <q1>.

    If you specify attr, the attribute of the node is used. For example, <storeid="1001">.

    XML Data Location

    Type the location (within the document) of the data you want to retrieve.

    This field uses a combination of decimal notation and array indexing, which begins with the root node followed by all of the nodes hierarchically in the path.

    For example, <sales><store id="1001"> <year>2003</year> <q1>10000</q1> <q2>12000</q2> </store> </sales>

    The location of the store ID is "sales.store.ID" with a type of attr. The location of the year is "sales.store.year" with a type of text. The location of the quarter is "Quarter" with a type of attr. The Quarter must be defined as an alias with a parent of sales.store. Finally, the actual sales values are specified as "Quarter" with a type of text.

    For repeating values, such as <sales><quarter>10000<quarter>12000</quarter><quarter>12000</quarter><quarter>1300</quarter><quarter>11000</quarter></sales>

    The values can be specified as "sales.quarter(0)", "sales.quarter(1)", etc.

    The parser that Smart Notification uses for processing XML documents does not recognize XML namespaces. To specify the tag for a node with a namespace, use only the name of the node without the namespace. For example, <xxx:sales>100,000</xxx:sales> refers to the location field as "sales."