powered by CADENAS

Manual

Manual

3.1.6.1. Example 1 - Article Mapping Search - Standard procedure

The example in hand uses 4 characteristics of a DIN 914 (see adjoining CSV file) and shall show the complete procedure based on the template Article Mapping Search.[a]

CSV data

CSV data

[a] The used sample file article_mapping_search_din914.csv can be found under "$CADENAS/training/partdatacenter/article_number_assignment".

  1. Create catalog from CSV file:

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

    Result:

    [Note] Note

    The display name in PARTdataCenter is according to the CSV name.

  2. Add new process:

    In the context menu of Workspace -> Processes -> Article Assignment, click on the command Add new process.

  3. Product source: The CSV catalog is already set. Leave the setting.

  4. data:

    Select the option Field containing the standard number. In the example in hand this is "Norm" (Standards).

  5. Class finder:

    The PARTsolutions catalog is already set. Leave the setting.

  6. classified:

    Move the variables needed for the identification of the correct characteristic on the right side via arrow key . For the DIN 914 used here these are the variables "Diameter" (Durchmesser) and "Length" (Länge).

    In the column Mapping, click into the field and in the input field, enter the variable name in the PARTsolutions catalog. Here D and L.

    Leave the checkboxes in the column Variant deactivated.

  7. Start the process by clicking on Run.

    -> The dialog box Progress appears. Once the Pipeline closed and 100% is displayed you can close the window.

  8. Result:

    On the left side under Workspace -> Catalogs -> <Name of CSV catalog> (here "article_number_search"), select Products.

    On the right side, in the list field select Table .

    -> 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.

  9. 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 3.1.10, “LinkDB export (Directly or via CSV file)”.