powered by CADENAS

Manual

Manual

1.1.6.7.21.7. Block [LINKDBFIELDS] - Modify column display

In the block you can see a listing of all existing variables. This corresponds with the list in the user interface under PARTlinkManager -> Extras menu -> Configure dialog box -> PARTlinkManager preferences tab -> Modify column display.

Creation of columns for the PARTdataManager table

With click on Add entry you can add lines in the listing, meaning creating the respective settings on PARTsolutions side for the column display.

With click on Delete Entry you can delete the selected line.

[Hinweis] Hinweis

Adding and deleting of lines (columns) at this place concerns the internal PARTsolutions configuration. Here, there is no access to the database.

So it can happen that columns are added here, but do not exist in the database itself. In such cases an error message appears during login.

Troubles can easily be prevented when using the dialog under PARTlinkManager -> Datenbank-> Datenbankspalten ändern/erzeugen (with set option ERP Spalte anlegen [within PARTsolutions]). Then the new column is created both in the database and in PARTsolutions. For details see Abschnitt 5.3.2, „Datenbankspalte hinzufügen mit PARTlinkManager“.

For details on the creation of database tables via scripting please see Abschnitt 5.2.3.1, „Installations Skript“.

Column position in PARTlinkManager

Click on the respective line and move it up or down.

The single columns

  • Variable DB:

    Field name in the database. When performing a SQL-query using select * from ERPTABLE for example these column names are shown.

  • Variable

    Used in the PARTdataManager as bold written main column name.

    The PARTsolutions modules internally work with this name.

    [Hinweis] Hinweis

    Please ensure that exactly this name is used in all setting dialogs (configuration files).

  • Table

    Table corresponds either to the LINKTABLE or the ERPTABLE. Newly applied columns are usually entered into the ERPTABLE.

  • Translated description:

    Translated description in the respectively active language, defined under PARTlinkManager -> Extras menu -> ERP-Umgebung konfigurieren -> Übersetztungen tab

    The entry shows up in the following locations:

    1. As column name in the PARTlinkManager

    2. As small written column description in the PARTdataManager

  • Description:

    If there is no translation entered for the active language under PARTlinkManager -> Extras -> Configure ERP environment -> Translations tab, the text under Description is used.

    Also compare under Translated description.

    The entry shows up in the following locations:

    1. As column name in the PARTlinkManager

    2. As small written column description in the PARTdataManager

  • Format:

    Examples:

    A10: Text string with a length of 10 characters; (valid for data type CHAR and VARCHAR. Input is not mandatory.)

    F5.3: Number with 5 pre-decimal places and 3 post-decimal places (valid for data type DECIMAL.)

    I10: Integer with max. 10 places (valid for data type INT and SMALLINT).

  • Visible:

    Visible corresponds to the visibility of the columns used in the main window of the PARTlinkManager. These can be set to yes or no in the selection window.

  • Group:

    The individual columns in the PARTlinkManager and PARTdataManager are highlighted in color.

    These groups correspond to the allocation in Spaltenanzeige konfigurieren. Please do not mix up this "Group" with that of user "Group" (in the sense of "Role"!

    For details see Abschnitt 5.8.7, „Background color for ERP/PDM columns - plinkcommon.cfg -> Block [GROUP_COLORS] -> Key GROUP“.

  • Editable:

    In the main window of the PARTlinkManager you will see the button Edit. Via this button you reach the window Zeile editieren, where you can work on the fields of the database.

  • Text justification

    Option: left or right catches column contents that do not completely fit into the field (for example, in the PARTlinkManager column PSOL Projekt the end of the path is displayed).

  • Substring search:

    ...corresponds to the search function in the PARTdataManager:

    • Manually: In order to find the expression "G23" in the string "AUG329422" for example, the search entry must be defined as "*G32*".

    • Free both sides : For this setting, the entry "G32" is enough and leads to the desired results.

  • Image:

    You can use icons in the column header of characteristic attrbute tables in PARTdataManager. In this way you can mark columns with third party information (SAP for example).

    When clicking on the search button ... an explorer window opens. Select the desired icon. Default storage path is $CADENAS_SETUP/bitmaps.

    • PARTlinkManager: Assign icon to the desired variable (column)

    • PARTdataManager: Display of the icon in the respective column header of the table

1.1.6.7.21.7.1. Configure dialog box -> Adjust table values dialog area

For some variables it makes sense to adjust table values, which means to map internal values to terms, colors or images. Settings for this are made in the respective dedicated dialog area.

See Abschnitt 5.8.5, „Tabellenwerte anpassen > Set bitmap / plinkcommon.cfg -> Block [BMPMAPPING_<column name>] - Key "BMPCODE<Nummer>"“.