1.7.3. Configure PARTsolutions
1.7.3.1. Add database columns
Prev  Next

1.7.3.1. Add database columns

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

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

You can reach the dialog Change database column in the PARTlinkManager via Extras -> Database -> 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!

Standard administration login is: user 'sa', password 'PARTsol9.0!'.

Column name:

Define a name.

Column type:

In the pull-down menu, 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 under PARTlinkManager -> Extras -> Configure ERP environment -> Modify column display.)

Confirm with OK.

In order for the column in PARTdataManager to be shown, three requirements must be met.

  1. Under Modify column display the corresponding column under Visible must be set to Yes. (Visibility in the PARTlinkManager for control purposes)

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

    The entry under Variable DB is fixed.

    The entry under Variable can be adjusted accordingly.

    [Note]Note

    You must make sure, that the name under Variable is used for all configurations. (See the next two points)

  1. In PARTlinkManager -> Extras -> Configure ERP environment -> PARTdataManager preferences tabbed page the column under View > Column order must be filled out.

    [Note]Note

    In case some ERP columns should be displayed on top and others at the end - in other words the geometry data somewhere in the middle, then please use the following syntax:

    ERP_PDM_NUMBER,MAT_NAME, ... ,DESCRIPTION At the position of „...“ the geometric columns are shown.

  1. In PARTadmin the column in the desired roles must be entered under Columns to be displayed.

Result in the PARTdataManager

Restart the PARTdataManager. The added column is now shown.

[Note]Note

In order to make the column visible in the PARTdataManager, you must be logged in with the PARTadmin role.

Prev Up Next
1.7.3. Configure PARTsolutions Home 1.7.3.2. Configuration of the PARTdataManager view