Load Fab Tracking - 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)

The fab tracking import interface is a tool for importing fab tracking data quickly and easily.

Generally, importing fab tracking data requires several steps to be performed to prepare the data.

The required DBA setting is:

  • FAB_IMPORT_PATH

If you will be importing large quantities of data, you must define a specific rollback segment to be used by the import main program. The applicable setting is RBS_FAB. The necessary steps for importing fab tracking data are:

  1. Transfer the import file to a properly configured directory on the database server by clicking the Upload button.

  2. Create an appropriate import job definition on this screen.

  3. Perform the actual import procedure.

  4. Check the import protocol for an overview of the import routine.

SHARED Tip If errors have occurred, they are listed in an error file. This file has the same name as the log file with extension '.err'. You can edit this file manually with a text editor and use it again as a new import file.

On the P.90.01 Load Fab Tracking screen, you can maintain the job definitions and run the fab tracking imports.

In the first (Job Information) block, you define the import jobs.

Define a unique name for the import job in the Job Code field. Select the pre-defined load file format from the LOV in the Format field. Load file formats are defined on the A.10.37 Load File Formats screen. The Job Status field shows the status of the selected import job. The status of a new job that has not been started is ‘NEW’.

Enter a reference date in the Ref Date field. Future dates are not allowed.

If the reference date for the new load is the oldest date compared to the other jobs of the fabrication type, a message appears asking if you want to run the load job anyway.

If the date of the new load is already used, the older load will be replaced by the new load.

All the fabrication spools to be loaded using the input file will be validated against the Where condition specified for the fabrication type. If the fabrication spool complies with the Where condition, it will be imported as consistent with respect to the Where condition. If the spool does not comply with the Where condition, it will be imported as inconsistent with respect to the Where condition.

In the Import Path field, enter the file system path where the import file is stored. This path is relative to the database server (UTL file directory). When you click the Upload button, the value of DBA setting FAB_IMPORT_PATH is used for this field.

In the Import File field, enter the name of the import file.

Click the Upload button to open an upload window, which allows you to select any file from the file system and to upload it on the application server. After you have uploaded the file, it will be transferred automatically to the database server.

When you select the file from the file system, click the Submit button to send the file to the server.

The directory and file name of the uploaded file are automatically stored in the appropriate fields. The file name is concatenated by the string 'FIJID' and the ID of the actual load fab tracking job.

When the upload to the application server is finished, you can close the browser window. A message appears that the file is now transferred to the database server. You can enter a comment on this import job in the User Comment field.

The Job Execution Statistics section shows the job information after the job has been started. In the Job Start User field, the user who started this import job is displayed. The start and end date of the job are shown in the Start Date and End Date fields.

The Log File field shows the name of the internal log file created for this job.

A short summary of the job execution is displayed in the Execution Summary field.

Click the Start button in the Job Control section to start the import job.

After the job is finished, you can click the View Online Log button to view the log file. Furthermore, you can click the View Error Log button to view the error file.