|Template file sections|
This section provides information about TDE template structure and details about each section that can be included.
Each template file describes a single data operation. For example, you can create a template that imports, exports, or deletes data from a TDE table. A template that imports data can add rows to a table or update existing rows.
When importing or exporting data,templates have an Input, which is a data source that supplies the data for the template operation, and an Output, which is the data created or generated by the operation.
Important: Entries in a template must follow template syntax.
A template file follows the INI file format. This format is a collection of name/value pairs divided into these sections:
Defines general template settings, giving the intent of the template and describing the data to be created, updated, exported, or deleted.
Defines user input variables (values that are supplied as run-time parameters).
Lets you define functions that operate on that data that you import or export.
Provides logical names for input columns when importing from a CSV file that has no header row.
Defines the final mapping of input and calculated values to output columns. You can have multiple Output sections, so that a single input row generates multiple output rows.
Lets you filter input rows to indicate which ones you want to process as well as filter rows being retrieved. Many tables have predefined fetchers to ensure that data retrieve operations return a manageable amount of data.
Lets you define a detailed response for input templates.
Defines namespaces for input templates.
Defines default measurement units to use throughout a template.
|View the sample templates, which illustrate how the template sections work together to describe an import or export.|