Modifying the Excel Template - 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 template can be modified according to the following rules:

  • It is not allowed to modify the names of the sheets (ISH, MCS, IRC, RN, HEAT, INTERNAL).

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

    #FIELD_NAME#

    *FIELD_NAME* - Using this format (field name enclosed by * *) excludes the values in the field from the import. There is no difference in the created export file.

  • The start identifier of each data block (#ORDER#, #ISH#, #MCS#, #IRC#, #RN#, #HEAT#) cannot be omitted.

  • The end identifiers of each block (#END_ISH#, #END_MCS#, #END_IRC#, #END_RN#, #END_HEAT#) cannot be omitted.

  • Processing of each sheet of the template stops at the identifier #END_TEMPLATE#. It is strongly recommended not to remove this identifier, because this would result in a significant increase in processing time for the export.

  • The columns 250 – 255 are reserved for internal use.

  • Positions of the identifiers of the ORDER block can be changed horizontally or vertically.

  • All identifiers of the blocks ISH (Item Shipments), MCS, IRC, RN (Release Notes) and HEAT (Heat Numbers) must reside on one line.

  • The identifiers corresponding to the Pos, Sub, Is Pos, IS Sub, and Suppl fields are required for item shipments and heat numbers (ISH and HEAT sheets).

  • Data type formats of the identifier fields must correspond to the datatypes on P.70.72 (this is the case in the supplied template).

  • 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.72).

    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.