Table of Contents

5.1. Introduction

5.1.1. Integration

5.1.2. Target groups

5.1.3. Entire workflow

5.1.4. Integrating LinkDB

5.1.4.1. Linkage

5.1.4.2. Data transfer and data link

5.1.4.2.1. Cyclical Replication

5.1.4.2.2. Online Replication

5.1.4.2.3. Direct Online linkage of LinkDB to ERP-DB

5.1.4.2.4. New installation of parts using an ERP Interface

5.1.5. User-role concept

5.1.6. Support of company-internal workflows

5.1.7. Modules

5.1.7.1. PARTsolutions/base module ERP linkdb

5.1.7.2. PARTsolutions/base module ERP

5.1.7.3. PARTsolutions/base module ERP CSV

5.2. Installation Link database

5.2.1. Hardware requirements

5.2.2. Database installation per PARTsolutions Setup

5.2.3. Manual database installation

5.2.3.1. Installations script

5.2.3.2. Basic functionality

5.2.3.3. Additional functionalities

5.2.4. ODBC driver

5.2.4.1. ODBC for MSSQL, Oracle

5.2.4.2. ODBC installation during installation routine

5.2.4.3. Set up ODBC manually

5.2.5. JDBC driver

5.2.5.1. Installation

5.2.5.2. Configuration

5.2.5.3. Jar files for other databases

5.2.6. Database connection via file DSN

5.3. Adding/removing database columns

5.3.1. Apply databases columns per SQL Scripting

5.3.2. Adding database column with PARTlinkManager

5.3.3. Set column visible in PARTdataManager

5.3.4. Removing database column

5.4. Save/restore database

5.5. PARTapplicationServer installation/configuration

5.5.1. General

5.5.2. Overview Multi Site Installation

5.5.3. Licenses for the PARTapplicationServer

5.5.4. PARTapplicationServer - Installation

5.5.5. Set up PARTapplicationServer as service

5.5.6. PARTapplicationServer - Configuration

5.5.6.1. AppServer: Client configuration

5.5.6.1.1. The respective keys and values of the configuration file

5.5.6.1.2. Key combinations and values of the single GUI options

5.5.6.1.3. Global and local specification of the settings - Privileges for Admin

5.5.6.1.4. Caching client-sided

5.5.6.2. PARTapplicationServer: Server configuration

5.5.6.2.1. Caching index files of $CADENAS_DATA on PARTapplicationServer

5.5.6.2.2. LinkDB queries

5.5.6.2.3. Updates of ERP search index

5.5.6.2.3.1. Logging of LinkDB changes

5.5.6.2.3.2. Manual update and initial creation of LinkDB search index

5.5.6.3. SSL encryption

5.5.7. PARTapplicationServer Watch

5.5.8. Set up ERP on PARTapplicationServer

5.5.8.1. Overview on client connection mode to link database and login mode in PARTdataManager

5.5.8.2. Example 1: Database connection via AppServer and manual user login

5.5.8.3. Example 2: Database connection via AppServer and automatic user login

5.5.8.4. Example 3: Direct database connection and manual user login

5.5.8.5. Example 4: Direct database connection and automatic user login

5.5.8.6. Troubleshooting

5.5.9. More information

5.6. Name rule for the CAD file name

5.7. ERP toolbar and menu

5.8. Table layout for PARTdataManager and (PARTlinkManager)

5.8.1. Adjust table values -> Adjust text / plinkcommon.cfg -> Block [MAPPING_<COLUMN_NAME>] - Key for visible text

5.8.2. Adjust table values -> Adjust color / plinkcommon.cfg -> Block [COLMAPPING_<variable name>] - Key COLORCODE<number>

5.8.3. Adjust table values -> Adjust text and color / plinkcommon.cfg -> Block [MAPPING_<variable name>] -> Key for visible text

5.8.4. Adjust table values -> Adjust color with condition / plinkcommon.cfg -> Block [COLMAPPING_<column name>] -> Key "COLORCOND<number>"

5.8.5. Adjust table values > Set bitmap / plinkcommon.cfg -> Block [BMPMAPPING_<column name>] -> Key "BMPCODE<number>"

