Chapter 4. Strategic Parts Management
Prev  Next

Chapter 4. Strategic Parts Management

Table of Contents

4.1. Introduction
4.1.1. Integration
4.1.2. Target groups
4.1.3. Entire workflow
4.1.4. Integrating LinkDB
4.1.4.1. Linkage
4.1.4.2. Data transfer and data link
4.1.4.2.1. Cyclical Replication
4.1.4.2.2. Online Replication
4.1.4.2.3. Direct Online linkage of LinkDB to ERP-DB
4.1.4.2.4. New installation of parts using an ERP Interface
4.1.5. User-Role concept
4.1.6. Support of company-internal workflows
4.1.7. Modules
4.1.7.1. PARTsolutions/base module ERP linkdb
4.1.7.2. PARTsolutions/base module ERP
4.1.7.3. PARTsolutions/base module ERP CSV
4.2. Installation Link database
4.2.1. Hardware requirements
4.2.2. PARTsolutions Enterprise Setup
4.2.3. Configuration of the database server connection (exemplified by MSSQL)
4.2.4. Create database scheme and users for ERP (exemplified by MSSQL)
4.2.4.1. Installation scripts
4.2.4.2. Explanation on the database tables
4.2.5. Set up ODBC data source
4.2.6. JDBC driver
4.2.7. ERP connectivity from PARTsolutions via ODBC/JDBC and ERP activation
4.2.7.1. plinkcommon.cfg -> Block [Common] -> Key "DBName" - Determine ODBC data source name in PARTsolutions
4.2.7.2. plinkcommon.cfg -> Block [PARTdataManager] -> Keys "ERPenabled" and "ERPenabledPPrj" - Activate ERP
4.2.7.3. Configuration database login
4.3. Adding/removing database columns
4.3.1. Apply databases columns per SQL Scripting
4.3.2. Adding database column with PARTlinkManager
4.3.3. Set column visible in PARTdataManager
4.3.4. Removing database column
4.4. Save/restore database
4.5. PARTapplicationServer Installation/Configuration
4.6. Name rule for the CAD file name
4.7. Setup ERP environment
4.7.1. ERP environment - Overview
4.7.2. Database connection
4.7.3. Create and configure roles
4.7.3.1. Roles: Tabbed page "General"
4.7.3.1.1. Dialog box for role selection - plinkgroups.cfg -> Block [Role name] -> Keys "DESC" and "IMAGE"
4.7.3.1.2. Preferred ranges - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE"
4.7.3.1.3. Display condition for parts selection - Colored catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "CONDITIONTREE"
4.7.3.1.4. Viewing condition for table rows - plinkgroups.cfg -> Block [Role_name] -> Key "TABRESTRICTION"
4.7.3.1.5. Filter condition for datasets - plinkgroups.cfg -> [Role_name] -> Key "CONDITION"
4.7.3.1.6. Columns to be displayed - plinkgroups.cfg -> Block [Role_name] -> Key "VARSUSED / VARSHIDDEN"
4.7.3.1.7. Export condition - plinkgroups.cfg -> Block [Role_name] -> Key "EXPORTRESTRICTION"
4.7.3.1.8. Export information (tooltip) at status lights - plinkgroups.cfg -> Block [Role_name] -> Key "TOOLTIPTEXTEXPORTON" / "TOOLTIPTEXTEXPORTOFF"
4.7.3.1.9. Release certain directories for export - plinkgroups.cfg -> Block [Role_name] -> Key "EXPPRJTAB" / plinktemplates.cfg
4.7.3.1.10. Hide catalogs - plinkgroups.cfg -> Block [Role name] -> Key "HIDELIST"
4.7.3.2. Roles: tabbed page "PDM"
4.7.3.3. Roles: Tabbed page "Display"
4.7.3.3.1. Status indicating icons in table - plinkgroups.cfg -> Block [<Role_name>] - Key "BMPCONDITION0"
4.7.3.3.2. Status colors for catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "COLORCONDITIONTREE<number>"
4.7.3.4. Roles: Tabbed page "E-mail"
4.7.3.5. Roles: Tabbed page "Translations"
4.7.4. Role sets
4.7.4.1. Mapping Role set - Roles / plinkusers.cfg -> [<Role name>] -> Key "GROUPS"
4.7.4.2. plinkcommon.cfg -> Block [Common] -> Key "CADENAS_PRESELECT_LINKDB_GROUP" - Role selection by environment variable
4.8. ERP toolbar and menu
4.9. Table layout for PARTdataManager and (PARTlinkManager)
4.9.1. Adjust table values -> Adjust text / plinkcommon.cfg -> Block [MAPPING_<COLUMN_NAME>] - Key for visible text
4.9.2. Adjust table values -> Adjust color / plinkcommon.cfg -> Block [COLMAPPING_<variable name>] - Key COLORCODE<number>
4.9.3. Adjust table values -> Adjust text and color / plinkcommon.cfg -> Block [MAPPING_<variable name>] -> Key for visible text
4.9.4. Adjust table values -> Adjust color with condition / plinkcommon.cfg -> Block [COLMAPPING_<column name>] -> Key "COLORCOND<number>"
4.9.5. Adjust table values > Set bitmap / plinkcommon.cfg -> Block [BMPMAPPING_<column name>] -> Key "BMPCODE<number>"
4.9.6. Adjust table values -> Set bitmap with condition / plinkcommon.cfg -> Block [BMPMAPPING_<column name>] -> Key "BMPCOND<number>"
4.9.7. Background color for ERP/PDM columns / plinkcommon.cfg -> Block [GROUP_COLORS] -> Key GROUP<number>
4.9.8. Determine column color by indicator in ERP column (very special) / plinkgroups.cfg -> Block [<Role_name>] -> Key "COLORNUMBERTREE"
4.10. Modify column display - plinkcommon.cfg -> Block [LINKDBFIELDS]
4.11. Basic design of "new ident-no." dialog box - erpcustom.cfg -> Block [USERDIALOG]
4.11.1. material_assign.cfg (with ERP integration)
4.11.2. Ignore custom set values for the combobox - Key "USERDIALOG_SKIPDBLOAD"
4.11.3. Change default description text for ERP_PDM_NUMBER - erpcustom.cfg -> Block [VARS] -> Key "USERDIALOG_ERPNR"
4.12. Timestamp number on/off
4.12.1. Automatically generated ERP_PDM_NUMBER at new creation of parts (on/off) - erpcustom.cfg -> Block [VARS] -> Key "TIMESTAMPNR"
4.12.2. erpcustom.cfg -> Block [dialogOnExport] - Automatic generation of ERP number: Export dialog for material and other fields yes/no
4.12.3. ERP Number Generator - erpcustom.cfg -> Blocks [ERP_NRGENERATOR] und [ERP_NRGENERATOR_CONDITIONS]
4.12.3.1. Prerequisites
4.12.3.1.1. SQL commands for applying the "Sequencer" table in the LinkDB
4.12.3.1.1.1. CNSSEQ Table
4.12.3.1.2. Activating ERP Number Generator
4.12.3.2. Incorporate ERP number into the PARTdataManager
4.12.3.3. Further number generations based on the example of the default setting
4.12.3.4. Adjust conditions for number generation
4.13. Manual data administration
4.13.1. Creation of ERP numbers
4.13.1.1. Using PARTdataManager
4.13.1.1.1. Without direct linkage to the ERP system
4.13.1.1.1.1. Manual entry of ERP number
4.13.1.1.2. Applying ERP numbers using an online gateway to the SAP system
4.13.1.2. Using PARTlinkManager
4.13.1.2.1. Enter ERP number with PARTlinkManager
4.13.1.2.2. Import a project into LINKDB – Assign ERP number
4.13.1.3. PARTdataCenter
4.13.2. Edit variant / Create variant in PARTlinkManager
4.13.3. Create variants in PARTdataManager
4.13.4. Editing LinkDB in PARTlinkManager
4.13.4.1. Editing columns
4.13.4.2. Edit row
4.13.5. Delete datasets
4.13.6. Edit/delete dataset using PARTdataManager
4.14. Complex workflows for data maintenance
4.14.1. Overview
4.14.2. Initial filling of the LinkDB / Article assignment
4.14.2.1. Data export per CSV with an example from SAP
4.14.2.1.1. Manual export
4.14.2.1.2. Automated Export
4.14.2.2. Complexity assessment
4.14.3. Updating data
4.14.3.1. Online replication
4.14.3.2. Cyclic replication
4.14.3.3. Automated and cyclical update of data
4.14.3.4. Direct online linkage of the LinkDB to the ERP-DB
4.14.3.5. Configuration file nightupdate.cfg
4.14.3.5.1. Block [LOG]
4.14.3.5.2. Block [MISC]
4.14.3.5.3. Block [LOAD]
4.14.3.5.4. Block [ERPTABLE-IDENTIFY-COLUMNS]
4.14.3.5.5. Block [ERPTABLE-UPDATE-COLUMNS]
4.14.4. New application of parts with ERP Gateway
4.14.5. Distributed Locations - LinkDB Replication
4.15. Index update
4.16. Catalog update with ERP integration
4.16.1. Catalog update Standard information
4.16.2. Standard check on problems with mapping LinkDB entries
4.16.3. Catalog update with ERP integration - Fix mapping problems with the Update manager
4.16.3.1. Catalog update (Tutorial) - Example 1
4.16.3.1.1. Preparation
4.16.3.1.2. Status after update installation to Bikecompany V2 and before editing with Update Manager
4.16.3.1.3. Editing in Update manager
4.16.3.2. Catalog update (Tutorial) - Example 2
4.16.3.2.1. Preparations
4.16.3.2.2. Catalog update - Download
4.16.3.2.3. Assignment / release – Overview on the best approaches
4.16.3.2.4. PARTadmin - Check | Compare | Install
4.16.3.2.5. PARTlinkManager
4.16.3.2.6. Update manager - Project assignment to LinkDB datasets
4.16.3.2.6.1. Update manager - Projects with simple process of assignment
4.16.3.2.6.1.1. Assign project.prj (Standard name adjusted)
4.16.3.2.6.1.2. Assign project2.prj (Adjusted directory)
4.16.3.2.6.1.3. Assign project4.prj (directory relocated and Standard name adjusted)
4.16.3.2.6.2. Update manager - Projects with more complex process of assignment
4.16.3.2.6.2.1. Assign project3.prj (project and Standard number renamed)
4.16.3.2.6.2.2. Assign project5.prj
4.16.3.2.6.2.3. Assign project6.prj
4.16.3.2.6.2.4. Assign project7.prj
4.16.3.2.6.3. Final check
4.16.3.3. Install update version
4.16.3.3.1. Update without connection to the LinkDB
4.16.3.3.2. Correct version numbers
4.16.3.3.3. Update structure table
4.16.3.4. User interface of Update Manager
4.16.3.4.1. Symbols in the Catalogs section
4.16.3.4.2. Symbols in the Line mapping section
4.16.3.5. Functions
4.16.3.5.1. ACTIVE_STATE and REQUESTED_STATE
4.16.3.5.2. Changed standard name
4.16.3.5.3. Moved dataset
4.16.3.5.4. No correlation to the old dataset found
4.16.3.5.5. Conduct assignments across lines
4.16.3.6. Catalog update with ERP integration - Check LinkDB mapping problems BEFORE installation (table and 3D view)
4.16.3.7. Background information
4.16.4. PARTsolutions with LinkDB - Troubleshooting at catalog updates
4.16.4.1. Revising / Updating the LinkDB
4.16.4.2. Manual revision via parameter calls
4.17. Further settings in plinkcommon.cfg
4.17.1. Try NT user authentication / plinkcommon.cfg -> Block [Login] -> Key "NTUSERAUTH"
4.17.2. Pinning Dimension attribute OnOff / plinkcommon.cfg -> Block [PARTdataManager] -> Key "LockDimRange"
4.17.2.1. Background information
4.17.3. Login options / plinkcommon.cfg -> Block [PARTdataManager] -> Key "LoginMode"
4.17.4. PARTlinkManager: Line color at missing ERP_PDM_NUMBER / plinkcommon.cfg -> Block [COLORS]
4.17.5. E-mail settings / plinkcommon.cfg -> Block [MAIL]
4.17.6. Own template for Request ERP number per e-mail / plinkcommon.cfg -> Block [MAIL] -> Key "TEMPLATE"
4.17.7. ERP for single parts in assembly tables / plinkcommon.cfg -> Block [PARTdataManager] -> Key "UseErpForAssPart"
4.17.7.1. Preparations in order to put the functionality into practice
4.17.7.2. Loading the assembly in the PARTdataManager
4.17.7.2.1. Assembly without ERP number
4.17.7.2.2. Assembly with ERP numbers
4.17.7.3. Scripting - further possibilities
4.17.8. Update full-text search index / plinkcommon.cfg -> Block [Common] -> Key "UPDATESEARCHINDEX"
4.17.9. Adjust Standard name - Standard name (short) - BOM name / plinkcommon.cfg -> Block [PARTdataManager] -> Keys "NB" "ShortNB" "LINA"
4.18. Translation file "plinkcommon.def"
4.19. Further settings in "plinkgroups.cfg"
4.19.1. E-mail settings for "new ident-no." dialog / plinkgroups.cfg -> Block [<Role_name>] -> Keys "SENDTO" "SUBJECT" "SERVER" "ISHTML"
4.19.2. Own template for Request ERP number per e-mail / plinkgroups.cfg -> Block [<Role_name>] -> Key "TEMPLATE"
4.19.3. Adjust Standard name - Standard name (short) - BOM name / plinkcommon.cfg -> Block [PARTdataManager] -> Keys "NB" "ShortNB" "LINA"
4.20. Translation file "plinkgroups.def"
4.21. Further settings in erpcustom.cfg
4.21.1. Load additional scripts - erpcustom.cfg -> Block [LOAD]
4.21.2. Default value for new "ACTIVE_STATE" values - erpcustom.cfg -> Block [VARS] -> Key "NEWASTATE"
4.22. Getting started - Demo database
4.22.1. Features
4.22.2. Subsequent installation of PLDBDEMO instance
4.22.3. ERP activation / deactivation
4.23. Troubleshooting
4.23.1. Link database troubleshooting
4.23.1.1. Disabling Journaling on DB2/400
4.23.1.2. Database login - Error message
4.24. PARTadmin Reference
4.24.1. Menus
4.24.1.1. File
4.24.1.2. ? (Help)
4.24.2. Icons
4.24.3. ERP environment settings
4.24.3.1. Idle time - Connect LinkDB
4.24.3.2. Enable automatic login
4.24.3.3. Define Database interface
4.24.4. "Roles" dialog - Buttons
4.24.5. "Roles" dialog - Tabbed pages
4.24.5.1. Tabbed page "General"
4.24.5.2. Tabbed page "PDM"
4.24.5.3. Tabbed page "Display"
4.24.5.4. Tabbed page "Mail"
4.24.5.5. Tabbed page "Translations"
4.24.5.6. Tabbed pages "Standard name", "Standard name (short)", "BOM name"
4.25. PARTlinkManager reference
4.25.1. PARTlinkManager: Launch from Start menu
4.25.1.1. License selection dialog box at License Server licensing
4.25.2. Launch PARTlinkManager from PARTdataManager
4.25.3. Authorization rights
4.25.4. Menus
4.25.4.1. File
4.25.4.1.1. Connect
4.25.4.1.2. Connect as...
4.25.4.1.3. Switch role
4.25.4.1.4. Disconnect
4.25.4.1.5. Export as -> CSV table
4.25.4.1.6. Import
4.25.4.1.7. Execute Script
4.25.4.1.8. Exit
4.25.4.2. View
4.25.4.2.1. Show tree
4.25.4.2.2. Display filtered tree
4.25.4.2.3. Hide old versions of parts
4.25.4.3. Extras
4.25.4.3.1. Database
4.25.4.3.1.1. Adding/removing database columns
4.25.4.3.1.1.1. Apply databases columns per SQL Scripting
4.25.4.3.1.1.2. Adding database column with PARTlinkManager
4.25.4.3.1.1.3. Set column visible in PARTdataManager
4.25.4.3.1.1.4. Removing database column
4.25.4.3.1.2. Show database columns
4.25.4.3.1.3. Save/restore database
4.25.4.3.1.4. Editing additional tables in the PARTlinkManager
4.25.4.3.2. Configure ERP environment
4.25.4.3.2.1. Tabbed page "PARTlinkManager preferences"
4.25.4.3.2.1.1. Set row color
4.25.4.3.2.1.2. Group definitions / Set column color
4.25.4.3.2.1.3. Adjust table values
4.25.4.3.2.1.4. Modify column display
4.25.4.3.2.1.5. Column position in PARTlinkManager
4.25.4.3.2.2. Tabbed page "PARTdataManager preferences"
4.25.4.3.2.2.1. Login mode
4.25.4.3.2.2.2. e-mail notification
4.25.4.3.2.3. Tabbed page "Database"
4.25.4.3.2.4. Tabbed page "Export tables"
4.25.4.3.2.5. Tabbed page "Translations"
4.25.4.3.2.6. Tabbed pages "Standard name", "Standard name (short)", "BOM name"
4.25.4.3.2.6.1. Examples
4.25.4.3.2.6.2. Change NB via vbs scripting
4.25.4.3.2.6.3. Change NB according to project
4.25.4.3.2.6.4. Syntax
4.25.4.3.3. Preferences
4.25.4.3.3.1. PARTlinkManager - Search fields
4.25.4.3.3.2. Network
4.25.4.3.3.3. Logging settings
4.25.4.3.4. Catalog update - Update manager
4.25.4.3.5. PARTadmin
4.25.4.4. ? (Help)
4.25.5. Menu buttons
4.25.6. Buttons
4.25.7. Context menu
4.25.7.1. Set fields
4.25.7.2. Duplicate
4.25.7.3. Edit variant
4.25.7.4. Create variant
4.25.7.5. Assign ERP numbers / delete
4.25.7.6. Import project into database
4.25.7.7. Edit project table
4.25.7.7.1. Change standard descriptions according to project
4.25.7.7.2. Explicitly specify sorting order of variants for PARTdataManager table
4.25.7.7.3. Column sorting of geometry columns in PARTdataManager
4.25.7.7.4. Update structure table
4.25.8. Filtering display
Prev   Next
3.3.4. More systems Home 4.1. Introduction