1.1.6.  Article number search - Automatic assignment based on manufacturer article number
1.1.6.1.  Article number search Standard procedure
Prev  Next

1.1.6.1.  Article number search Standard procedure

This example uses the following CSV file and is intended to provide an overview of a complete standard process based on the article number search [Article Number Search] template.[2]

CSV data

CSV data

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

    Create catalog from CSV

    Create catalog from CSV

    Result:

    [Note]Note

    The display name in PARTdataCenter corresponds to the CSV name. However, you can modify it at any time.

  2. Add new process:

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

    -> A new process is opened.

  3. Select the new process.

  4. Click on the Load predefined template button and then on the Search article number [Article Number Search] command.

    Load template for article number search [Article Number Search]

    Load template for article number search [Article Number Search]

    -> The pipeline is displayed.[3]

  5. Select product source [Product Source].

    Click on the Browse button under Catalog selection ....

    Select the desired CSV catalog and confirm with OK.

  6. Select item number Find filter [Find Article Number].

    • Catalog Selection

      • Field containing the catalog: This option is also suitable if the CSV file contains data from several catalog manufacturers.

        Clicking on the Browse button .. . a dialog box opens to determine the field containing the catalog name.

        • Columns for article numbers in PARTSolutions catalogs [Article number columns in PARTsolutions catalogs]:

          [Note]Note

          This setting is only active if the field containing the catalog [Field containing the catalog] is selected.

          With the plus button you can create as many rows as you like, each with the combination of PSol catalog and column name of PSol [PSol column name].

      • PARTsolutions Catalog [PARTsolutions catalog]: Click on the Browse button ... a dialog box opens with a list of the installed PARTsolutions catalogs. Select the desired catalog and confirm with OK.

        • Article number column in the PARTSolutions catalog [Article number column in PARTsolutions catalog]:

          [Note]Note

          This setting is only active when PARTsolutionscatalog [PARTsolutions catalog] is selected.

          • Predefined column: The classification containing the order number information is automatically queried.

          • User-defined column [User defined column]: Specify the column containing the order number by entering it manually.

      • Select the article number [Article Number Selection]: Select the field (or several fields) containing the article number.

      • Optional settings:

        Dimension field (e.g. M32x100): If the article number is not unique, you can enter an additional field to differentiate.

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

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

  8. Now have a look on the result:



[2] The example file used article_number_search.csv can be found at "$CADENAS/training/partdatacenter/article_number_assignment".

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

Prev Up Next
1.1.6.  Article number search - Automatic assignment based on manufacturer article number  Home 1.1.6.2.  Article number search with regular expression