5.8.6. Adjust table values -> Set bitmap with condition / plinkcommon.cfg -> Block [BMPMAPPING_<column name>] -> Key "BMPCOND<number>"

5.8.7. Background color for ERP/PDM columns - plinkcommon.cfg -> Block [GROUP_COLORS] -> Key GROUP

5.9. Configure new ident-no. dialog box

5.9.1. Basic design of "new ident-no." dialog box - erpcustom.cfg -> Block [USERDIALOG]

5.9.1.1. Ignore custom set values for the combobox - Key "USERDIALOG_SKIPDBLOAD"

5.9.2. Change default description text for ERP_PDM_NUMBER - erpcustom.cfg -> Block [VARS] -> Key "USERDIALOG_ERPNR"

5.9.3. erpcustom.cfg -> Block [dialogOnExport] - Automatic generation of ERP number: Export dialog for material and other fields yes/no

5.9.4. Automatically generated ERP_PDM_NUMBER at new creation of parts (on/off) - erpcustom.cfg -> Block [VARS] -> Key "TIMESTAMPNR"

5.9.5. ERP Number Generator - erpcustom.cfg -> Blocks [ERP_NRGENERATOR] und [ERP_NRGENERATOR_CONDITIONS]

5.9.5.1. Prerequisites

5.9.5.1.1. SQL commands for applying the "Sequencer" table in the LinkDB

5.9.5.1.1.1. CNSSEQ Table

5.9.5.1.2. Activating ERP Number Generator

5.9.5.2. Incorporate ERP number into the PARTdataManager

5.9.5.3. Further number generations based on the example of the default setting

5.9.5.4. Adjust conditions for number generation

5.10. User-role concept

5.10.1. Create database users

5.10.1.1. User creation via database-inherent administration

5.10.1.2. Apply user via PARTadmin

5.10.2. Apply users in PARTsolutions

5.10.3. Create and configure roles

5.10.4. User-Role assignment

5.11. Configure roles

5.11.1. Tabbed page "General"

5.11.1.1. Dialog box for role selection - plinkgroups.cfg -> Block [Role name] -> Keys "DESC" and "IMAGE"

5.11.1.2. Preferred ranges - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE"

5.11.1.3. Display condition for parts selection - Colored catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "CONDITIONTREE"

5.11.1.4. Viewing condition for table rows - plinkgroups.cfg -> Block [Role_name] -> Key "TABRESTRICTION"

5.11.1.5. Show table row but hide LinkDB content - plinkgroups.cfg -> [Role_name] -> Key "CONDITION"

5.11.1.6. Columns to be displayed - plinkgroups.cfg -> Block [Role_name] -> Key "VARSUSED / VARSHIDDEN"

5.11.1.7. Export condition - plinkgroups.cfg -> Block [Role_name] -> Key "EXPORTRESTRICTION"

5.11.1.8. Export information (tooltip) at status lights - plinkgroups.cfg -> Block [Role_name] -> Key "TOOLTIPTEXTEXPORTON" / "TOOLTIPTEXTEXPORTOFF"

5.11.1.9. Release certain directories for export - plinkgroups.cfg -> Block [Role_name] -> Key "EXPPRJTAB"

5.11.1.10. Hide catalogs - plinkgroups.cfg -> Block [Role name] -> Key "HIDELIST"

5.11.2. Tabbed page "PDM"

5.11.3. Tabbed page "Display"

5.11.3.1. Status indicating icons in table - plinkgroups.cfg -> Block [<Role_name>] - Key "BMPCONDITION0"

5.11.3.2. Status colors for catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "COLORCONDITIONTREE<number>"

5.11.4. Request ERP number per e-mail

5.11.5. Tabbed page "Translations"

5.12. Manual data administration

5.12.1. Creation of ERP numbers

5.12.1.1. Using PARTdataManager

5.12.1.1.1. Without direct linkage to the ERP system

5.12.1.1.1.1. Manual entry of ERP number

5.12.1.1.2. Applying ERP numbers using an online gateway to the SAP system

