Make the destination schema explicit.
Document the fields, objects, relationships, and constraints that matter to your platform before customers upload their source files.
Aformity helps teams connect source columns, legacy exports, and customer-specific fields to the exact objects and fields your platform expects.
Document the fields, objects, relationships, and constraints that matter to your platform before customers upload their source files.
Connect customer columns to destination fields, preserve relationships, and decide which source data should be transformed, archived, or excluded.
Use plugins to normalize values, split or merge columns, convert data types, and reshape records into the destination system's expected format.
Schema mapping is the process of matching fields from a source system or customer file to the fields and objects in the destination platform. Good schema mapping also handles relationships, required fields, allowed values, transformations, and fields that should not be imported.
Columns are renamed by hand in spreadsheets.
Mappings connect each source column to an explicit destination field.
Parent-child links are checked late in the import process.
Relationship rules are part of the mapping workflow from the start.
Each customer mapping starts from a blank spreadsheet.
Successful mappings become templates for similar customers.