Defining the Default Property Mapping for All Classes
If the Excel file contains EC class attributes available in different EC classes but they don't match exactly with the EC class property names, then you must add the defaultPropertyData property section in order to customize the attribute mapping.
Configuration
{ "id": 2, "name": "mapping 2", "importType": "smartExcel", "classKey": "Class", "columnHeaderIsPropertyName": true, "defaultPropertyData": { "mapping": [ { "source": "Man.", "target": "NANUFACTURER" } ] }, }
Description:
- The Man. column contains the manufacturer information. It is not equivalent to the "MANUFACTURER EC" class property from the EC schema.
- "source" is the column name
- "target" is the property name from the EC class schema. With this you can map custom property names to the EC schema.
- You can combine the properties given in "defaultPropertyData" with "columnHeaderIsPropertyName". In this example, the defaultPropertyData will be used as a fallback if the "columnHeaderIsPropertyNameproperty" does not exactly match the EC class attribute name.