4.7.3.1.9.  Release certain directories for export - plinkgroups.cfg -> Block [Role_name] -> Key "EXPPRJTAB" / plinktemplates.cfg

[Note]Note

The export table to be used [Use export table] is role-dependent and must therefore be defined separately for each role.

Why use "Export tables"?

By default, only those directories and projects that contain an ERP_PDM_NUMBER are displayed in green for ERP integration. (A standard entry under PARTadmin -> Role category -> General tab -> Export condition is for example "ERP_PDM_NUMBER.NE.'').

Using Export tables you can set on "green" any further directories or projects, meaning they are exportable independently from any other restrictions. For example, this could be directories, which only contain PDFs and for reasons of information shall be marked or directories, which indeed do not contain parts with ERP_PDM_NUMBER, but anyhow shall be exportable.

[Note]Note

Possibly settings are set under PARTadmin -> Category Roles -> Display tab page. In such a case, colors other than red/green may be displayed, but this does not change the behavior of export tables.

In order to use Export tables do the following:

  1. Precondition: Check, if the table "EXPORTTABLE" exists; if not, create it via SQL scripting.

    Example for MSSQL:

    /* EXPORTTABLE */
    IF NOT EXISTS(SELECT name 
                  FROM sysobjects 
                  WHERE name = 'EXPORTTABLE')
      BEGIN
        create table dbo.EXPORTTABLE(
          EXPPRJTAB varchar(40) not null,
          PATH varchar(500) not null,
          primary key(EXPPRJTAB, PATH)
        );
        grant all on dbo.EXPORTTABLE to PUBLIC;  
      END

  2. Select the Export tables tab page in PARTlinkManager under Tools [Extras] menu -> Configure ERP environment.

    PARTlinkManager -> Extras menu -> Configure ERP environment -> Export tables tab page

    PARTlinkManager -> Extras menu -> Configure ERP environment -> Export tables tab page

    In the Export tables area, click on the Add entry button and enter the desired table name (here EXPTAB as an example).

  3. Click on the corresponding button under Table entries and add projects or directories using Windows Explorer.

    These are displayed under Project path (here "training" as an example).

  4. Now switch to PARTadmin in the desired role and enter the previously added table name in the Export table to be used [Use export table] field.

Now in PARTdataManager, the "Training" catalog with all subdirectories is displayed in green in the part selection [Part selection], although it may not contain any parts with ERP_PDM_NUMBER.