Table Mappings File

Table mappings files contain source-to-target table mappings for multi-table export operations. Use them whenever you need the same table mappings to be used more than once.

It is supported two formats of table mappings files: XML (recommended) and plain text.

XML format

This format is flexible and extendable and therefore is recommended to use whenever possible. Each mapping must contain the source attributes with at least TableName specified and the target attributes with variable number of attributes:

Attribute Target Format Description
Source
TableName All Specifies a source table name.
Target
TableName Database, SQL For Database target format, it specifies a table name to export data to. For SQL target format, it specifies a table name to be used in generated SQL commands.
FileName All except Database File name to export data to.
HtmlDocTitle HTML The text to be placed into HTML Title tag.
HtmlTableId HTML The text to be placed into id attribute of HTML Table tag.
TableTitle HTML, RTF, Excel (XLSX), Excel (XML based) The text to be placed above the table data in the target document.
HtmlStepNo HTML Current export step.

Such files can be created either in the Export dialog on the Table Mappings step or manually using a text editor. When creating the files manually please note that they must conform to XML standards and contain byte order marks at the beginning if needed.

Example of the table mappings file in XML format:

<?xml version="1.0" encoding="UTF-8"?>
<-- Source-to-Target table mappings for Orders database -->
<TableMappings>
  <Items>
    <TableMapping>
      <Source>
        <TableName>customer.dbf</TableName>
      </Source>
      <Target>
        <FileName>customer.html</FileName>
        <TableTitle>Customers</TableTitle>
        <HtmlDocTitle>customers</HtmlDocTitle>
        <HtmlTableId>customer</HtmlTableId>
        <HtmlStepNo>1</HtmlStepNo>
      </Target>
    </TableMapping>
    <TableMapping>
      <Source>
        <TableName>order.dbf</TableName>
      </Source>
      <Target>
        <FileName>order.html</FileName>
        <TableTitle>Orders</TableTitle>
        <HtmlDocTitle>orders</HtmlDocTitle>
        <HtmlTableId>order</HtmlTableId>
        <HtmlStepNo>2</HtmlStepNo>
      </Target>
    </TableMapping>
    <TableMapping>
      <Source>
        <TableName>payment.dbf</TableName>
      </Source>
      <Target>
        <FileName>payment.html</FileName>
        <TableTitle>Payments</TableTitle>
        <HtmlDocTitle>payments</HtmlDocTitle>
        <HtmlTableId>payment</HtmlTableId>
        <HtmlStepNo>3</HtmlStepNo>
      </Target>
    </TableMapping>
  </Items>
</TableMappings>

Text format

Such files consist of series of SourceTableName=TargetTableOrFileName pairs, one mapping per line. It is recommended that table (file) names not contain equal signs. Lines with a semicolon at the beginning are ignored as comments. Blank lines are allowed.

Such files can have any extension and can be created in any text editor. When creating the files please include byte order marks at the beginning if needed.

Example of the table mappings file in text format:

;Source-to-Target table mappings for Orders database
Customer=Customer.htm
Order=Order.htm
Payment=Payment.htm