MADE Workflows > Create Maintenance Action Import Configuration
WF78: Create Maintenance Action Import Configuration
Detailed Steps
- Open Application Preferences (Task Menu: Preferences > Application Preferences).
- Select Maintenance Action tab (Task Menu: Preferences > Application Preferences > Modeling > Import > Maintenance Action).
- Click the '+' icon to create a new Maintenance data import configuration.
- Define Import Configuration Details — Name, Description.
- Define mapping in the Action tab — allows mapping of essential details for each maintenance action defined for an item: Name*, Maintenance Action ID*, Active?, Description, Inspection Interval (hrs), Maintenance Interval (hrs), Location (Field, Local Depot, or Remote Depot), Maintenance Type (combines type and sub-type, e.g. Breakdown, Repair). Enter worksheet name and header rows, and complete the mapping. Properties marked * are mandatory.
- Define mapping in the Tasks tab — allows mapping of individual tasks linked to maintenance actions: Name*, Maintenance Action ID (links Tasks and Action categories), Task ID*, Activity Type (maintenance or inspection), Downtime? (whether the task requires downtime), Duration (hrs) (time to complete the task). Enter worksheet name and header rows, and complete the mapping.
- Define mapping in the Personnel tab — allows mapping of individuals involved in maintenance tasks: Name*, Personnel ID*, Maintenance Task ID* (links to relevant tasks), Quantity (total individuals assigned), Rate (cost per person per hour). Enter worksheet name and header rows, and complete the mapping.
- Define mapping in the Items tab — allows mapping of equipment and consumables required for the maintenance action: Name*, Maintenance Action ID*, Item ID, Activity Type, Quantity, Unit Cost. Enter worksheet name and header rows, and complete the mapping.
- Import configuration is created — the Maintenance Action import configuration is created and ready for use. Refer to the Maintenance Import guide.
Screen-by-screen detail (from embedded screenshots)
- Step 1: Open Application Preferences — Main menu: Preferences > Application Preferences.
- Step 2: Select Maintenance Action Tab — Preferences tree: Modeling > Contributor Roles, Failure Diagram, Fault Tree Analysis, Import > Component, FMEA Data, Maintenance Action [selected], Requirement; Maintenance Locations, Maintenance Personnel, Status Text, Tool-tips. Right panel "Maintenance Action" > "Maintenance Action Import Configurations" table (Default, Name, Columns) with add/edit/copy/delete icons.
- Step 3: Create a New Configuration — Click the green '+' icon.
- Step 4: Define Import Configuration Details — "Maintenance Action Import Configuration" dialog: Name (e.g. "Import config for demo"), Description (e.g. "Narrative for demo"). Four tabs: "Action", "Tasks", "Personnel", "Items". Warning initially: "There are no configured columns for any of the worksheets in the maintenance action import configuration."
- Step 5: Define Mapping in Action Tab — Worksheet (e.g. "Sheet1"), Header Rows (e.g. 1). Column mapping table example: Column A -> MADE Property "Maintenance Action ID" (Text, Validation "Non-empty"); Column B -> "Name" (Text, Validation "Non-empty").
- Step 6: Define Mapping in Tasks Tab — Worksheet "Sheet1", Header Rows 1. Example: Column A -> "Maintenance Action ..." (Text, N/A); Column B -> "Task ID" (Text, Non-empty); Column C -> "Name" (Text, Non-empty).
- Step 7: Define Mapping in Personnel Tab — Worksheet "Sheet1", Header Rows 1. Example: Column A -> "Maintenance Task ID" (Text, N/A); Column B -> "Name" (Text, Non-empty).
- Step 8: Define Mapping in Items Tab — Worksheet "Sheet1", Header Rows 1. Example: Column A -> "Maintenance Action ID" (Text, N/A); Column B -> "Name" (Text, Non-empty).
- Step 9: Import Configuration is Created — Back in "Maintenance Action Import Configurations" list, the new configuration appears (e.g. "Import config for demo", marked Default, Columns "9"). Click Apply and Close.
Source: Local MADE 3.9.1 installation: com.phm.made.help.plugin/documents/help/pdf/Workflows/WF78-Create Maintenance Action Import Configuration.pdf · retrieved 2026-07-09