Manual

Login

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

Manual

3.1.6. Article Number Search - Automated assignment by order number 3.1.6.1. Article Number Search standard procedure
Prev	Next

3.1.6.1. Article Number Search standard procedure

The example in hand uses the following CSV file and shall give an overview on a complete standard procedure on the base of the template Article Number Search.^[12]

CSV data

Create catalog from CSV:

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

Create catalog from CSV

Result:

Note

The display name in PARTdataCenter corresponds to the CSV name. However, you can adjust it anytime.
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.
Select the new process.
Click on the button Load predefined template and then on the command Article Number Search.

Load template for Article Number Search

-> The pipeline is displayed.^[13]
Select Product Source.

Under Catalog selection, click on the search button ....

Select the desired CSV catalog and confirm with OK.
Select Find Article Number.
- Catalog Selection
  - Field containing the catalog: This option is also suitable if the CSV file contains data of several manufacturers.
    
    When clicking on the search button ..., a dialog box is opened where you can determine the field, which contains the catalog name.
    
    Article number columns in PARTsolutions catalogs:
    
    Note
    
    This setting is only active, if Field containing the catalog is selected.
    
    With the help of the plus button you can add any number of lines, each with the combination of PSol catalog and PSol column name.
  - PARTsolutions catalog: When clicking on the search button ..., a dialog box with a listing of installed PARTsolutions catalogs is opened. Select the desired catalog and confirm with OK.
    
    Article number column in PARTsolutions catalog:
    
    Note
    
    This setting is only active if the option PARTsolutions catalog is selected.
    
    Predefined column: The classification is automatically queried, which contains the information on order number.
    
    User defined column: Determine the column containing the order number by manual entry.
  - Article Number Selection: Choose the field (or several), which contains the article number.
  - Optional settings:
    
    Dimension field (e.g. M32x100): Should the article number not be unique, you may declare a further field for distinction.
Click on the Start button to execute the pipeline.

-> In the docking window Performance a respective message is displayed.
Now have a look on the result: