Packages without Release Notes - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

The import operation offers the option for either single or multi package import. Details are described in the following sections.

Import of a File Created by Export

This import mode allows the update of an existing package. Only the information that is also updateable in Smart Materials can be changed. It is important that the INTERNAL sheet of the file generated by the export is not modified; otherwise, there is the danger of errors preventing a successful import or even data corruption.

Import of an Externally-Created File

This file must be based on a template of type 'Package', for example, standard template PACKAGE. In this template, the field information on the INTERNAL sheet must match the fields on the data sheet. Furthermore, the entry #NEW# must be available on the INTERNAL sheet in column 1 row 2. This import mode allows you to load multiple packages with one file.

Assignment of Package Positions

The import identifies the correct item shipments to create new positions or update existing positions by using the information provided in the following fields:

  • Pos

  • Sub

  • IS Pos

  • IS Sub

  • Ident Code

  • Tag Number

  • Commodity Code

  • Order Number

  • Size1..5

If one or more of these fields are omitted, the information in the remaining fields must identify a unique item shipment. Otherwise, no package item is created or updated; instead, an error message is written to the log file.

Issued/Received Packages

If a package for which the Excel import is started is already issued or received, there are no changes to this package. Instead, the import creates a second package (always of site type ‘ISSUE’) that contains the modified information. The package name is that of the original package followed by a three-digit number. The software automatically selects the highest number that is not yet used for a package name. If quantity reductions compared to the data stored in Smart Materials are imported, a second package is created containing the quantity differences.