Job Execution - 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)

Import jobs can only be executed online from the S.80.11 OII – Import Jobs screen..

The first step of data import is to transfer the file content into an interface table (that is, a working table) using the Oracle tool SQL*Loader. The structure of this interface table reflects the file format specification. In the second step, data in this table will be processed sequentially; this process includes validation, foreign key data lookup, and insertion of valid data into the central Smart Reference Data tables.

The Open Ident Interface is implemented as a tool for importing master data, not as a tool for regular imports of transaction data. Because of this usage pattern, the components of this interface are not multi-user-enabled, which means that at the start time of import job execution, exclusive locks will be placed on several database objects to ensure that several import jobs that accidentally have been started at the same time do not interfere with each other. Instead, one of these jobs will be cancelled immediately with an error message.

All steps involved in an import job execution are integrated with the Smart Materials user interface. The import protocol, however, will be created externally as a protocol file that can be accessed by any tool that can handle flat ASCII files.

For the purpose of import data validation, a simulation mode, similar to that of the OMI interface, has been implemented. This simulation mode will do all the validations and plausibility checks that imported ident data must conform to, but it will not write any data to Smart Materials standardization tables. The protocol of the job execution can then be used to get an overview of the quality of the data.