5.12.1.2. Using PARTlinkManager

5.12.1.2.1. Enter ERP number with PARTlinkManager

5.12.1.2.2. Import a project into LINKDB – Assign ERP number

5.12.1.3. PARTdataCenter

5.12.2. Edit variant / Create variant in PARTlinkManager

5.12.3. Create variants in PARTdataManager

5.12.4. Editing LinkDB in PARTlinkManager

5.12.4.1. Editing columns

5.12.4.2. Edit row

5.12.5. Delete datasets

5.12.6. Edit/delete dataset using PARTdataManager

5.13. Complex workflows for data maintenance

5.13.1. Overview

5.13.2. Initial filling of the LinkDB / Article assignment

5.13.2.1. Data export per CSV with an example from SAP

5.13.2.1.1. Manual export

5.13.2.1.2. Automated Export

5.13.2.2. Complexity assessment

5.13.3. Updating data

5.13.3.1. Online replication

5.13.3.2. Cyclic replication

5.13.3.3. Automated and cyclical update of data

5.13.3.4. Direct online linkage of the LinkDB to the ERP-DB

5.13.4. New application of parts with ERP Gateway

5.13.5. Distributed Locations - LinkDB Replication

5.14. Index update

5.15. Catalog update

5.15.1. PARTadmin - Catalog update

5.15.2. Catalog update with ERP integration - Update manager

5.15.2.1. Catalog update - Example 1

5.15.2.1.1. Preparations

5.15.2.1.2. Catalog update - Download

5.15.2.1.3. Assignment / release – Overview on the best approaches

5.15.2.1.4. PARTadmin - Check | Compare | Install

5.15.2.1.5. PARTlinkManager - Important notes on procedure

5.15.2.1.6. Update manager - Project assignment to LinkDB datasets

5.15.2.1.6.1. Update manager - Assign projects after mapping automatically processed before

5.15.2.1.6.1.1. Assign project.prj (Standard name adjusted)

5.15.2.1.6.1.2. Assign project2.prj (Adjusted directory)

5.15.2.1.6.1.3. Assign project4.prj (directory relocated and Standard name adjusted)

5.15.2.1.6.2. Update manager - Assign projects without preceding mapping

5.15.2.1.6.2.1. Assign project3.prj (project and Standard number renamed)

5.15.2.1.6.2.2. Assign project5.prj (project and Standard number renamed and Standard name adjusted)

5.15.2.1.6.2.3. Assign project6.prj and project7.prj

5.15.2.1.6.3. Final check

5.15.2.2. Catalog update - Example 2

5.15.2.2.1. Preparation

5.15.2.2.2. Status after update installation to Bikecompany V2 and before editing with Update Manager

5.15.2.2.3. Editing in Update manager

5.15.2.3. Install update version

5.15.2.3.1. Update without connection to the LinkDB

5.15.2.3.2. Correct version numbers

5.15.2.3.3. Update structure table

5.15.2.4. User interface of Update Manager

5.15.2.4.1. Symbols in the Catalogs section

5.15.2.4.2. Symbols in the Line mapping section

5.15.2.5. Functions

5.15.2.5.1. Active State and Requested State

5.15.2.5.2. Changed standard name

5.15.2.5.3. Moved dataset

5.15.2.5.4. No correlation to the old dataset found

5.15.2.5.5. Conduct assignments across lines

5.15.2.6. Background information

5.16. Load additional scripts - erpcustom.cfg -> Block [LOAD]

5.17. ERP for single parts in assembly tables

5.17.1. Preparations in order to put the functionality into practice

5.17.2. Loading the assembly in the PARTdataManager

5.17.2.1. Assembly without ERP number

5.17.2.2. Assembly with ERP numbers

5.17.3. Scripting - further possibilities

5.18. Getting started - Demo database

5.18.1. Features

5.18.2. Subsequent installation of PLDBDEMO instance

5.18.3. ERP activation / deactivation

5.19. Troubleshooting

5.19.1. Link database troubleshooting

5.19.1.1. Disabling Journaling on DB2/400

5.19.1.2. Database login - Error message

5.20. PARTadmin Reference

