Database Tour Documentation | ![]() ![]() |
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 FormatThis 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. |
Source attributes TableName Specifies a source table name. Target attributes TableName 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. Target formats: Database, SQL FileName File name to export data to. Target formats: All except Database RecordLogFileName File name to write the record log output to. Target formats: All BadRecordLogFileName File name to write the bad record log output to. Target formats: All HtmlDocTitle The text to be placed into HTML Title tag. Target formats: HTML HtmlTableId The text to be placed into id attribute of HTML Table tag. Target formats: HTML TableTitle The text to be placed above the table data in the target document. Target formats: HTML, RTF, Excel (XLSX), Excel (XML based) HtmlStepNo Current export step. Target formats: HTML SheetName The name of sheet to place the table data in. Target formats: Excel (XLSX) Field mappings FieldMappings Optional source-to-target field mappings. If omitted, the field mappings for the table are built automatically based on fields of the source table and the target table (if it exists). |
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. XML Format ExampleExample of the table mappings file in XML format: |
<?xml version="1.0" encoding="UTF-8"?> |
Text FormatSuch 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. Text Format ExampleExample of the table mappings file in text format: |
;Source-to-Target table mappings for Orders database |