|
Tab Mappings |
  
|
|
Tab Mappings |
|
This is the heart of this Tool, where you can do all your mappings and Import-Export settings
Visit our onsite tutorial video page to see all the "hidden" secrets of DMC mapping options.
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 the NAMES of all Columns
You also have all the 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 can be the one you declared in the ODBC connection string and not the real one, please keep this in mind.
The "L" ("linked" - affected) columns are an indication of the mappings done.
The "Default" column in the Destination Table displays the value you set as "default"
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 DATETIME
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 display a condition or function is applied
"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 |
You have a setting ("Long tasks options") to define the number of Records threshold above which DMC will detect a LONG TASK and start an ionized process.
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