The ETIM tab of a FAB-DIS file has six (6) columns of data which are represented as mapping targets on the Map Data step of the Export Manager and OIEP.
In the output, a single product ID can be listed multiple times when:
- a single product includes multiple ETIM feature IDs. A row is output for each feature ID and STEP ID combination.
- an attribute has a validation base type of 'Number Range.' Two rows are exported, one for the minimum and one for the maximum value.
- an attribute has a validation base type of 'Number Range' and allows multiple values. A row is exported for each range, with the minimum and maximum values in the same cell.
Important: The examples and images below define one way to map FAB-DIS data. The actual mapping steps required for your data are determined by your data model. For assistance, contact Stibo Systems.
STEP Data for ETIM Mapping Targets
STEP data should be mapped to the mapping targets as follows:
- MARQUE (text) is an attribute on the product that holds the brand name.
- REFCIALE (text), based on your data model, can be the product STEP ID, or an attribute on the product that holds the ID. The REFCIALE is repeated in the output as many times as there are different ETIM features.
- ARTCLASSID (text) is the ETIM class ID, which can be an attribute on the product or the classification link. For the classification link option, use the Multi Level References data source (and the Referenced node attributes option) to access an attribute on the classification that holds the ETIM ID, or optionally use a transformation to extract the ETIM ID directly from the STEP ID. For more information, refer to the Multi Level References - Data Source Outbound topic of the Data Mapping documentation (here) and the Transformations topic within the Resource Materials online help (here).
- FEATUREID (text) is the ETIM feature ID which can be mapped to the ETIM Attributes group.
- FVALUE (text) is the ETIM feature value which can be mapped to the ETIM Attributes group.
- ARTCLASSVERSION (text) is the ETIM class version, for example, 6.0. Use the Constant data source to map this text.
Sample Data
The following attributes are assigned to the '_FABDIS ETIM Attributes' group, and include values for the selected product. To clarify the mapping and output displayed within the images below, mapping information has been added to each attribute name in parentheses.
Mapping
The following mappings are displayed in this example:
- The MARQUE and REFCIALE targets are mapped to attributes on the product that contain the necessary data.
- The ARTCLASSID target is mapped to the classification reference, and a transformation is used to remove the 'ETIM_' prefix on the ID.
- The 'FEATUREID AND FVALUE' target is mapped to the 'ETIM_ETIM7_Attributes' group so that all attributes within the group with a value will be output. The individual FEATUREID target is manually updated to use the 'ID' aspect via the transformation button.
- The ARTCLASSVERSION target is mapped to the 'Constant Value' data source and the version is manually added.
Result
The following output is generated using the data and the map shown above and includes four rows for each product, where the FEATUREID indicates the ETIM attribute ID. The range attribute is displayed on two rows, indicated by the red box in the image below.
