6.2. Configure PARTsolutions
6.2.1. Add database columns
Prev  Next

6.2.1. Add database columns

The following description shows how you can add any number of additional columns to the standard configuration. (If you want to import data from a CSV file, the columns in the ERP table must be available analogously.)

You can access the dialog Change database columns [Change database column] in PARTlinkManager via Extras -> Database -> Change/create database columns [Modify/create database columns].

[Note]Note

The process "Add columns" directly accesses the database.

In other words, you must be logged on with admin rights!

Column name

Define a name.

Column type

In the list field, select a column type:

CHAR (text field); VARCHAR (text field variable); SMALLINT (no integer 0-65535); INT (integer); DECIMAL (decimal)

A string must be indicated for text fields.

Length: 1-255

[Tip]Tip

If you are unsure here, select VARCHAR with a length of 255. This is usually correct.

Default value: Optional

Create ERP column:

Leave the activation.

(You can edit the column later under PARTlinkManager -> Extras -> Configure ERP environment -> Configure column display [Modify column display] )

Confirm with OK.

For the column to be displayed in the PARTdataManager column is displayed, the following requirements must be met.

  1. Under Configure column display [Modify column display], the corresponding column must be set to Yes under Visible.

    The assigned column name is displayed in the Variable DB and Variable columns.

    The entry under Variable DB is fixed.

    The entry under Variable can be adjusted if necessary.

    [Note]Note

    Care must be taken to ensure that the name under Variable is used consistently for all configurations. (See the next two points in particular)

  2. In PARTadmin, the column must be entered in the desired role(s) under Columns to be displayed. The order is also relevant for the display in PARTdataManager relevant.

    [Note]Note

    In the event that some ERP columns are to be displayed at the front and others at the back - i.e. the geometry data somewhere in the middle, please use the following syntax:

    ERP_PDM_NUMBER,MAT_NAME, ... ,DESCRIPTION

    The geometric columns are then displayed at the position of "... ".

Result in the PARTdataManager

Restart PARTdataManager again. The added column is now displayed.

[Note]Note

To display the column in the PARTdataManager you must be logged in with the role assigned in PARTadmin.

Prev Up Next
6.2. Configure PARTsolutions Home 6.2.2. Configuration of the PARTdataManager view