Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.
You can log in there with your existing account of this site.
The content remains free of charge.
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.
The LinkDB database instance is made up of several tables. Per standard installation, three columns are inserted into the ERPTABLE:
Any other columns in the ERPTABLE can be set up for inserting third system information.
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 ”.
The following describes how to add database columns using PARTlinkManager.
Under File menu -> Connect log in to the database.
Under PARTlinkManager -> Extras menu -> Database click on Modify/create database columns.
-> The dialog box Change database column opens.
For text fields a character string length must be indicated.
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).
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.
So that the column is shown in PARTdataManager, two requirements must be fulfilled:
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.
In PARTadmin, the column has to be entered in all desired roles under Columns to be displayed.
-> 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 ”.
Note | |
---|---|
If the database does not support deleting of columns (such as SQLite for example), the Remove tabbed page is hidden. |