Create the Sub Table Template File
Create a new template file for the information extracted from the sub table. 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.
To create the sub-table template file
-
In a text editor, create the sub-table template for data extracted from the Customers table:
Name: <!--Title--> <!--FirstName--> <!--LastName--> Address: <!--Address1-->, <!--Town-->, <!--Postcode-->
When the connector generates documents, each HTML comment in this template is replaced by data extracted from the corresponding column in the Customers sub-table.
-
Save the template as
customers.tmpl
in the connector's installation folder (this was the file name you specified in the configuration file).