Excel sheet modifications - Intergraph Smart Materials - 10.4 - Help - Hexagon

Intergraph Smart Materials Help (10.4)

Intergraph Smart Materials
Search by Category
Smart Materials/Smart Reference Data Version

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* - 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 in the Expediting screen (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 Expediting).




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


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


    Optional; input is not required for these fields.


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