4.10. Modify column display - plinkcommon.cfg -> Block [LINKDBFIELDS] -

Kapitel 4. Strategisches Teilemanagement 4.10. Modify column display - plinkcommon.cfg -> Block [LINKDBFIELDS] -
Zurück	Weiter

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
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 -> Database-> Modify/create database columns (with set option Create ERP column [within PARTsolutions]). Then the new column is created both in the database and in PARTsolutions. For details see Abschnitt 4.3.2, „Datenbankspalte hinzufügen mit PARTlinkManager“. For details on the creation of database tables via scripting please see Abschnitt 4.2.4.1, „Installations Skripte“.

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 -> Database-> Modify/create database columns (with set option Create ERP column [within PARTsolutions]). Then the new column is created both in the database and in PARTsolutions. For details see Abschnitt 4.3.2, „Datenbankspalte hinzufügen mit PARTlinkManager“.

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

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
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 -> Configure ERP environment -> Translations 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.
The group name under Modify column display -> column Group corresponds with the group name under Group definitions.
(Please do not mix up this "Group" with that of user "Group" (in the sense of "Role"!)
For details see Abschnitt 4.9.7, „Background color for ERP/PDM columns / plinkcommon.cfg -> Block [GROUP_COLORS] -> Key GROUP<number>“.
Editable:
In the main window of the PARTlinkManager you will see the button Edit. Via this button you reach the window Edit row, 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 Project 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 attribute 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
Unit: Optionally select the appropriate unit (length unit, weight unit, etc.).

Language: Enter the LinkDB language to ensure that the full-text search will optimally work.

	Hinweis
	Internally applied methods such as stemming, for example, enhance the effectivity of the full-text search. However, stemming works different from language to language. That's why the LinkDB language has to be known.

Zurück	Nach oben	Weiter
4.9.8. Determine column color by indicator in ERP column (very special) / plinkgroups.cfg -> Block [<Role_name>] -> Key "COLORNUMBERTREE"	Zum Anfang	4.11. Gestaltung Dialogfenster "Neue Ident-Nummer" - erpcustom.cfg -> Block [USERDIALOG]