powered by CADENAS

Manual

Manual

3.1.5.  Article Number Search - Automated assignment by the order number

Article Number Search

Article Number Search

[Note] Note

Using the template Article Number Search is good practice, if the CSV catalog contains the order number. Then this can easily be mapped to the adequate number in the PARTsolutions catalog.

The example in hand uses 60 characteristics of supplier parts (see adjoining CSV file) and shows the complete standard procedure on the base of the template Article Number Search.[a]

CSV data

CSV data

[a] The used sample file article_number_search.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 context menu command Add new process.

    -> A new process is opened.

  3. Select the new process.

    -> On the right side the respective dialog area is displayed.

  4. Click on the button Open a default template and then on the command Article Number Search.

    -> The dialog box Number search options opens.

  5. Determine source and target directory by clicking on the search button ... and confirm with OK.

    -> In the dialog area Process the Pipeline is displayed.

    -> On the left side under Processes -> Article Assignment and top right the process name is displayed now.

    One by one click on Product source, data and Article number finder to open the respective dialogs.

  6. Product source:

    The target catalog is already entered.

    Node "Product source" selected

    Node "Product source" selected

  7. data: Determine variable with order number in the CSV catalog.

    Edge "data" selected

    Edge "data" selected

    Leave the option Select catalog manually. The desired catalog is already set.

    Under Article number contained in, open the list and move the attribute containing the order number to right side with the help of the green arrow key .

  8. Article number finder: Determine variable with order number in the PARTsolutions catalog.

    Node "Article number finder" selected

    Node "Article number finder" selected

    Leave the option use predefined and in the list field, select the variable with the order number.

  9. Start the process by clicking on Run.

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

    In the list field on the right side, select Table .

    -> The results are displayed.

  10. Click on Filter. In the dialog box, select the option Show filtered products and deactivate the option Show products without links.

    -> Now only products which contain links are displayed. Here, exemplarily, this are 16 (see top right).