Data Loader
About the ASI Data Loader
The Asset Strategy Implementation (ASI) Data Loader allows you to import an ASI Package into APM. Along with the ASI Package, all the Work Management Items (WMIs) (including custom ones as well) are imported.
After the data load, you can access the imported data, along with details such as the date and time when the data was loaded and the user who loaded the data. You can then access the imported ASI Package in the ASI module.
About the ASI Data Loader Requirements
For baseline WMIs, the configuration is available in the Work Management Item Definitions section in the Asset Strategy Implementation Admin page. However, if you want to add a WMI, you must configure the Lookup and Exclude fields for the Data Loader and export features.
About the ASI Data Loader Data Model
The following data model illustrates the records that the ASI Data Loader supports.
About the ASI Data Loader Load Verification
A successful data import will have the same effect as creating a new Asset Strategy Implementation in APM. After a successful data load, if the data loader creates a new strategy or template, it will appear in the Asset Strategies Implementation section or the Templates section in the Strategy Implementation Overview page.
A successful import can also be defined as an event in which partial data on a worksheet is loaded into APM, and a message appears, helping you identify and correct issues resulting from the import.
About the ASI Data Loader Workbook Layout and Use
To import data using the ASI Data Loader, APM provides an Excel workbook, Asset Strategy Implementation (ASI).xlsx, which supports baseline ASI. This workbook must be used to load data. You can modify the Excel workbook to include custom fields used by your organization. The following tables list the worksheets that are included in the workbooks and then the fields in the corresponding worksheets.
Note:
- You cannot update any fields that are disabled in APM.
- If you attempt to create a Maintenance Plan, Maintenance Item, or a Notification at the root of a package where the same record already exists in another package within APM, a warning message appears, and the duplicate records are not created.
The ASI Data Loader Worksheets
| Worksheet | Description |
|---|---|
| MI_IMPPACKG (Implementation Package) | This worksheet is used to provide new or existing Implementation package details such as ID, Description, State, and SAP System. |
| MI_MAINTPLN (Maintenance Package) | This worksheet is used to provide maintenance plan details such as the Package ID, Multiple counters, and interval. |
| MI_CYCLE (Cycle) | This worksheet is used to provide Cycle details such as the Cycle Description, Cycle UOM, and Offset. |
| MI_MAINTITM (Maintenance Item) | This worksheet is used to provide Maintenance Plan and details such as the Description of the Package, Equipment, and Functional Location. |
| MI_OBLSTITM (Object List Item) | This worksheet is used to provide the Maintenance Plan, ID, Equipment Number, Functional location ID, and Description. |
| MI_TASKLIST (Task List) | This worksheet is used to provide the Task List details such as the ID, Group, and Functional Location. |
| MI_OPERTION (Operation) | This worksheet is used to provide Operation details such as the Operation Description, Work Centre, and Plant. |
| MI_MATERIAL (Material) | This worksheet is used to provide Material details such as the Material Number, Quantity, and Unit Measure. |
| MI_PRT (Production Resource Tool) | This worksheet is used to provide the PRT details such as the PRT Document and PRT Quantity. |
| MI_MAINTPKG (Maintenance Package) | This worksheet is used to provide the Maintenance Package details such as the Maintenance Package Number, Cycle, and Maintenance Plan. |
| MI_NOTIFCTN (Notification) | This worksheet is used to provide Notification details such as the Functional Location, Description, and Imported Date. |
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| ID | MI_IMPPACKG_ID_C | Character (255) | The ID of the Implementation Package. |
| Description | MI_IMPPACKG_DESC_T | Text | The description of the Implementation Package. |
| MI_SM_STATE_ID_C | MI_SM_STATE_ID_C | Character | The state ID of the Implementation Package. |
| SAP System | MI_IMPPACKG_SAP_SYS_C | Character | The SAP System of the Implementation Package. |
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | The ID for the Implementation Package. |
| ID | MI_MAINTPLN_ID_C | Character | The ID for the Maintenance Package. |
| Multiple Counter | MI_MAINTPLN_MULTI_CNTR_F | Boolean | You can enter a value only if you are creating the Maintenance Plan. If you are updating a Maintenance Plan, this field is disabled. |
| Interval | MI_MAINTPLN_INTERVAL_N | Numeric | This field is the Interval. |
| Interval Description | MI_MAINTPLN_INTERVAL_DESC_C | Character | The description of the interval. |
| Shift Factor for Late Completion | MI_MAINTPLN_SHIFT_LATE_N | Numeric | The late completion shift factor. |
| Tolerance for Late Completion | MI_MAINTPLN_TOL_LATE_N | Numeric | The tolerance for the late completion. |
| Shift Factor for Early Completion | MI_MAINTPLN_SHIFT_EARLY_N | Numeric | The early completion shift factor. |
| Tolerance for Early Completion | MI_MAINTPLN_TOL_EARLY_N | Numeric | The tolerance for the early completion. |
| Cycle Modification Factor | MI_MAINTPLN_CYCLE_FACTOR_N | Numeric | |
| Call Horizon | MI_MAINTPLN_CALL_HORIZON_N | Numeric | |
| Scheduling Period | MI_MAINTPLN_SCHED_N | Numeric | This field is used for scheduling period. |
| Scheduling Unit | MI_MAINTPLN_SCHED_UNIT_C | Character | This field is used for scheduling unit. |
| Start Date | MI_MAINTPLN_START_DATE_D | Date | This field is used for start date |
| Start Counter | MI_MAINTPLN_START_COUNTER_N | Numeric | This field is counter for the maintenance plan |
| Sort Field | MI_MAINTPLN_SORT_FIELD_C | Character | This field is sorting field for the maintenance plan |
| Offset | MI_MAINTPLN_OFFSET_N | Numeric | |
| Scheduling Dimension | MI_MAINTPLN_SCHED_DIM_C | Character | This field is scheduling dimension for the maintenance plan |
| Interval Dimension | MI_MAINTPLN_INTERVAL_DM_C | Character | This field is internal dimension for the maintenance plan |
| Interval Unit | MI_MAINTPLN_INTERVAL_UN_C | Character | This field is internal unit for the maintenance plan |
| Category | MI_MAINTPLN_CATEGORY_C | Character | This field is Category for the maintenance plan |
| Authorization Group | MI_MAINTPLN_AUTH_GROUP_C | Character | This field is authorization group for the maintenance plan |
| Date Imported | MI_MAINTPLN_DATE_IMPORTED_DT | Date | |
| Description | MI_MAINTPLN_DESC_C | Character | This field is description for the maintenance plan |
| Factory Calendar | MI_MAINTPLN_CALENDAR_C | Character | |
| Call Confirm | MI_MAINTPLN_CALL_CONFIRM_C | Character | |
| Scheduling Indicator | MI_MAINTPLN_INDICATOR_C | Character | This field is used for scheduling indicator |
| Long Text | MI_MAINTPLN_LONG_DESC_TX | Text | Long text |
| Maintenance Strategy | MI_MAINTPLN_STRATEGY_C | Character | This field is maintenance strategy for the maintenance plan |
| Counter | MI_MAINTPLN_COUNTER_C | Character | This field is counter for the maintenance plan |
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | This field is the ID for the Package |
| Maintenance Plan|ID | MI_MAINTPLN_ID_C | Character | This field is the ID for the Maintenance Plan |
| Cycle | MI_CYCLE_CYCL_N | Numeric | |
| Cycle Description | MI_CYCLE_CYCL_DESC_C | Character | |
| Cycle Set Sequence | MI_CYCLE_CYCL_SET_SEQ_N | Numeric | |
| Cycle UOM | MI_CYCLE_CYCL_UOM_C | Character | |
| Offset | MI_CYCLE_OFFSET_N | Numeric | |
| Counter ID | MI_CYCLE_ID_C | Character | |
| Start Counter | MI_CYCLE_START_CNT_N | Numeric | |
| ID Number | MI_CYCLE_ID_NUM_N | Numeric |
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | This field is the ID for the Package |
| Maintenance Plan|ID | MI_MAINTPLN_ID_C | Character | This field is the ID for the Maintenance plan |
| Maintenance Item | MI_MAINTITM_ID_C | Character | This field is maintenance item |
| Item Description | MI_MAINTITM_DESC_C | Character | This field is the description for item |
| Equipment | MI_MAINTITM_EQUIPMENT_C | Character | This field is the equipment |
| Functional Location Label | MI_MAINTITM_LOCATION_LABEL_C | Character | This field is functional location for maintenance plan |
| Functional Location | MI_MAINTITM_LOCATION_C | Character | This field is functional location |
| Planning Plant | MI_MAINTITM_PLAN_PLANT_C | Character | This field is plant |
| Maintenance Planner Group | MI_MAINTITM_PLAN_GROUP_C | Character | This field is maintenance planned group for maintenance |
| Business Area | MI_MAINTITM_BUSINESS_AREA_C | Character | This field is business area for maintenance |
| Activity Type | MI_MAINTITM_ACTIVITY_TYPE_C | Character | This field is activity type for maintenance |
| Order Type | MI_MAINTITM_ORDER_TYPE_C | Character | This field is order type for maintenance |
| Notification Type | MI_MAINTITM_NOTIF_TYPE_C | Character | This field is notification type for maintenance |
| Priority | MI_MAINTITM_PRIORITY_C | Character | This field is priority for maintenance |
| Work Center | MI_MAINTITM_WRK_CTR_C | Character | This field is Work Center for maintenance |
| Work Center Plant | MI_MAINTITM_WRK_CTR_PLANT_C | Character | This field is Work Center Plant for maintenance |
| Category | MI_MAINTITM_CATEGORY_C | Character | This field is Category for maintenance |
| Date Imported | MI_MAINTITM_DATE_IMPORTED_DT | Date | |
| Assembly | MI_MAINTITM_ASSEMBLY_C | Character | |
| Maintenance Strategy | MI_MAINTITM_STRATEGY_C | Character | This field is maintenance strategy for maintenance item |
| System Condition | MI_MAINTITM_CONDITION_C | Character | This field is system condition for maintenance item |
| Equipment Description | MI_MAINTITM_EQUIP_DESC_C | Character | This field is equipment description for maintenance item |
| Long Text | MI_MAINTITM_LONG_DESC_TX | Character | Long text |
| Cycle Set Sequence | MI_MAINTITM_CYCL_SET_SEQ_N | Numeric |
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | This field is package ID for object list |
| Maintenance Plan|ID | MI_MAINTPLN_ID_C | Character | This field is maintenance plan or ID for object list |
| Maintenance Item|Maintenance Item | MI_MAINTITM_ID_C | Character | This field is maintenance item for object list |
| Equipment Number | MI_OBLSTITM_EQUIP_NUM_C | Character | This field is equipment number for object list |
| Functional Location ID | MI_OBLSTITM_FUNCT_LOC_ID_C | Character | This field is functional location for object list |
| Equipment Description | MI_OBLSTITM_EQUIP_DESC_C | Character | |
| Functional Location Label | MI_OBLSTITM_FUNCT_LOC_LBL_C | Character | |
| Sort Field | MI_OBLSTITM_SORT_FIELD_C | Character | |
| Item Key | MI_OBLSTITM_ITEM_KEY_N | Character | This field is item key for object list |
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | This field is package ID for task list |
| Maintenance Plan|ID | MI_MAINTPLN_ID_C | Character | This field is maintenance plan ID for task list |
| Maintenance Item|Maintenance Item | MI_MAINTITM_ID_C | Character | This field is maintenance item for task list |
| Group Counter | MI_TASKLIST_GROUP_CNTR_C | Character | This field is Group Counter for task list |
| Group | MI_TASKLIST_GROUP_C | Character | This field is Group for task list |
| Equipment Description | MI_TASKLIST_EQUIP_DESC_C | Character | This field is equipment description for task list |
| Functional Location Label | MI_TASKLIST_LOCATION_LABEL_C | Character | This field is functional location label for task list |
| Functional Location | MI_TASKLIST_LOCATION_C | Character | This field is functional location for task list |
| Planning Plant | MI_TASKLIST_PLAN_PLANT_C | Character | This field is planning plant for task list |
| Planner Group | MI_TASKLIST_PLAN_GROUP_C | Character | This field is planning group for task list |
| Maintenance Strategy | MI_TASKLIST_STRATEGY_C | Character | This field is maintenance strategy for task list |
| Work Center | MI_TASKLIST_WRK_CTR_C | Character | |
| Plant | MI_TASKLIST_PLANT_C | Character | |
| Usage | MI_TASKLIST_USAGE_C | Character | |
| Status | MI_TASKLIST_STATUS_C | Character | |
| System Condition | MI_TASKLIST_CONDITION_C | Character | |
| Date Imported | MI_TASKLIST_DATE_IMPORTED_DT | Date | |
| Description | MI_TASKLIST_DESC_C | Character | |
| Assembly | MI_TASKLIST_ASSEMBLY_C | Character | |
| Key Date | MI_TASKLIST_KEY_DATE_DT | Date | |
| Long Text | MI_TASKLIST_LONG_DESC_TX | Text | |
| Reference Task List? | MI_TASKLIST_REFERENCE_L | Boolean | |
| Equipment | MI_TASKLIST_EQUIPMENT_C | Character |
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | This field is package ID for Operation |
| Maintenance Plan|ID | MI_MAINTPLN_ID_C | Character | This field is maintenance plan or ID for Operation |
| Maintenance Item|Maintenance Item | MI_MAINTITM_ID_C | Character | This field is maintenance item for Operation |
| Task List|Group | MI_TASKLIST_GROUP_C | Character | This field is task list/group for Operation |
| Task List|Group Counter | MI_TASKLIST_GROUP_CNTR_C | Character | This field is task list/group counter for Operation |
| Operation | MI_OPERTION_ID_C | Character | This field is Operation |
| Sub Operation | MI_OPERTION_SUB_ID_C | Character | |
| Description | MI_OPERTION_DESC_C | Character | |
| Work Center | MI_OPERTION_WRK_CTR_C | Character | |
| Plant | MI_OPERTION_PLANT_C | Character | |
| Work | MI_OPERTION_WORK_C | Character | |
| Work Unit | MI_OPERTION_WORK_UNIT_C | Character | |
| Number of Resources | MI_OPERTION_RESOURCE_COUNT_C | Character | |
| Normal Duration | MI_OPERTION_DURATION_C | Character | |
| Normal Duration Unit | MI_OPERTION_DURATION_UNIT_C | Character | |
| StdTxt | MI_OPERTION_STANDARD_TXT_C | Character | |
| Activity Type | MI_OPERTION_ACTIVITY_TYPE_C | Character | |
| Control Key | MI_OPERTION_CONTROL_KEY_C | Character | |
| Date Imported | MI_OPERTION_DATE_IMPORTED_DT | Date | |
| Cost Element | MI_OPERTION_COST_ELEMENT_C | Character | |
| Calc | MI_OPERTION_CALC_C | Character | |
| Currency | MI_OPERTION_CURRENCY_C | Character | |
| Purchasing Organization | MI_OPERTION_PURCH_ORG_C | Character | |
| Purchasing Group | MI_OPERTION_PURCH_GROUP_C | Character | |
| Material Group | MI_OPERTION_MATERIAL_GROUP_C | Character | |
| User Field Keyword ID | MI_OPERTION_USR_FLD_KEYWD_ID_C | Character | |
| User Field 0 | MI_OPERTION_USER_FIELD_0_C | Character | |
| User Field 1 | MI_OPERTION_USER_FIELD_1_C | Character | |
| User Field 2 | MI_OPERTION_USER_FIELD_2_C | Character | |
| User Field 3 | MI_OPERTION_USER_FIELD_3_C | Character | |
| User Field 4 | MI_OPERTION_USER_FIELD_4_N | Numeric | |
| User Field 4 Units | MI_OPERTION_USER_FIELD_4_UNT_C | Character | |
| User Field 5 | MI_OPERTION_USER_FIELD_5_N | Numeric | |
| User Field 5 Unit | MI_OPERTION_USER_FIELD_5_UNT_C | Character | |
| User Field 6 | MI_OPERTION_USER_FIELD_6_N | Numeric | |
| User Field 6 Units | MI_OPERTION_USER_FIELD_6_UNT_C | Character | |
| User Field 7 | MI_OPERTION_USER_FIELD_7_N | Numeric | |
| User Field 7 Units | MI_OPERTION_USER_FIELD_7_UNT_C | Character | |
| User Field 8 | MI_OPERTION_USER_FIELD_8_D | Character | |
| User Field 9 | MI_OPERTION_USER_FIELD_9_D | Character | |
| User Field 10 | MI_OPERTION_USER_FIELD_10_F | Boolean | |
| User Field 11 | MI_OPERTION_USER_FIELD_11_F | Boolean | |
| Order Quantity Unit | MI_OPERTION_ORDER_QTY_UNIT_C | Character | |
| Order Quantity | MI_OPERTION_ORDER_QTY_C | Character | |
| Package Number | MI_OPERTION_PKG_NUMBER_C | Character | |
| Execution Factor | MI_OPERTION_EXE_FACTOR_C | Character | |
| Long Text | MI_OPERTION_LONG_DESC_TX | Text | |
| System Condition | MI_OPERTION_CONDITION_C | Character | |
| Previous Operation Number | MI_OPERTION_PREV_ID_C | Character | |
| Previous Sub Operation Number | MI_OPERTION_PREV_SUB_ID_C | Character |
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | This field is used as a Package ID |
| Maintenance Plan|ID | MI_MAINTPLN_ID_C | Character | This field is used as a maintenance plan ID |
| Maintenance Item|Maintenance Item | MI_MAINTITM_ID_C | Character | This field is used as a maintenance item. |
| Task List|Group | MI_TASKLIST_GROUP_C | Character | This field is used as a task list. |
| Task List|Group Counter | MI_TASKLIST_GROUP_CNTR_C | Character | |
| Operation|Operation | MI_OPERTION_ID_C | Character | |
| Material Number | MI_MATERIAL_NUMBER_C | Character | |
| Quantity | MI_MATERIAL_QTY_N | Numeric | |
| Unit of Measure | MI_MATERIAL_UOM_C | Character | This field 'MI_MATERIAL_UOM_C' is disable and cannot be updated. |
| Field Caption | Field ID | Data Type (Length) | Comment |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | This field is the ID for the Package. |
| Maintenance Plan|ID | MI_MAINTPLN_ID_C | Character | This field is used for maintenance plan ID. |
| Maintenance Item|Maintenance Item | MI_MAINTITM_ID_C | Character | This field is used for maintenance item |
| Task List|Group | MI_TASKLIST_GROUP_C | Character | This field is used as task list |
| Task List|Group Counter | MI_TASKLIST_GROUP_CNTR_C | Character | This field is used as task list, group counter |
| Operation|Operation | MI_OPERTION_ID_C | Character | This field is used for operation. |
| Item Number | MI_PRT_ITEM_NUM_N | Numeric | |
| Document Type | MI_PRT_DOC_TYPE_C | Character | This field is used to show document type |
| Document Version | MI_PRT_DOC_VER_C | Character | This field is used for document version |
| Document Part | MI_PRT_DOC_PART_C | Character | This field is used for document part |
| Quantity | MI_PRT_QUANTITY_N | Numeric | This field is used for quantity |
| Quantity Unit | MI_PRT_QUANTITY_UNIT_C | Character | This field is used for quantity unit |
| Control Key | MI_PRT_CONTROL_KEY_C | Character | This field is used as control key |
| Document Binary | MI_PRT_DOCUMENT_B | Binary | |
| Storage Category | MI_PRT_STORAGE_CATEGORY_C | Character | This field is used as storage categoy |
| Document | MI_PRT_DOC_C | Character | This field is used for document. |
| Field Caption | Field ID | Data Type (Length) | Comment |
|---|---|---|---|
| Package ID | MI_IMPPACKG_ID_C | Character | This field is used as package id |
| Maintenance Plan|ID | MI_MAINTPLN_ID_C | Character | This field is used as maintenance plan ID |
| Maintenance Item|Maintenance Item | MI_MAINTITM_ID_C | Character | This field is used as maintenance item |
| Task List|Group | MI_TASKLIST_GROUP_C | Character | This field represents task list or group |
| Task List|Group Counter | MI_TASKLIST_GROUP_CNTR_C | Character | This field represents task list or group counter |
| Operation|Operation | MI_OPERTION_ID_C | Character | This field is used for operation |
| Maintenance Package Number | MI_MAINTPKG_NUMBER_N | Numeric | This field is used for maintenance package number. |
| Cycle Length | MI_MAINTPKG_CYCLE_LENGTH_N | Numeric | |
| Cycle UOM | MI_MAINTPKG_CYCLE_UOM_C | Character | |
| Cycle | MI_MAINTPKG_CYCLE_C | Character |
| Field Caption | Field ID | Data Type (Length) | Comment |
|---|---|---|---|
| Functional Location | MI_NOTIFCTN_LOCATION_C | Character | This field is used for functional location. |
| Description | MI_NOTIFCTN_DESC_TX | Text | This field is used for notification description. |
| Required Start Date | MI_NOTIFCTN_REQ_START_DATE_DT | Date | This field is used for required start date. |
| Priority | MI_NOTIFCTN_PRIORITY_C | Character | This field is used for priority. |
| Date Imported | MI_NOTIFCTN_DATE_IMPORTED_DT | Date | |
| Import Status | MI_NOTIFCTN_IMPORT_STATUS_C | Character | |
| Notification Source | MI_NOTIFCTN_SOURCE_C | Character | This field is used for notification resource. |
| Required End Date | MI_NOTIFCTN_REQ_END_DATE_DT | Date | |
| Notification Type | MI_NOTIFCTN_NOTIF_TYPE_C | Character | This field is used for notification type |
About the ASI Data Loader Load Verification
A successful data import will have the same effect as creating a new Asset Strategy Implementation in APM. After a successful data load, if the data loader creates a new strategy or template, it will appear in the Asset Strategies Implementation section or the Templates section in the Strategy Implementation Overview page.
A successful import can also be defined as an event in which partial data on a worksheet is loaded into APM, and a message appears, helping you identify and correct issues resulting from the import.