Import Interface Service
To import data for a selected planning engine interface:
- Select a planning engine from the main menu.
- Click the Details tab.
- Select Import Interface Service from the Data Transfer list. The Import Interface Service screen is displayed.
Note: The Import Interface Service option is displayed in the Data Transfer list if you have the required permission.
- Specify this information:
- Planning Engine
-
The name or display name of the planning engine.
Note: The value is displayed based on the selected planning engine and cannot be modified.
- Interface Service
-
The interface services with the data entity set to Planning Engine and the direction set to Import.
Note: The interface service selected can be an Interface service created against any Planning Engine Definition.
- Keep resources before importing
-
Indicates whether to clear data before the import process. Possible values:
- On: Data is not cleared the import process. These cases are considered:
- If the resource exists, update the changes (user and system attributes and default property values) within the Primary Class defined on the Interface Service.
- Updating values of calculated property is not supported.
- Updating or adding relations between resource relation (such as moving a process from the 'mixing' group to the 'crushing' group) are not supported. Consequently, the import completes successfully, however, the modified resource relations remain unchanged.
- If the resource does not exist, the resource is created (including the resource relation) based on the current behaviour.
- Empty Import fields are cleared.
- Only fields that are available in the mapping of the interface service are updated.
- If the resource exists, update the changes (user and system attributes and default property values) within the Primary Class defined on the Interface Service.
- Off: Data is cleared before the import process. If the import class is a component of an Allocation, resources related to any related Allocation classes and quantities for the Allocation classes are deleted. This applies recursively, such that if the import class is a component of an Allocation, and that Allocation class itself is also a component of another Allocation class, resources and quantities for all are deleted.
Note:- This switch is displayed only if:
- The Interface Type field is set to CSV, Database, or Excel.
- The Data Entity field is set to Planning Engine.
- The Interface Direction field is set to Import.
- The Type field is set to Resource Master Data.
- By default, the switch is set to Off.
- You cannot update the resource name.
- If the source contains a resource name multiple times, only the first instance is imported, and the rest are ignored.
- On: Data is not cleared the import process. These cases are considered:
- Data Source Type
-
The type of data source.
Note: The value is displayed based on the selected interface and cannot be modified.
- Reject all rows if an error is found
-
Indicates whether the import process must stop if an error is found. Possible values:
- On: The import process stops upon an error, and no values are imported.
- Off: All rows are processed, and discarded rows with an error are logged in a discard file.
- File
-
Indicates the data file to import.
Note: This field is displayed only when the interface service is set to CSV or Excel and the data source type is set to File.
- Click Run.
The data for the selected interface service is imported and the details of the Import are recorded in the Audit log. The fields mapped within the interface service are validated to ensure the fields are available within the planning engine.
Note:- If the selected interface service is importing Calendar or Variable data and the Reject all rows if an error is found option is not applicable, the value is processed as if True and this Warning message is displayed in the job manager:
Reject All Rows if an error is found = false is not supported for data type {0}
- The selected interface service does not have to use the same planning engine definition as the planning engine, which is being imported.
- The values imported for the same key are overwritten if the import behavior is set to Overwrite. The key includes resource(s), property, and period. If multiple entries for the same key exist, the last entry is used.
- The values imported for the same key are added if the import behavior is set to Sum.
- If the selected interface service is importing Calendar or Variable data and the Reject all rows if an error is found option is not applicable, the value is processed as if True and this Warning message is displayed in the job manager: