Configure CSV Load - Intergraph Smart Materials - Version 10.1 - Administration & Configuration - Hexagon

Intergraph Smart Materials Integration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Construction Version
8
Smart Materials/Smart Reference Data Version
10.1

The configuration for the CSV load is done in Smart Materials on screen B.10.41 Flat Configurations.

When you click the TEMPLATE button, the software provides a list of templates, which have configuration settings ready to be used with the appropriate MTO reports described above. The following templates are available:

TOOL_NAME

REPORT_NAME

FLC_CODE

FLC_COMMENT

Smart 3D

Piping

3D PIPING

SP3D Piping Report

Smart3D

Cable Tray

3D CABLETRAY

SP3D Cable Tray Report

Smart 3D

Steel Structure

3D STEELSTR

SP3D Steelstructure Report

Smart 3D

Profiles

3D PROFILES

SM3D Profile Report

Smart 3D

Plates

3D PLATES

SM3D Plates Report

The configurations for the handrail report and for the nesting report are currently not available. This does not mean that these reports cannot be imported. It only means that the configuration must be done manually. The templates for these reports are planned to be available with Phase 2.

Below is an example for the SM3D plate:

In this template, each column expected to be loaded from the CSV is configured here by the following fields:

  • Sequence - The sequence of columns in the CSV file

  • Item - Defines the type of data being loaded from the current column.

    The different items are described in the online help.

    The item "POS_TAB" is a new one. It allows you to assign a COMMATTR_TABLE, which is used to find a commodity code based on the value found in the CSV file. It is possible to combine up to 10 "POS_TAB" fields in order to find a commodity code. In the example for plates, the tables "MATERIAL" and "GRADE" are sufficient to find the commodity code. These values naturally can be predefined, because they are dependent on the SPRD configuration, which can be different for each client.

    The ident is then found via "POS_SIZE1", which specifies that this column in the CSV is compared against the INPUT 1 column related to the currently found commodity code.

  • Value - Has an item-dependent meaning. A context-sensitive LOV is available.

  • Value Required - This item needs a value defined if checked. If it is not defined, the template will not be copied into the FLC configuration.

  • Auto Create - If this checkbox is checked by the software, it indicates that the item will be created automatically by Smart Materials in all relevant tables and screens. For example, an attribute, which at this point in time is not defined for BOM usage, but configured here in the template as such, will be created automatically. This auto-creation saves a lot of configuration time.

  • Report Column - An information field, which lists the name of the column used in the MTO xls report before the header was deleted.

Once the remaining configuration work inside the template is done, the data is copied into the FLC screen when you click the Start button.

The configuration code 3D PLATES-1 is stored automatically and can be adjusted here. Please, do not adjust the template data.