The mining normalisation engine
A seven-stage pipeline that transforms raw mine-register CSVs into clean, classified, enriched, and scored records — ready for Maximo, SAP PM, or any EAM platform.
EAM export ready for
CSV Pre-processing
Struktive detects and skips preamble rows, maps non-standard column headers to canonical fields, and handles real-world quoting and encoding issues common in mine-register exports. Handles mixed-format mine register exports from SAP PM, Pronto, and bespoke spreadsheets.
- Preamble row detection (title rows, blank rows, metadata blocks)
- Mine-register column alias coverage: functional location, equipment tag, plant section
- Multi-encoding detection (UTF-8, Latin-1, Windows-1252)
- Resilient CSV parsing with automatic delimiter detection
OEM Name Resolution
400+ alias rules map manufacturer name variations, acquisition-history names, and regional spellings to canonical OEM names. Covers the full mining OEM landscape including historical acquisitions: P&H → Komatsu, Bucyrus → Caterpillar, Atlas Copco → Epiroc, Joy Global → Komatsu.
- 400+ alias rules including acquisition history (P&H→Komatsu, Bucyrus→Cat, Joy Global→Komatsu)
- Case-insensitive matching with punctuation normalisation
- Confidence-scored output: exact match, fuzzy match, and unknown tiers
- Unknown OEMs preserved as-is with a low-confidence flag for manual review
Mine Hierarchy Parsing
The location parser extracts a structured Mine → Area → Level → Zone → Bench hierarchy from any free-text format. Handles both surface and underground schemas. Supports Open Pit / Level / Zone / Area / Bench from any free-text format.
- Surface schema: Open Pit → Area → Bench → Zone
- Underground schema: Level → Zone → Drive → Bay
- Functional location code parsing (SAP PM FL format)
- Site default applied at upload time to records without explicit mine location
Asset Classification
A 12-category classification engine assigns every asset to the correct equipment type. Categories cover the full mining equipment stack: Haul Truck, Electric Shovel, Drill Rig, Dozer, LHD, Crusher, Mill, and more. Keyword rules handle 80% of assets instantly.
- 12 equipment categories covering the full mining fleet
- Haul Truck, Electric Shovel, Drill Rig, Dozer, LHD, Crusher, Mill, and more
- AI inference for ambiguous assets with confidence scoring
- Classification confidence reported as High, Medium, or Low per record
EAM Enrichment
Validated equipment records are matched against 1,200+ equipment models from the Struktive mining reference library. Matched equipment receives power ratings (kW / hp / L·hr), payload capacity (tonnes), and CLASSSTRUCTUREID for Maximo import.
- Validated against 1,200+ equipment models across all major mining OEMs
- Enriches: power rating (kW / hp / L·hr), payload capacity (tonnes)
- CLASSSTRUCTUREID assigned automatically for Maximo import
- Unmatched equipment flagged in pre-flight validation report
Duplicate Detection
A multi-signal duplicate detector identifies likely duplicates using equipment tag matching, fuzzy serial matching with OEM+model+location flagging. Configurable thresholds for mine-site naming conventions where the same physical asset may appear under multiple functional locations.
- Exact equipment tag matching (case-insensitive, punctuation-normalised)
- Fuzzy serial matching with sequential batch serial exclusion logic
- OEM + model + location composite key flagging
- Configurable thresholds for mine-site naming conventions
Quality Scoring
Every record receives a 0–100 quality score across seven factors: completeness, classification confidence, location depth, OEM resolution, model enrichment, and data integrity signals. Records scoring 70 or above are considered EAM import-ready.
- Multi-factor scoring: completeness, classification confidence, location depth, integrity signals
- Weighting reflects Maximo and SAP PM ingestion requirements
- Score thresholds: ≥85 Excellent · 70–84 Import-ready · <70 Needs review
- Duplicate flags applied as score penalties
Quality score factors
Each record receives a score from 0 to 100 based on multiple weighted factors. Records scoring 70 or above are considered EAM import-ready. The exact weighting reflects the requirements of Maximo and SAP PM ingestion pipelines.
Column alias detection
Struktive maps non-standard column headers to canonical field names automatically. Mine-register exports from SAP PM, Pronto, and bespoke spreadsheets are all handled without renaming columns.
Request a sample report
Not ready to upload your own data? We'll run a representative mine-register dataset through the full pipeline and email you the complete output — including Maximo-ready CSV, SAP PM export, and ISO 55001 compliance pack.