0 selected

Main asset tree

Holding area

Data Quality Dashboard

--
Score
Overall Data Quality
📊 Calculating...

Quality Metrics

Collection Progress

Criticality Distribution

Completeness by Criticality

Completeness by Equipment Class

Field Completeness

Instructions

  • Click + or to expand/collapse branches.
  • Click a row to select. Ctrl+Click for multi-select.
  • Double-click to open details. Press Enter on selection.
  • ⚠ means duplicate tag or validation issue.
  • Drag nodes to reorganise between trees.

Selection Actions

Select one or more nodes first.

Data Management

Utilities

Import Data

Import asset data from CSV or Excel files. Download the template to see the expected format.

Export Data

Export your prepared asset data. Map to your CMMS format using your system's import tools.

Summary Report

Generate a printable summary of your asset hierarchy and data quality metrics.

Audit Log Export

Export a log of all changes made during this project for audit trail documentation.

Equipment Library

Your equipment library grows as you add makes/models. Export to share with team or import from colleagues.

Validation Issues

No validation issues detected yet.

Quick Fixes

Apply bulk fixes to common data quality issues.

Description Length (SAP Compatibility)

Intelligently abbreviate descriptions for CMMS systems with character limits (e.g., PUMP CENTRIFUGAL → PMP CENT).

Spelling & Terminology

Detect and fix common misspellings in maintenance/engineering terminology (e.g., COMPRESSER → COMPRESSOR).

Text Formatting & Standardization

Tools to ensure consistent formatting across all asset data.

Description Format

Choose how noun and modifier are separated in descriptions.

Text Case

Standardize text case across all assets.

Whitespace Cleanup

Fix spacing issues in text fields.

Description Length (SAP/CMMS Compatibility)

Intelligently abbreviate descriptions for systems with character limits.

e.g., PUMP CENTRIFUGAL → PMP CENT

Spelling & Terminology

Fix common misspellings in maintenance/engineering terms.

e.g., COMPRESSER → COMPRESSOR, SEPERATOR → SEPARATOR

Naming Consistency

Find description variations that should be standardized.

Bulk Data Cleansing

Powerful tools to standardize and clean your asset data at scale.

Find & Replace

Search and replace text across all assets. Supports descriptions, manufacturers, and other fields.

Manufacturer Standardization

Find and merge variations of manufacturer names (e.g., "Siemens", "SIEMENS", "Seimens").

Smart Redundancy Detection

Auto-detect redundant pairs from tag patterns (A/B, 1/2 suffixes) and configure duty/standby relationships.

Bulk Classification

Find assets by NOUN + MODIFIER pattern and assign CMMS equipment codes.

Data Quality Audit

Run comprehensive checks for common data issues.

Equipment Templates

Save and reuse common equipment configurations.

No templates saved yet. Open an asset and click "Save as Template".

Actions

Code Library

Equipment codes combine Class + Type codes. Codes can be any length to match your project requirements.
Example: PU (Pump) + CE (Centrifugal) = PUCE

Equipment Classes

Code Name Types Source Actions

Equipment Types

Combined Class Type Name Source Actions

Failure Modes

Code Name Description Source Actions

CMMS Global Failure Codes

1,436 codes

Industry-standard failure coding system: Code (FCo)Problem (FP)Cause (FCa)Remedy (FR)

Code Description (Component - Failure Type)
Library Statistics: Loading...

Hierarchy Diagram

Visual representation of your asset hierarchy. Click nodes to select. Drag to pan. Use for client presentations and sign-off.

Location
Equipment
Selected

Spreadsheet View

Click column headers to sort. Type in filter row to search. Edit cells directly. Double-click row to open details.

Lvl Type Tag Description CMMS Code Crit SECE Manufacturer Model Serial Parent
0 items Tab next cell • Enter save • Dbl-click details