5.22.  Further settings in erpcustom.cfg

$CADENAS_SETUP/ erpcustom.cfg :

This configuration file is used in order to customize ERP processing.

The file is subdivided in a couple of blocks:

USERDIALOG, VARS, LOAD, BEFTBLLOAD, AFTTBLLOAD, MAIL, ADDTODB

The entries can be entered per group (role). This allows the behavior of ENTERPRISE 3Dfindit to be adapted at role level.

  • Block [VARS]

    The VARS block contains general keys.

    The following entries can be made per group (role). This allows the behavior of ENTERPRISE 3Dfindit to be adapted to specific roles.

    Example:

     [VARS(Rolle1)]

    • ERPFIELDDB=ERP_PDM_NUMBER

      Enter the variable name of the database column here. You can set this in the PARTlinkManager under the menu Extras -> Configure ERP environment.

    • ERPFIELDLoc=

      If you enter a database field here the ERP number is copied into this field (for multiple locations only).

    • TIMESTAMPNR=0/1

      0: The ERP number entered by the user or the number returned by the ERP system is inserted in the link database.

      1: A so called timestamp number is generated and inserted into the link database. This setting only makes sense in special cases (e.g. at multiple location systems).

    • ERPADD=$ CADENAS_SETUP/erpadd.cfg

      Contains the path to the configuration file erpadd.cfg.

      The paths to the 3Dfindit project files (part families) are shown here in square brackets, including the identifiers for the ERP system with fixed values or the variable names from the 3Dfindit table. A variable name begins with the $ character and ends with the . (dot).

      Example:

      [norm/din_en_iso/schrauben/zylinderschrauben/din_912.prj]
      NAME=Screw
      FIELD1=$D.

      For more details please see in the config file itself.

    • CLASS=

      e.g. CLASSVARLIST(ECLASS)

      The specified entry is searched for in the corresponding 3Dfindit project file and exported to the ERP system.

    • E-mail settings

      [Note]Note

      By default, the settings in plinkcommon.cfgare used and not these. See Section 5.18.6, “E-mail settings / plinkcommon.cfg -> Block [MAIL]”.

      • S ENDTO=s tandardisation@company.com

        Address of the e-mail recipient when requesting a new ERP number via e-mail.

    • S ENDFROM =user@company.com

      Address of the e-mail sender when requesting a new ERP number via e-mail.

    • SUBJECT=Subject

      Subject line for the e-mail process.

    • SERVER=mail.company

      Name of the e-mail server for requesting a new ERP number via e-mail.

    • NEWASTATE=1

      State of the new created part.

      Possible values are 0 (locked), 1 (released) and 2 (expired).

    • IFACEEXE=$ CADENAS/iface/sap/sapcadenassrv.exe

      Path to ERP interface (obsolete)

  • Block [MAPPING]

    Mapping between ERP interface and 3Dfindit

    (only used at SAP integration)

  • Block [LOAD]

    A list of scripts that are loaded when erpcustom.vbb is started.

  • Block [BEFTBLLOAD]

    A list of scripts that are loaded before the start of erpcustom.vbb.

  • Block [AFTTBLLOAD]

    A list of scripts that are loaded after starting erpcustom.vbb.

  • Block [MAIL]

    A list of the scripts that are loaded by e-mail [Request ERP number per e-mail] when the Request ERP number [Request ERP number per e-mail] button is pressed button.

  • Block [ADDTODB]

    A list of scripts that are loaded when the Add record to link database [Add dataset to link database] button is pressed button will be loaded.

  • Block [SERVER_CUSTOM_SESSION_SETTINGS]

    In the entries can be used to determine which scripts are used during login (e.g. in ENTERPRISE 3Dfindit) invoked become. In the script SERVER_CUSTOM_SESSION_SETTINGS filters can be set on ERP variables that relate to the Catalog browsing, table viewing, and search. To Example:

    [SERVER_CUSTOM_SESSION_SETTINGS]
    1=$CADENAS_SETUP/scripts/custom/customsettings.vbb

    A possible callback script could look like this:

    function execute(settings)
       stdprint(settings.username)
       stdprint(settings.groupname)
       
       set filter = createObject("cnstools.array")
       filter.add("A")
       filter.add("B")
       settings.setFilterByValue("CTNR",filter)   
        
       set catalogs = createObject("cnstools.array")    
       catalogs.add("cat/festo")     
       settings.ErpFilteredCatalogs = catalogs
          
       execute = 1
    end function