Chapter 30. V9.08
30.31. NX-Teamcenter - LinkDB ReturnMapping implemented
Prev  Next

30.31. NX-Teamcenter - LinkDB ReturnMapping implemented

Via LinkDB ReturnMapping, PDM attributes can be mapped to link database fields.[184]

Example:

ifnxteamcenter.cfg

At first, in the block [AttributeMapping(is3d)], the block for the actual LinkDB mapping has to be declared (as usual).

[AttributeMapping(is3d)]
Attr_Content_00=LINKDB_RETURN_MAPPING
Attr_Section_00=LINKDB_RETURN_MAPPING

Then, via ERPTABLE.<ERP_COLUMN_NAME> or LINKTABLE.<ERP_COLUMN_NAME>, the needed columns can be specified.

Example:

[LINKDB_RETURN_MAPPING(is3d)]
ERPTABLE.<ERP_COLUMN_NAME>=?"'%TC_ItemId%'"

ERPTABLE.<ERP_COLUMN_NAME> specifies table and column, the value the placeholder to be used. Thereby the ItemId for example (which is possibly created during the generation in Teamcenter) can be saved in the LinkDB.

Supported placeholders for ERPTABLE.<ERP_COLUMN_NAME> are:

  • %TC_ItemId%

  • %TC_ItemRevision%

  • %TC_ItemName%

  • %TC_ItemDescription%

  • %TC_TargetFolder%

  • %TC_ItemType%

The following preconditions have to be given for ReturnMapping:

  • In the attribute mapping section [LINKDB_RETURN_MAPPING] a key with the respective structure has to be available (see above).

  • <ERP_COLUMN_NAME> has to be an existing VARCHAR column in the ERPTABLE!

After a new creation of parts the project has to be reloaded in PARTdataManager in order for the PDM values to be displayed.



[184] #41255

Prev Up Next
30.30. Teamcenter-Pro/E - "Description" bug fixed Home 30.32. SAP PLM for NX - Escaping for specified characters supported