Modifying the Excel Templates for Export - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

The supplied templates can be modified according to the following rules:

  • It is not allowed to modify the names of the INTERNAL sheet.

  • The display of data is controlled by identifiers in the following format :

    #FIELD_NAME#

    *FIELD_NAME* - Using this format excludes the field from the import. There is no difference in the created export file.

  • The start identifier of each data block (#PK#, #PKI# for packages without release notes, #RN#, #PCKI# for packages with release notes) cannot be omitted.

  • The end identifiers of the package items data block (#END_ISH#) cannot be omitted.

  • Processing of each sheet of the template stops at the identifier #END_TEMPLATE#. Removing this identifier results in a large increase in processing time for the export.

  • Columns 250 – 255 are reserved for the definition of code lists. You can enter additional value lists for fields of the template.

  • Positions of the identifiers of the #PK#/#RN# blocks can be changed horizontally or vertically.

  • All identifiers of the blocks for package items must reside on one line.

  • The identifiers corresponding to the Pos, Sub, IS Pos, IS Sub, and Suppl fields are required for package items to identify the correct item shipment during import.

  • Data type formats of the identifier fields must correspond to the data types on P.70.74 (this is the case in the supplied templates).

  • Color coding in the supplied template in general has the following meaning (although this is not a complete representation of the application logic of P.70.74).

    Color

    Meaning

    Gray

    Fields that cannot be modified by the import and thus should not be changed.

    Green

    Mandatory; input is required for these fields by the import.

    White

    Optional; input is not required for these fields.

    Blue

    Fields in the order block cannot be modified. For the identifier #SPLIT#, see the information about splitting tags.