|
Tab Mappings |
  
|
|
Tab Mappings |
|
This is the heart of this 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 "T" column is for TRUNCATED data information : ie. : the source column is sized 100 and the destination one is sized 50 : data will be truncated - the line is colored in PINK for visual information
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.
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 ....
SQL Server Side DEFAULTS : if a column has (in PostGreSQL now but coming soon for others) a DEFAULT value set for example to generate_uuid(v4) then simply do NOT map this column and DMC will leave the server do all the work!
Mapping Rules and Options :
The most easy way to do a manual mapping is to use the Drag & Drop possibility : select the Source Column by a left click and drag it onto the desired Destination Column where you drop it.
Both lines will become green to show you the mapping has succeeded
In case of error you will see 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 column and to use any of the Options offered
Here you can choose any (mixing an option with conditions is allowed) option from the available ones :
Mixing Condition(s) with Function(s) or Concatenation(s) or Replacement "groups" is possible.
SOURCE Sort Field
| • | You can Drag & Drop from the left SOURCE list any column(s) to the ENTRY field to be used during Data Transferring |
| • | You can add a leading - if you want descending order |
| • | Default order is set to ascending (no + required) |
| • | Then entry field can also be emptied |
If the Table is SQL based and IF the Column has a SERVER SIDE DEFAULT value defined, then it will be displayed here
You can also enter in this field any value to use in case the source column is EMPTY
You can visualize the MAPPED and AFTER options are APPLIED Data bu using the the "Check Mappings" button
Use the buttons to navigate between the first 50 records loaded in memory and visualize your mapped destination data