Start Flat Loading Config Import - 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)

Open the B.40.01 BOM Import screen.

Create a new import job. First, enter a name in the Job Code field, and select Flat Loading Config from the dropdown list in the Data Source field.

Next, click the Upload button. A file selection dialog opens. Selecting a file will send the file to the application server.

Then enter values in the Issue Status and List Status fields. Lists of values are available for both fields.

Finally, you must assign the FLC configuration that you have defined on B.10.41 Flat Configurations as described above. You can store mappings for all the different files you want to import, so be sure to select the matching configuration for the import file from the list of values.

If you do not define a Delimiter value for the columns of the csv file, the default and recommended value, a semicolon, is used.

After that, you can set the Load Option value for the import: ASCII, CIP, Custom Screen, or Excel File. The default value ASCII means that the import reads the csv file and executes the import completely internally. Choosing the Custom Screen load option calls a custom screen before starting the actual import. The purpose of this custom screen is to copy data into the FLC tables. The custom screen must be defined by the application server-specific DBA setting FLC_CUSTOM_SCREEN on A.60.04.

If you do not want the import performed in this way, you can write your own import procedure using the package m_pck_omi_custom. There is a procedure called omi_flc_load that you can use to implement your own source code for the import of the BOM data. If you choose the load option CIP, the procedure omi_flc_load is executed instead of the internal import.

To check the flat data after it is imported but before it is moved to the staging area, select the Pit Stop check box.

To start the BOM import job, click the Start button. The job first validates the mapping configuration just like the validation on B.10.41 Flat Configurations when you click the Validate button. If there is any problem found concerning the mapping, an error message occurs, and you are prompted to correct the configuration on the B.10.41 Flat Configurations screen.

When the import is done, you can check the result by viewing the log file and, in case of problems, the error report.

If you already have run the import and you want to make some changes in the file, you can make the changes and then start the import again. Select the import job again, and click the New run button. A new job code is generated and you can launch the import again. Smart Materials detects the changes and imports only the changed data.

Only the columns for which you marked the Consider Delta check box on B.10.41 Flat Configurations are imported.

When the job is defined with the Pit Stop indicator selected, the job stops after importing the flat data into table M_FLAT_PRE_IMPORTS. The procedures of type PRE that are assigned to the FLC configuration are executed before the job stops. The job status is set to STAGE and displayed in the Job Status field, the Review Data button and the Cancel Job button are enabled, and the Start button changes to Continue Job.

  • A staged import job blocks all other jobs with the same FLC config from being started.

  • A staged import job prevents changes to the FLC configuration.

Click the Review Data button. A window opens where the data of table M_FLAT_PRE_IMPORTS appears.

You can review, modify, and delete the displayed data. Click the Auto-Create Config button at the bottom to create a screen configuration according to the used FLC configuration. The fields assigned to the FLC configuration are displayed.

You can use the Order By … button to change the sort order of the displayed records. The selected sort order is shown in the Ordered by field at the top of the screen.

LOVs are provided where applicable, for example, in the Commodity Group, Commodity Part, and Commodity Code fields.

Procedures of type ‘Post‘ that were assigned to the FLC configuration can be applied to the data. You can select single procedures from the shortcut menu as displayed in the picture below.

Or, you can run all assigned procedures using the Run Procedures button at the bottom.

Clear the Import check box of all positions that are not to be imported.

Finally, click the Cancel button to close this window and return to the main B.40.01 screen. Click the Continue Job button to continue the FLC import. To cancel the import, click the Cancel Job button.