powered by CADENAS

Manual

Manual

5.11.1.7. Export condition - plinkgroups.cfg -> Block [Role_name] -> Key "EXPORTRESTRICTION"

[Hinweis] Hinweis

Export condition is role dependent, so has to be defined for each role separately.

Export restrictions contribute substantially to the controlled use of parts.

This can be achieved via setting under PARTadmin -> category Roles -> tabbed page General -> Export condition or alternatively via configuration file plinkgroups.cfg -> Block [Role name] -> Key EXPORTRESTRICTION.

An existing export restriction is signalized by a status light in the table, at the beginning of each line.

Standard is a green/red depiction:

  • Green: Export allowed

  • Red: Export forbidden

Standard status lights

Standard status lights

However, any kind of status light can be used when using the setting under PARTadmin -> category Roles -> tabbed page Display -> dialog area Status indicating bitmaps for table view. See Abschnitt 5.11.3.1, „Statusicons für Tabelle - plinkgroups.cfg -> Block [<Rollenname>] - Key "BMPCONDITION<Nummer>"“.

Enhanced status lights

Enhanced status lights

Enhanced status lights

Enhanced status lights

Configuration

User interface: PARTadmin -> category Roles -> General tab -> Export condition

For this setting you can use Fortran syntax or SQL syntax as well.

Examples:

  • Example 1

    EXPORTRESTRICTION = ERP_PDM_NUMBER.NE.''

    or

    EXPORTRESTRICTION = ERP_PDM_NUMBER<>''

    Meaning: ERP_PDM_NUMBER may not be equal to "blank".

    Only rows which meet the condition get the green status light.

    A data record without ERP number is displayed in red and thus is not exportable.

  • Example 2

    EXPORTRESTRICTION = ((ERP_PDM_NUMBER.NE.'').AND.(ACTIVE_STATE.EQ.1))

    Meaning: There has to be an ERP_PDM_NUMBER AND the entry in the "Active state" column must be "Released". Both conditions have to be fulfilled.

    Line 6 and 10 do not meet the condition.

    Line 6 and 10 do not meet the condition.

  • Example 3

    EXPORTRESTRICTION = ((ACTIVE_STATE.EQ.1).AND.(BLNNR.NE.'')) 

    Meaning: Only data sets can be exported, which current status is "Released" and which have an entry in the "BLNR" column.

  • Example 4

    This example shows the setting options via config file or via PARTadmin in detail and shows enhanced status lights.

    Setting in configuration file $CADENAS_SETUP/plinkgroups.cfg:

    Block [<role name>], key EXPORTRESTRICTION, value contains condition

    EXPORTRESTRICTION = ((ERP_PDM_NUMBER.NE.'').AND.(LOC3.EQ.'x'))

    Meaning: ERP_PDM_NUMBER may not be equal to "blank" AND the column LOC3 has to have the term 'x' as entry.

    Setting in user interface under PARTadmin -> category Roles -> tabbed page Display -> dialog area Export condition:

    Result in PARTdataManager

    For example, export on line 7 is not possible for the role "Location 3", because column LOC3 does not contain a "x", which is required by the Export condition.

    Line 7 cannot be exported. A notification message is displayed.

    Line 7 cannot be exported. A notification message is displayed.

    For this example additional settings under PARTadmin -> Roles category -> Display tabbed page -> Status indicating bitmaps for table view are used. Thereby the red-green display is overridden, but the export condition itself is not affected. For details on this please see under Abschnitt 5.11.3.1, „Statusicons für Tabelle - plinkgroups.cfg -> Block [<Rollenname>] - Key "BMPCONDITION<Nummer>"“.