Table of Contents
- 4.1. Introduction
- 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.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.3. Add / remove database columns
- 4.4. Backup/restore database
- 4.5. PARTapplicationServer Installation/Configuration
- 4.6. Name rule for the CAD file name
- 4.7. Set up 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: General " tab page
- 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 series - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE"
- 4.7.3.1.3. Display condition for part selection - Colored catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "CONDITIONTREE"
- 4.7.3.1.4. Display condition for table rows - plinkgroups.cfg -> Block [Role_name] -> Key "TABRESTRICTION"
- 4.7.3.1.5. Filter condition for data records - 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. Catalogs to be suppressed / Show only these catalogs - plinkgroups.cfg -> Block [role name] -> Key "HIDELIST" / "EXCLUSIVELIST"
- 4.7.3.2. Roles: PDM" tab page
- 4.7.3.3. Rollers: Tabbed page "Display"
- 4.7.3.4. Roles: Tabbed page "E-Mail"
- 4.7.3.5. Roles: Translations " tab page
- 4.7.4. Role sets
- 4.8. ERP toolbar and menu
- 4.9. Table layout for PARTdataManager/3Dfindit and (PARTlinkManager)
- 4.9.1. Customize table values -> Customize 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 (PDataMgr only) / plinkcommon.cfg -> Block [BMPMAPPING_<column_name>] - Key "BMPCODE<number>"
- 4.9.6. Adjust table values -> Set bitmap with condition (PDataMgr only) / 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. Configure column display - plinkcommon.cfg -> Block [LINKDBFIELDS] -
- 4.11. Design "New ident number " dialog box - erpcustom.cfg -> Block [USERDIALOG]
- 4.11.1. SAP / ERP investment dialog - GET function for classification values
- 4.11.2. USERDIALOG Translations
- 4.11.3. material_assign.cfg (with ERP integration)
- 4.11.4. Ignore custom set values for the combobox - Key "USERDIALOG_SKIPDBLOAD"
- 4.11.5. Change default description text for ERP_PDM_NUMBER - erpcustom.cfg -> Block [VARS] -> Key "USERDIALOG_ERPNR"
- 4.12. Manual data administration
- 4.12.1. Creating ERP numbers
- 4.12.1.1. How and from where datasets come into LinkDB? - An overview
- 4.12.1.2. Create ERP number with 3Dfindit / PARTdataManager
- 4.12.1.2.1. Create timestamp ERP number yes/no (3Dfindit)
- 4.12.1.2.2. Create timestamp ERP number yes/no (PARTdataManager)
- 4.12.1.2.3. Create ERP number directly on export
- 4.12.1.2.4. Additional features
- 4.12.1.2.4.1. ERP Number Generator - erpcustom.cfg -> Blocks [ERP_NRGENERATOR] and [ERP_NRGENERATOR_CONDITIONS]
- 4.12.1.2.4.2. Duplicate check in the course of ERP number assignment
- 4.12.1.3. Create ERP number with PARTlinkManager
- 4.12.1.4. Create ERP numbers with PARTdataCenter
- 4.12.2. Create variants in PARTdataManager
- 4.12.3. Create variant in PARTlinkManager
- 4.12.4. Edit variant
- 4.12.5. Editing LinkDB in PARTlinkManager
- 4.12.6. Edit/delete data record with PARTdataManager
- 4.13. Complex workflows for data maintenance
- 4.13.1. Overview
- 4.13.2. Initial filling of the LinkDB / article assignment
- 4.13.3. Updating data
- 4.13.4. Create ERP numbers with direct link to SAP system
- 4.13.5. New application of parts with ERP Gateway
- 4.13.6. Distributed Locations - LinkDB Replication
- 4.14. Index update
- 4.15. Catalog update with ERP integration
- 4.15.1. Catalog update Standard information
- 4.15.2. Standard check on problems with mapping LinkDB entries
- 4.15.3. Catalog update with ERP link - Fix assignment problems with Update Manager
- 4.15.3.1. Catalog update (Tutorial) - Example 1
- 4.15.3.2. Catalog update (Tutorial) - Example 2
- 4.15.3.2.1. Preparations
- 4.15.3.2.2. Catalog update - Download
- 4.15.3.2.3. Assignment / release – Overview on the best approaches
- 4.15.3.2.4. PARTadmin - Check | Compare | Install
- 4.15.3.2.5. PARTlinkManager
- 4.15.3.2.6. Update Manager - Assignment of projects and LinkDB data records
- 4.15.3.3. Install update version
- 4.15.3.4. User interface of Update Manager
- 4.15.3.5. Functions
- 4.15.3.6. Catalog update with ERP link - check assignment problems BEFORE installation (table and 3D view)
- 4.15.3.7. Background information
- 4.15.4. PARTsolutions with LinkDB - Troubleshooting at catalog updates
- 4.16. Further settings in plinkcommon.cfg
- 4.16.1. Keep original row / plinkcommon.cfg -> Block [PARTdataManager] -> Key "KeepOrgRow"
- 4.16.2. Pin dimension feature on/off / plinkcommon.cfg -> Block [PARTdataManager] -> Key "LockDimRange"
- 4.16.3. Login options / plinkcommon.cfg -> Block [PARTdataManager] -> Key "LoginMode"
- 4.16.4. PARTlinkManager: Line color at missing ERP_PDM_NUMBER / plinkcommon.cfg -> Block [COLORS]
- 4.16.5. E-mail settings / plinkcommon.cfg -> Block [MAIL]
- 4.16.6. Custom template for requesting an ERP number by e-mail / plinkcommon.cfg -> Block [MAIL] -> Key "TEMPLATE"
- 4.16.7. Update full-text search index after LinkDB changes / plinkcommon.cfg -> Block [Common] -> Key "UPDATESEARCHINDEX"
- 4.16.8. Standard designation - Standard designation (short) - Adapt parts list designation / plinkcommon.cfg -> Block [PARTdataManager] -> Key "NB" "ShortNB" "LINA"
- 4.17. Translation file "plinkcommon.def"
- 4.18. Further settings in "plinkgroups.cfg"
- 4.18.1. E-mail setting for "New ident number " dialog / plinkgroups.cfg -> Block [<Role_name>] -> Key "SENDTO" "SUBJECT" "SERVER" "ISHTML"
- 4.18.2. Own template for requesting an ERP number by e-mail / plinkgroups.cfg -> Block [<Role_name>] -> Key "TEMPLATE"
- 4.18.3. Standard designation - Standard designation (short) - Adapt parts list designation / plinkgroups.cfg -> Block [<Role_name>] -> Key "NB" "SHORTNB" "LINA"
- 4.19. Translation file "plinkgroups.def"
- 4.20. Further settings in erpcustom.cfg
- 4.20.1. Load additional scripts - erpcustom.cfg -> Block [LOAD]
- 4.20.2. Default value for "ACTIVE_STATE" for new part creation / erpcustom.cfg -> Block [VARS] -> Key "NEWASTATE"
- 4.20.3. Values of the "New ident number " dialog window - erpcustom.cfg -> Block [VARS] -> Key "SENDTO", "SENDFROM", "SUBJECT", "SERVER"
- 4.20.4. Values of the "New ident number " dialog window - erpcustom.cfg -> Block [VARS] -> Key "SENDTO", "SENDFROM", "SUBJECT", "SERVER"
- 4.21. Getting started - Demo database
- 4.22. Troubleshooting
- 4.23. PARTadmin Reference
- 4.24. PARTlinkManager Reference
- 4.24.1. PARTlinkManager call from start menu
- 4.24.2. Call PARTlinkManager from PARTdataManager
- 4.24.3. Access rights
- 4.24.4. Menus
- 4.24.4.1. File
- 4.24.4.2. View
- 4.24.4.3. Extras
- 4.24.4.3.1. Database
- 4.24.4.3.2. Configure ERP environment
- 4.24.4.3.3. Preferences
- 4.24.4.3.4. Catalog update - Update Manager
- 4.24.4.3.5. PARTadmin
- 4.24.4.4. ? (Help)
- 4.24.5. Menu buttons
- 4.24.6. Display filtered datasets
- 4.24.7. Buttons
- 4.24.8. Context menu commands
- 4.24.8.1. Context menu commands: Overview on the different options
- 4.24.8.2. Context menu commands in detail
- 4.24.9. Filtering display
- 4.25. General tips