5.20.1. Menus

5.20.1.1. File

5.20.1.2. ? (Help)

5.20.2. Icons

5.20.3. ERP environment settings

5.20.3.1. Idle time - Connect LinkDB

5.20.3.2. Try NT user authentication

5.20.3.3. Enable automatic login

5.20.3.4. Define Database interface

5.20.4. "Roles" dialog - Buttons

5.20.5. "Roles" dialog - Tabbed pages

5.20.5.1. Tabbed page "General"

5.20.5.2. Tabbed page "PDM"

5.20.5.3. Tabbed page "Display"

5.20.5.4. Tabbed page "Mail"

5.20.5.5. Tabbed page "Translations"

5.20.5.6. Tabbed pages Standard name , Standard name (short) , BOM name

5.20.5.6.1. Syntax

5.20.5.6.2. Examples

5.20.5.6.3. Change NB according to project

5.20.5.6.4. Change NB via vbs scripting

5.21. PARTlinkManager reference

5.21.1. PARTlinkManager: Launch from Start menu

5.21.1.1. License selection dialog box at Floating licensing

5.21.2. Launch PARTlinkManager from PARTdataManager

5.21.3. Authorization rights

5.21.4. Menus

5.21.4.1. File

5.21.4.1.1. Connect

5.21.4.1.2. Connect as...

5.21.4.1.3. Switch role

5.21.4.1.4. Disconnect

5.21.4.1.5. Export as -> CSV table

5.21.4.1.6. Import

5.21.4.1.7. Execute Script

5.21.4.1.8. Exit

5.21.4.2. View

5.21.4.2.1. Show tree

5.21.4.2.2. Display filtered tree

5.21.4.2.3. Hide old versions of parts

5.21.4.3. Extras

5.21.4.3.1. Database

5.21.4.3.1.1. Adding/removing database columns

5.21.4.3.1.1.1. Apply databases columns per SQL Scripting

5.21.4.3.1.1.2. Adding database column with PARTlinkManager

5.21.4.3.1.1.3. Set column visible in PARTdataManager

5.21.4.3.1.1.4. Removing database column

5.21.4.3.1.2. Show database columns

5.21.4.3.1.3. Save/restore database

5.21.4.3.1.4. Editing additional tables in the PARTlinkManager

5.21.4.3.2. Configure ERP environment

5.21.4.3.2.1. Tabbed page "PARTlinkManager preferences"

5.21.4.3.2.1.1. Set row color

5.21.4.3.2.1.2. Group definitions / Set column color

5.21.4.3.2.1.3. Adjust table values

5.21.4.3.2.1.4. Modify column display

5.21.4.3.2.1.5. Column position in PARTlinkManager

5.21.4.3.2.2. Tabbed page "PARTdataManager preferences"

5.21.4.3.2.2.1. Login mode

5.21.4.3.2.2.2. e-mail notification

5.21.4.3.2.3. Tabbed page "Database"

5.21.4.3.2.4. Tabbed page "Export tables"

5.21.4.3.2.5. Tabbed page "Translations"

5.21.4.3.2.6. Tabbed pages "Standard name", "Standard name (short)", "BOM name"

5.21.4.3.3. Preferences

5.21.4.3.3.1. PARTlinkManager - Search fields

5.21.4.3.3.2. Network

5.21.4.3.3.3. Logging settings

5.21.4.3.4. Catalog update - Update manager

5.21.4.3.5. PARTadmin

5.21.4.4. ? (Help)

5.21.5. Menu buttons

5.21.6. Buttons

5.21.7. Context menu

5.21.7.1. Set fields

5.21.7.2. Duplicate

5.21.7.3. Edit variant

5.21.7.4. Create variant

5.21.7.5. Assign ERP numbers / delete

5.21.7.6. Import project into database

5.21.7.7. Edit project table

5.21.7.7.1. Change standard descriptions according to project

5.21.7.7.2. Explicitly specify sorting order of variants for PARTdataManager table

5.21.7.7.3. Column sorting of geometry columns in PARTdataManager

5.21.7.7.4. Update structure table

5.21.8. Filtering display