Exportizer Users' Guide vlsoftware.net

Table Mappings File

Contents Index Previous Next

Field mappings files contain source-to-target table mappings. Use them whenever you need the same table mappings to be used more than once.

The table mappings file must be a plain text file containing one line per mapping. Lines with a semicolon at the beginning are ignored as comments. Blank lines are allowed. Such files can have any extension.

Each mapping must hold a pair of source and target table/file names separated by equal sign (standard syntax), for example:

customer.dbf=customer.html

or a pair of source and target table/file attributes written in pseudo HTML format and separated by equal sign (extended syntax), for example:

<TableName>customer.dbf</TableName>=<FileName>customer.html</FileName><TableTitle>customer.dbf</TableTitle><HtmlDocTitle>customer</HtmlDocTitle><HtmlTableId>customer</HtmlTableId><HtmlStepNo>1</HtmlStepNo>

Notes
1. To avoid incorrect interpretation of the mappings, it is recommended that field names not contain equal signs.
2. Combing standard syntax and extended syntax in one file should be avoided.

Example of the table mappings file in standard syntax:

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

Example of the table mappings file in extended syntax for HTML destination format:

;Source-to-Target table mappings for Orders database
<TableName>Customer</TableName>=<FileName>Customer.htm</FileName><TableTitle>Customers</TableTitle><HtmlDocTitle>customer</HtmlDocTitle><HtmlTableId>customer</HtmlTableId><HtmlStepNo>1</HtmlStepNo>
<TableName>Order</TableName>=<FileName>Order.htm</FileName><TableTitle>Orders</TableTitle><HtmlDocTitle>order</HtmlDocTitle><HtmlTableId>order</HtmlTableId><HtmlStepNo>2</HtmlStepNo>
<TableName>Payment</TableName>=<FileName>Payment.htm</FileName><TableTitle>Payments</TableTitle><HtmlDocTitle>payment</HtmlDocTitle><HtmlTableId>payment</HtmlTableId><HtmlStepNo>3</HtmlStepNo>

Available attributes for extended syntax:
Attribute Target Format Description
TableName All This is the only attribute, which can be used in left and right sides of equation. In left side of the equation, specifies a source table name. In right side of the equation: for Database target format, specifies a table name to export data to; for SQL target format, 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 (XML based) The text to be placed above the table data in the target document.
HtmlStepNo HTML Current export step.