Tab Mappings

dmc_general_s

This is the heart of this Utility Tool, where you can do all your mappings and Import-Export settings

Mapping Buttons :

Link by Order will scan all Source columns and affect it to the same Column number in the Destination Table - you can see the column "#" where the ID's are showed ... those are the column number used

Link by Name will scan both Table Structures and if the same NAME (without any eventual PREFIX) then those columns will be matched for mapping - in our example here above PIE:CODE will be matched with CODE

Clear links will remove all mappings

In the Link By Name process, DMC now will automatically check if DATETIME's are used and if so will link for you the relevant DATE and TIME field from source

General considerations :

To help you realize your mappings you have in each table the FORMATS and of course the NAMES found in your Table Columns

You also have - for ODBC SQL - MySQL - DB2 - Oracle - SQL Anywhere and for TPS tables all KEYS and INDEXES along with the "ND" (No Dupe) column - "P" (for Primary Keys) and another one for the KEYS themselves

For BLOB's - MEMO's the size allocated is the one you declared in the ODBC connection string and not the real one (as it would be too difficult to get the real one), so please keep this in mind.

The "L" (affected) columns are reserved for the mappings done indication.

The "Default" column in the Destination Table is reserved for the value you set as "default"

The "L" column is for linked (mapped) columns.

The "ID" column is for IDENTITY fields (not available in Topspeed & Oracle & PostGreSQL & FireBird drivers)

The "DT" column tells you this is a STRING(8) with a DATETIME GROUP Over it (of course you cannot use it for mappings in ODBC DB's) - New in version 1.101 : while reading your Tables icons will be added to all fields from such GROUPS and will be placed at the end of the columns to avoid use them without knowing what you are doing (for example you cannot use the DATE or the TIME column as they do not exist 'really' or using the GROUP column etc...)

You have all KEYS indicating visually if they are ASC or DESC types

You have more columns in the Destination Table - click on the horizontal scroll bar to see them :

extra_columns

Depending on the options used some columns are shown in red to show you at a glance what is selected

"Has Children" means multiple conditional settings are defined

"AutoInc" means you have setup this column to be filled in automatically with a number starting at the Auto Inc starting Pos.

"Concat" means you are aggregating two columns in one (the second column name shows in the "C Name" column

"TODAY()" means you have set as default value for that column to use Today's Date Format

etc ....

Mapping Rules and Options :

The most easy way to do a mapping is to use the Drag & Drop possibility : select the Destination Column, then select by a left click the Source Column and drag it till the selected Destination Column where you drop it.

Both lines will become green to show you the mapping has succeeded

In case of error you will have a message popup telling the reason (generally a structure problem : you cannot map for example a LONG column with a BIT one etc ....)

The second way to do a mapping is by Double-Clicking on any Destination record - column and to use any of the Options offered

mapping_options_empty

Here you can choose any ONE (mixing options at this date is not allowed) option from the available ones (more to come) :

Multiple Conditional Column Mappings

You can export to XLS-PDF-HTML-DOC-CSV (plus email or FTP those generated files) from the main frame's button