English
Deutsch
Español
Français
Hrvatski
Italiano
Polski
Türkçe
Русский
中文
日本語
한국어
Legal notice
powered by CADENAS

Manual

Top Links

Manual

5.9.1.3.3.  Extras
5.9.1.3.3.1. Database
Prev   Next
5.9.1.3.3.1. Database
5.9.1.3.3.1.1. Adding/removing database columns
5.9.1.3.3.1.1.1. Adding database column
5.9.1.3.3.1.1.2. Removing database column
5.9.1.3.3.1.2. Show database columns
5.9.1.3.3.1.3. Save/restore database
5.9.1.3.3.1.4. Editing additional tables in the PARTlinkManager

  • Modify/create database columns

  • Show database columns

  • Save/restore database

  • Edit additional tables

5.9.1.3.3.1.1. Adding/removing database columns

In order to read data into 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.

You reach the dialog Change database column in the PARTlinkManagerviaExtras -> Database -> Modify/create database columns.

How to configure added columns can be found in Section 5.9.1.3.3.2, “ Configure ERP environment ”.

5.9.1.3.3.1.1.1.  Adding database column

Column name :

Define a name.

Column type:

Select a column type in the list field:

CHAR; VARCHAR; SMALLINT; INT; DECIMAL

Length: For text fields a character string length must be indicated.

Default value: Optional

Create ERP column :

If you want to edit the column in PARTlinkManager in the window Modify column display, set a check-mark (recommended).

[Note] Note

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

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

The demo database PLDBDEMO is based on SQLite and there is no possibility to apply different user.

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

  1. Once a column has been successfully added, it is displayed in the Configure dialog box.

    In the Modify column display section the respective column has to be set on visible via Visible entry is Yes.

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

    The entry under Variable DB is fixed.

    The entry under Variable can be adjusted if needed.

    [Note] Note

    You must make sure that exactly this name is continuously used throughout all configurations. (See specifically the next point.)

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

      [Note] Note

      Please regard, which role you have selected under Roles on the left side. The column display is basically role dependent.

    Results 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

    5.9.1.3.3.1.1.2.  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.

    5.9.1.3.3.1.2.  Show database columns

    You can have the columns in the LINKTABLE and ERPTABLE displayed.

    To do so, click on the Extras menu and then Database, Show database columns.

    --> The window Database columns opens.

    5.9.1.3.3.1.3.  Save/restore database

    In order to save the database either use the corresponding database-own administration tools or possibly the PARTsolutions internal dialog under PARTlinkManager -> Extras -> Database -> Save/restore database.

    Under Action, select the option Save database or Restore database.

    Under Settings, select the option Use CSV file or Use external command.

    • Use CSV file:

      If you activate the checkbox under Use common directory, then all tables are saved in the chosen directory with their standard name.

      If you do not activate the option, then specify the desired CSV files via search button ... and activate the respective individual checkboxes.

    • Use external command:

    5.9.1.3.3.1.4.  Editing additional tables in the PARTlinkManager

    In the PARTlinkManager you have the option not only to edit the ERPTABLE and LINKTABLE, but also edit any number of other tables within the LINKDB.

    To do so, follow these steps:

    1. Indicate the tables to be changed in the file %CADENAS_SETUP%/plinkcommon.cfg under the section ADDITIONALTABLES.

      [ADDITIONALTABLES]
#:VALS_S
#:HELP;default;this table is used to store references concerning PLM-systems
t0=PLMTABLE
#:VALS_S
#:HELP;default;this table is used to store Assembly-structures with 
  ERP-information
t1=DATATABLE
#:HELP;default;this table is used to store project-specific data 
  (ie. project specific partnames for CAD-files)
t2=PLMTABLE2

      Add the key "t" followed by a continuously increasing number. As the value for the key, enter the database table.

      t1=DATATABLE

      t2=PLMTABLE2

      etc.

    2. Start the PARTlinkManagerconnect to the database (File -> Connect).

    3. Select the following: Extras -> Database -> Edit additional tables.

    4. Choose the desired table in the selection list under Select table.

      --> The table is displayed in the right half of the window and can now be edited.

    Prev  Up  Next
    5.9.1.3.3.  Extras   Home  5.9.1.3.3.2.  Configure ERP environment