powered by CADENAS

Manual

Manual

3.3.8.11.2. Customizing the PARTsolutions ERP interface

$CADENAS_SETUP/ erpcustom.cfg:

Section [VARS]
The following entries can be made for each group/role. Thereby the behavior of PARTsolutions can be adjusted on group level.
Example: [VARS(Rolle1)]
ERPFIELDDB=ERP_PDM_NUMBER
Enter the variable name of the database column (Variable) here. You can adjust it in PARTlinkManager under Extras menu -> Configure ERP environment.
ERPFIELDLoc=
If you enter a database field here, then the ERP number is copied into this field (especially for multiple location solutions).
TIMESTAMPNR=0/1
0: The ERP number inserted by you, or the number returned back by your ERP system is inserted in the link database.
1: A so-called timestamp number is generated and inserted in the link database. This is only required or makes sense in special cases, e.g. at systems working across locations.
ERPADD=$CADENAS_SETUP/erpadd.cfg
Path to a definition file, where additional values from the PARTsolutions table can be exported into the ERP system.
Here in square brackets the paths to the PARTsolutions project files (part families) are stated, including the identifiers for the ERP system with the variable names from the PARTsolutions table. A variable name starts with the $ sign and ends with the . (point).
CLASS=
e.g. CLASSVARLIST(eclass)
The stated entry is searched in the respective PARTsolutions project file and exported into the ERP system. Thereby an automatic part classification and attribute assignment can be performed.
SENDTO=standardisation@company.com
Address of e-mail recipient when requesting a new ERP number via e-mail.
SENDFROM=user@company.com
Address of e-mail sender when requesting a new ERP number via e-mail.
SUBJECT=subject
Subject line for the e-mail process.
SERVER=mail.company
The name of your e-mail server when requesting a new ERP number via e-mail.
NEWASTATE=1
Status of new applied parts.
Possible values are 0 (locked), 1 (released) and 2 (expired).
IFACEEXE=$CADENAS/iface/sap/sapcadenassrv.exe
The path to the ERP interface.
In the case of the SAP interface here the files sapcadenassrv.ini, saplogon.ini and saprfc.ini are stated. With the help of these configuration files customer-specific settings can be made, e.g. host names, field defaults, etc.
The documentation on these settings is found in the files itself.
Block [MAPPING]
States the relations between variable name of ERP system and variable names of link database.
For example: The name of the SAP material field is "BASIC_MATL_NEW" and the corresponding name in the link database is MAT_NAME. In this case the needed entry would be:
BASIC_MATL_NEW=MAT_NAME
Block [LOAD]
Here you can define a list of scripts to be loaded when the application is started. Therein always the function "execute" is executed.
Block [BEFTBLLOAD]
Here you can define a list of scripts to be loaded before loading the single table. Therein always the function "execute" is executed.
Block [AFTTBLLOAD]
Here you can define a list of scripts to be loaded after loading and display of the single table. Therein always the function "execute" is executed.
Block [MAIL]
Here you can define a list of scripts to be loaded when clicking the button "Request ERP number per e-mail". Therein always the function "execute" is executed.
Block [ADDTODB]
Here you can define a list of scripts to be loaded when clicking the button "Add dataset to link database". Therein always the function "execute" is executed.