powered by CADENAS


Manual  ERP toolbar

The most important characteristic in PARTdataManager with activated ERP integration is the Link database toolbar (or the ERP menu with normally identical functions).

ERP activated

ERP activated

In the following the single buttons are explained:



Log on to link database as defined user

Select group : A defined user can select different views on the datasets (if provided).

Launch PARTlinkManager

Send selection to Link Manager / Cancel selection

Via double-click on a line in PARTlinkManager the view switches to PARTdataManager.

Now you can select any line in PARTdataManager. By clicking on this line is linked with an ERP number in PARTlinkManager, created before. The view returns back to PARTlinkManager. By clicking on you can cancel the procedure.

These two icons are only active, when a call has been performed in PARTlinkManager, otherwise these are inactive and dimmed.

Request ERP number per e-mail

Send e-mail

Send e-mail

See Section, “ Request ERP number per e-mail ”.

Add dataset to link database

...opens the following window

You can add as much entry fields as you like.

Add dataset to link database (variant)

Choose a data set, which is the very next to the variable to be changed.

After clicking the button the Create variant window opens.

All variables of the part are listed.

In the adjoining example D has been changed from 20 to 22.

After this the same dialog as at Add dataset to link database displays (see above).

Result: The added variant displays in PARTdataManager in addition.

When variants are created, possibly these are not sorted correctly in PARTdataManager (see fig. above). However you can determine the scheme of sorting for the currently opened project in a special dialog. So a manual editing of the PRJTABLE is not necessary. On this see under Section, “Line sorting in PARTdataManager ”.

Define sorting sequence for this project:

On this see under Section, “Line sorting in PARTdataManager ”.

Edit/delete dataset :

After clicking the button the Edit/delete dataset window shows up.

Edit/delete dataset

Edit/delete dataset

  • New key value

    Change the ERP_PDM_NUMBER if desired.

The data view is divided into Link-data and ERP data.

  • Update dataset

    Click on the value needing to be changed, change it accordingly and click on Update dataset.

  • Delete link

    Deletes the data of the LINKTABLE.

    Afterwards follows an inquiry whether or nor the data of the ERPTABLE should be kept. Confirm/deny the inquiry accordingly.

  • Execute SQL-command

    Opens the window of the same name.

    In the SQL command input field you can enter any command.

    Define the maximum number of lines in the result.

    Click on Execute after.

    [Note] Note

    Via the browse button ... the table names and a selection of SQL commands can be shown.

    Execute SQL-command

    Execute SQL-command

  • Close

show database-data for this part :

The window shows geometric data as well as ERP data.

Classify project

On this see under Section, “ Classify project ”.

[Note] Note

Whether the button is visible or not is controlled via configuration file. See Section, “ Tweak menus, menu items, toolbars, buttons and context menu commands ” in PARTsolutions / PARTcommunity4Enterprise - Administration Manual.

Legend (Locked, Released, Expired)

Preferred rows on/off :

This function controls both the display of catalogs, directories and projects in the in the index tree and the display of characteristics in the table.

Furthermore the search results are filtered, when this button is activated.

If the button Preferred rows on/off is activated, then only a) only "green"[a] catalogs, directories and projects are displayed and b) only lines, which have an entry in a defined column (often this is the column for the article number). In other words: In the table, only green lines are displayed. The red lines are hidden.[b]

you can recognize the table restriction at the filter icon . By clicking on the icon the filter is removed and all lines are displayed.

Example 1:

In the table only lines with ERP number are displayed.

Example 2:

In the table only lines with ERP number + status = 'released' are displayed.

Information on definition of conditions are found under Registerseite Allgemein -> Preferred ranges.

[Note] Note

You can combine the filtering with a search! If the filter is activated, then the search concerns only parts, which have not been filtered!

See Section, “ Enhanced search possibilities with ERP integration ”.

[a] Green refers to the standard definition. Analogously this statement applies for every other definition of preferred rows.

[b] Green/Red again concerns the standard definition.