Create the Sub Table Template File

This section describes how to create the sub-table template file. This template file defines how the information extracted from the Items and Products table is structured.

When the connector runs the fetch task, this template is combined with the main template and used to generate a single document for each row returned from the main table (orders).

To create the sub-table template file

  1. In a text editor, create the sub-table template for data extracted from the Items and Products tables:

    ITEM <!--ProductID-->, <!--ProductName-->, QTY <!--Quantity-->, £<!--Price-->

    Each HTML comment in the sub-table template is replaced by data extracted from the corresponding column (ProductID, ProductName, and so on) from the joined Items and Products tables.

  2. Save the file as items.tmpl in the connector's installation folder (the file name you specified in the configuration file).