powered by CADENAS

Manual

Manual

4.25.4.3.1.1. Adding/removing database columns

In order to read in data from a CSV file, the columns must be available analogously in the ERP table.

The following description shows how you can add any additional columns to the standard configuration.

The ERP_PDM_NUMBER, MAT_NAME and DESCRIPTION are applied with the standard installation.

4.25.4.3.1.1.1. Apply databases columns per SQL Scripting

The LinkDB database instance is made up of several tables. Per standard installation, three columns are inserted into the ERPTABLE:

  • ERP_PDM_NUMBER

    Display of material number

  • DESCRIPTION

    Display of description text

  • MAT_NAME

    Display of material

Any other columns in the ERPTABLE can be set up for inserting third system information.

ERPTABLE

sql_execute create table ERPTABLE (/
ERP_PDM_NUMBER varchar (50) not null,/
DESCRIPTION varchar (200),/
MAT_NAME varchar (100),/
primary key (ERP_PDM_NUMBER))
sql_execute create public synonym ERPTABLE for SYSADM.ERPTABLE
sql_execute grant all on ERPTABLE to PUBLIC

Detailed information to database structure to be found under Section 4.2, “Installation Link database ”.

4.25.4.3.1.1.2.  Adding database column with PARTlinkManager

The following describes how to add database columns using PARTlinkManager.

  1. Under File menu -> Connect log in to the database.

    [Note] Note

    The "add columns" process grabs directly onto the database.

    In other words, you must be logged in with administration rights!

    Standard Admin login for the PLINKDB:

    • User: sa

    • Password: (according to the password given during the database creation)

  2. Under PARTlinkManager -> Extras menu -> Database click on Modify/create database columns.

    -> The dialog box Change database column opens.

  3. Column name:

    Specify any name.

  4. Column type:

    In the list field, select a column type:

    CHAR; VARCHAR; SMALLINT; INT; DECIMAL

  5. Length:

    For text fields a character string length must be indicated.

    Default value: Optional

  6. Activate Create ERP column.

    If you want to edit the column in PARTlinkManager (meaning not only in the database itself, but also in the respective configuration files), in the window Modify column display, set a check-mark (recommended).

  7. Confirm with OK.

    -> The column has been added.

  8. Via Extras menu -> Configure ERP environment open the dialog box Configure.

    The just created column is displayed in the Modify column display window.

    In the PARTlinkManager table, the column is displayed as well.

4.25.4.3.1.1.3. Set column visible in PARTdataManager

So that the column is shown in PARTdataManager, two requirements must be fulfilled:

  1. Under Modify column display, under Visible the respective column must be set on Yes.

    In the columns Variable DB and Variable the stated column name is displayed.

    The entry under Variable DB is fixed.

    The entry under Variable may be adjusted, if needed.

    [Note] Note

    Please make sure that exactly this name is used for all configurations. (Especially see the two next points.)

  2. In PARTadmin, the column has to be entered in all desired roles under Columns to be displayed.

    [Note] Note

    Please note which Roles is selected on the left side. The column display is always depending on the role.

    [Note] Note

    The position in PARTdataManager is according to the position in the listing.

Save the changes.

-> A message is displayed pointing out that the link database index should be newly created in order to consider the column when searching.

On this see Section 1.3.4.5.2, “Context menu commands in detail ”.

PARTadmin -> Index administration

PARTadmin -> Index administration

Result in the PARTdataManager

[Note] Note

In order to get the column to be displayed in the PARTdataManager, you must be logged in with the role assigned to you in PARTadmin.

4.25.4.3.1.1.4.  Removing database column

You reach the respective dialog box in PARTlinkManager via Extras --> Database --> Modify/create database columns -> Remove tabbed page.

In the list field under Column name all existing database columns are listed.

Select the desired column.

Confirm with OK.

[Note] Note

If the database does not support deleting of columns (such as SQLite for example), the Remove tabbed page is hidden.