Destination Connection Mappings

 

 

 

Mapping Key Macro: A macro value for which all vendor lines will be mapped off of.  This field is not required, and if omitted will default to the Vendor Code.

Default (Empty) Token: Indicates the code used to identify this token.  The default is DEF but can be changed as needed to avoid a conflict with source vendors.

All (Global) Token: Indicates the code used to identify this token.  The default is ALL but can be changed as needed to avoid a conflict with source vendors.

Do Not Transfer Token: When left blank this defaults to DNT but this can be changed as needed to avoid a conflict with destination vendors.

Ignore Case For Compare: If checked case is ignored when checking the designated mapping key from a file against the mapping key column in a mapping table.  For example, “telephone” is a mapping key in the file and “Telephone” is a mapping key in the mapping table.  With this box checked “telephone” would match to “Telephone”.  If this box is not checked “telephone” would need to be added to the mapping table.

Mapping Comparison Type: Determines how comparison of the source account in the data is made against the source account column in a mapping table. 

Exact Match: Values in the Matching Account Code from the source are made using an exact comparison against the Source Account column in the mapping table.

Wildcards: Values in the Matching Account Code from the source are made by evaluating wildcard expressions stored in the Source Account column in the mapping table.  See Wildcards for more information and reference the Searching Files section.  If the Source Account column in the mapping table does not contain a valid mapping expression a match will not be made and processing will halt until the wildcard expression is corrected in the mapping table.  Wildcard syntax is fairly easy to read and write but not the most powerful or flexible of mapping options.

Regular Expressions:  Values in the Matching Account Code from the source are made by evaluating Regular Expressions stored in the Source Account column in the mapping table.  If the Source Account column in the mapping table does not contain a valid regular expression a match will not be made and processing will halt until the wildcard expression is corrected in the mapping table.  Regular Expression syntax is a bit harder to learn than the wildcard syntax and can sometimes be a bit more difficult to debug but it is extremely powerful, flexible, and performs better than the wildcards option for those that take the time to learn it.

 


Copyright © 2023 pasUNITY, Inc.

 

Send comments on this topic.