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. Configuration
- 4.7.4. Create and configure roles
- 4.7.4.1. Roles: General " tab page
- 4.7.4.1.1. Dialog box for role selection - plinkgroups.cfg -> Block [Role name] -> Keys "DESC" and "IMAGE"
- 4.7.4.1.2. Preferred series - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE"
- 4.7.4.1.3. Display condition for part selection - Colored catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "CONDITIONTREE"
- 4.7.4.1.4. Display condition for table rows - plinkgroups.cfg -> Block [Role_name] -> Key "TABRESTRICTION"
- 4.7.4.1.5. Filter condition for data records - plinkgroups.cfg -> [role name] -> key "CONDITION"
- 4.7.4.1.6. Columns to be displayed - plinkgroups.cfg -> Block [Role_name] -> Key "VARSUSED / VARSHIDDEN"
- 4.7.4.1.7. Export condition - plinkgroups.cfg -> Block [role name] -> Key "EXPORTRESTRICTION"
- 4.7.4.1.8. Export information (tooltip) at status lights - plinkgroups.cfg -> Block [Role_name] -> Key "TOOLTIPTEXTEXPORTON" / "TOOLTIPTEXTEXPORTOFF"
- 4.7.4.1.9. Release certain directories for export - plinkgroups.cfg -> Block [Role_name] -> Key "EXPPRJTAB" / plinktemplates.cfg
- 4.7.4.1.10. Catalogs to be suppressed / Show only these catalogs - plinkgroups.cfg -> Block [role name] -> Key "HIDELIST" / "EXCLUSIVELIST"
- 4.7.4.1.11. ERP variables visible in search results
- 4.7.4.2. Roles: PDM" tab page
- 4.7.4.3. Rollers: Tabbed page "Display"
- 4.7.4.4. Roles: Tabbed page "E-Mail"
- 4.7.4.5. Roles: Translations " tab page
- 4.7.5. 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. Function characteristic pin on/off / plinkcommon.cfg -> Block [PARTdataManager] -> Key "LockFunctionRange"
- 4.16.4. Login options / plinkcommon.cfg -> Block [PARTdataManager] -> Key "LoginMode"
- 4.16.5. PARTlinkManager: Line color at missing ERP_PDM_NUMBER / plinkcommon.cfg -> Block [COLORS]
- 4.16.6. E-mail settings / plinkcommon.cfg -> Block [MAIL]
- 4.16.7. Custom template for requesting an ERP number by e-mail / plinkcommon.cfg -> Block [MAIL] -> Key "TEMPLATE"
- 4.16.8. Update full-text search index after LinkDB changes / plinkcommon.cfg -> Block [Common] -> Key "UPDATESEARCHINDEX"
- 4.16.9. 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. 3Dfindit Customizing
- 4.21.1. Distributed code
- 4.21.2. Add plugin code
- 4.21.3. Configuration file for 3Dfindit (custom_config.json)
- 4.21.4. Determine default CAD geo search folder (3dfconfig.cfg)
- 4.21.5. Set CAD format download (pappserver.cfg)
- 4.21.6. Determine search template (geomsearch.cfg)
- 4.21.7. Show / hide LinkDB buttons (erpcustom.cfg)
- 4.21.8. Further functionality
- 4.22. Important notes on updating to V12
- 4.22.1. General
- 4.22.2. Installation
- 4.22.3. AppServer V12 - Client Server
- 4.22.3.1. Content of the document
- 4.22.3.2. PARTsolutions Server
- 4.22.3.3. PARTsolutions Client
- 4.22.3.4. SSL encryption
- 4.22.3.4.1. Create certificates on the customer side
- 4.22.3.4.2. Create a self-signed certificate
- 4.22.3.4.3. AppServer Configuration
- 4.22.3.4.4. Check on client side
- 4.22.3.5. Incompatibilities (V12.6)
- 4.22.3.6. Setup ERP environment (V12.6)
- 4.22.3.7. Automatic login
- 4.22.3.8. CAD Client Configuration
- 4.22.3.9. PDM configuration
- 4.22.3.10. 3Dfindit - Specifics
- 4.22.3.11. Web help or locally installed help?
- 4.22.3.12. Checklist
- 4.22.4. AppServer V12 - Index and Tasks
- 4.22.5. Parasolid problem V12 and XT change
- 4.22.6. GeoDb
- 4.22.6.1. Advantages of GeoDb
- 4.22.6.2. Changes in V12.7
- 4.22.6.3. Configuring GeoDb
- 4.22.6.4. Removing obsolete index es
- 4.22.6.5. Files
- 4.22.6.6. Creating GeoDb
- 4.22.6.7. Availability of GeoDb
- 4.22.6.8. New index for variants
- 4.22.6.9. Photo search
- 4.22.7. Parallel use of V11 and V12
- 4.23. Getting started - Demo database
- 4.24. Troubleshooting
- 4.25. PARTlinkManager Reference
- 4.25.1. PARTlinkManager call from start menu
- 4.25.2. Call PARTlinkManager from PARTdataManager
- 4.25.3. Access rights
- 4.25.4. Menus
- 4.25.4.1. File
- 4.25.4.2. View
- 4.25.4.3. Extras
- 4.25.4.3.1. Database
- 4.25.4.3.2. Configure ERP environment
- 4.25.4.3.3. Preferences
- 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. Display filtered datasets
- 4.25.7. Buttons
- 4.25.8. Context menu commands
- 4.25.8.1. Context menu commands: Overview on the different options
- 4.25.8.2. Context menu commands in detail
- 4.25.9. Filtering display
- 4.26. General tips