Data Tab

The Data tab defines the type of data which will be imported, and how that data will update the MES database. It also indicates which data fields will be come from the import source and defines default values for the others.

Import Data Type list

The type of the data that will be imported. The choices are pre-defined, based on the structure of the MES database.

If you select the Import from COM object option, the If Row Exists list and the Data Table are replaced by COM Object, Method to Call on the COM Object, and Method Context Parameter fields.

If Rows Exist list

Indicates what action should be taken if the rows, being imported, already exist in the database.

• Ignore: Ignore the imported data; consider it to be a duplicate.

• Update: Update the database row to match the incoming data.

• Treat as error: Enter an error message into the log, skip that row, and continue the data import.

• Delete: Delete the row in the database.

• Delete all: Delete all rows that match with the incoming data related to the composite primary keys from the database table.

• Ignore and treat as success: Ignore the imported data and display the status as success in the Log tab.

Data Table

If the Import Data Type is not Import from COM Object or XML Defined, displays the data fields available for the selected data type, identifies those fields that will be included in the import data, and allows default values to be defined for the other values. Left-clicking a column heading allows you to sort the display by that field. Click that heading again to reverse the sort order. Ctrl+click on other headings to add secondary and tertiary sort fields.

• Field Description: Identifies the database field into which the data will be imported. Required field names are shown in bold type.

• Included: When selected, indicates that data field will be found in the imported data.

• Default: The default value to be used if the field is not included in the imported data.

COM Object

The name of the COM object.

Method to Call on COM Object

The name of the method that is to be called on the COM object.

Method Context Parameter

The value of the method context parameter. It is a single variable parameter. However, you can specify a list of values for this parameter.

For more information about COM object method calls, see Supply Chain Connector Imports and Exports via a COM Object.

To modify the data definitions, select the desired field and change its value. Click Save to keep your changes or Cancel to discard them.

Behavior of the Delete and Delete All Actions for Certain Import Data Types

The Delete and Delete all actions in the If Rows Exist list will be available for all import types even when the action is not applicable. The following limitations for the listed import data types are by design.

Attribute Set

Neither Delete nor Delete all are supported.

Entities

Delete all is not supported.

Languages

Delete all is not supported.

Lot Attributes

For a comma-delimited file, Delete all requires that at least the first two fields are supplied.

Operation Attributes

For a comma-delimited file, Delete all requires that at least the first two fields are supplied.

SO

Delete all is not supported.

SO Line

Delete all is not supported.

Utilization Reasons

Delete all will delete all utilization reasons for all groups, even when a utilization reason group ID is specified, whether the utilization reason group ID is legitimate or not.

Import Data Types Having Only a Single Primary Key Field

For the import data types that have only a single primary key field—Customer, Item Class, Item Reasons, Items, Language Groups, Processes, Sites, Specs, Standard Operations, Utilization States, Utilization Reason Group, and Work Orders (either sort)—MES Supervisor does not allow the primary key field to be unchecked. Therefore, both the Delete and Delete all actions will delete all rows in the MES database that match the primary key field of the incoming data. The fact that the selection of the primary field for these import data types is required is intentional, as this prevents the deletion of all records of a particular data type.

Behavior of Importing Work Orders from a Process

If Import Data Type is Work Orders (With Process) and If Rows Exist is Update, then one of the following will occur during the import of a work order from a process:

• If the work order does not exist, the work order is created.

• If the work order exists but it has jobs that are running or completed, no update is performed.

• If the work order exists and has no jobs that are running or completed, only the following work order properties are updated: the required quantity, the release and required finish times, the description, the priority, customer information, the manufacturing order, and notes.

  For its jobs, the following updates are made:

  • The job quantities are adjusted according to the quantities set for the work order.

  • The required finish times for the last jobs are set to those of the work order.

  • The required finish times of the rest of the jobs (other than the last jobs) are adjusted by the amount that the required finish times of the last jobs were changed.