1.1.7.  Attribute mapping
1.1.7.1. Example 1 - Attribute m apping - standard procedure
Prev  Next

1.1.7.1. Example 1 - Attribute m apping - standard procedure

This example uses 4 versions of a DIN 914 (see adjacent CSV file) and is intended to provide an overview of a complete standard process based on the attribute mapping [Attribute mapping] template.[a]

CSV data

CSV data

[a] The example file used article_mapping_search_din914.csvcan be found at "$CADENAS/training/partdatacenter/article_number_assignment".

  1. Create catalog from CSV:

    In the context menu of Workspace -> Catalogs -> Import catalog, click Import from CSV. Proceed as already described at Section 1.1.3, “Create catalog from CSV file”.

    Result:

    [Note]Note

    The display name in PARTdataCenter corresponds to the CSV name.

  2. Add new process:

    Click on the Add new process command in the context menu of Workspace -> Processes -> Item assignment [Article Assignment].

    --> The Pipeline Template Selection dialog box opens.

  3. Select the template attribute mapping [Attribute mapping] and confirm with OK.

    Load template for attribute mapping [Attribute mapping]

    Load template for attribute mapping [Attribute mapping]

    -> The pipeline is displayed.[5]

    -> The Search options numbers [Number search options] dialog box opens.

  4. Click on the Browse button .... under Select source catalog [Select the source catalog] in the Search options numbers [Number search options] dialog box.

    In the Field selection dialog box, select the desired CSV catalog and confirm with OK.

    -> The desired source catalog is entered in the Search options numbers [Number search options] dialog box. Confirm here too with OK.

    -> The Product Source node is now green.

  5. Select the Class filter [Class Filter] node.

    Select the option Fields from catalog that contain the standard number [Fields from catalog containing the standard number (e.g. ISO 1234)] (e.g. ISO 1234) [Fields from catalog containing the standard number (e.g. ISO 1234)] and use the Browse button to select the desired field, i.e. "Standard" in this example.

    Leave the other default settings.

  6. Select the Attribute Mapping Filter node.

    Transfer the variables required to determine the correct characteristic using the arrow key from left to right . For the DIN 914 used here as an example, these are the variables "Diameter " and "Length ".

    In the Mapping PSol [Mapping PSol Column] column, click in the field and enter the variable name in the PARTsolutions catalog in the input field. Here D and L.

    Leave the checkboxes in the Allow variants column unchecked.

  7. Click on the Start button to execute the pipeline.

    -> A corresponding message appears in the Performance docking window.

  8. Optionally, you can save the process so that you can use it again at any time (possibly modified). Click on the save icon .

  9. Result:

    Open the product links under Workspace -> Catalogs -> <name of CSV catalog> -> Products.

    [Note]Note

    Click on the Refresh buttonbutton to ensure that the current result is displayed.

    -> The results are displayed.

    All characteristics of the product DIN 914 (CSV catalog) have been uniquely (= 100%) assigned to the correct lines in the PARTsolutions catalog.

  10. Finally you can export the link information into the link database or first export into a CSV file and later into the LinkDB from there. Compare Section 1.1.9, “LinkDB export (Directly or via CSV file)”.



[5] The respective setting options are displayed by selecting the individual nodes.

Prev Up Next
1.1.7.  Attribute mapping  Home 1.1.7.2. Example 2 - Attribute mapping - Variants