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
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.
Save the file as items.tmpl
in the connector's installation folder (the file name you specified in the configuration file).
|