Column Map - Auto Map

Automatically maps database table columns to Grooper fields based on name similarity and data type compatibility.

Remarks

The AutoMap command is designed to streamline the process of configuring column mappings for database export by automatically matching Grooper fields to database columns. This command analyzes the names and data types of available fields and columns, and creates mapping expressions where a close match is found.

How It Works

• For each writable column in the target database table, the command searches for a Grooper field with a similar name and compatible data type.
• Name similarity is determined using the Levenshtein distance algorithm, allowing for minor differences in spelling or formatting.
• If a suitable match is found (within a configurable distance threshold), the field is mapped to the column using a direct expression.
• Existing mappings are not overwritten; only unmapped columns are considered.

When to Use

• Use this command when you want to quickly generate initial mappings for a new or updated Table Mapping.
• It is especially useful when the database schema closely matches the Grooper data model, or when field and column names are similar.
• After running AutoMap, review and adjust the generated mappings as needed to handle special cases, calculated values, or formatting requirements.

Configuration Guidance

• Ensure that the Table Mapping is configured with the correct source scope and target table before running AutoMap.
• The command can be executed from the property grid or context menu for the Column Map property.
• If no suitable field is found for a column, the mapping will be left blank and must be configured manually.

Example

Suppose your database table has columns named Invoice_ID, Billed_Date, and Total_Amount, and your Grooper data model has fields named InvoiceNumber, InvoiceDate, and TotalAmount. Running AutoMap will automatically match and map these fields to their corresponding columns, saving time and reducing manual effort.

> Tip: Use AutoMap as a starting point for your export configuration. Always review the generated mappings to ensure accuracy and completeness, especially for columns that require calculated or formatted values.

See Also

Column Map