IQDoc
ITIQPro Docs Maintenance Connection Everywhere (MCe) · EAM/CMMS manuals
MaintainX asset tree structure compatibility with MCe

Moving or Synchronizing MaintainX Assets with ITIQPro MCe

When moving from MaintainX to ITIQPro's MCe—or operating MaintainX and MCe together—the first question is not simply "How do we import our assets?"

The more useful question is:

How much of the asset structure we have already built in MaintainX should we preserve, and how should we take advantage of the additional structure and capabilities available in MCe?

This is an important distinction from migrations from systems that essentially present equipment as a large flat asset population.

MaintainX already supports parent and sub-asset relationships, so a well-configured MaintainX system may already contain a useful equipment hierarchy. It also has a separate concept of Locations, which can be associated with assets.

That gives us considerably more information to work with during an MCe implementation.

The objective should generally not be to throw that structure away.

Instead, we can use it as the starting point for a richer MCe asset model.

Start with What You Already Have

A typical MaintainX implementation might contain something similar to the following:

Packaging Line 1

  • Filler
    • Pump
    • Drive Motor
  • Capper
  • Labeler
  • Conveyor

If those parent/sub-asset relationships have already been created in MaintainX, they provide a natural basis for constructing the corresponding MCe Asset Tree.

There is usually no reason to flatten that information during migration.

The first stage can therefore be quite straightforward:

MaintainX Parent/Sub-Asset relationships → MCe Asset Tree relationships

This preserves the work that has already gone into organizing the equipment while allowing the organization to continue developing the structure in MCe.

Assets and Locations Are Different Things

One of the more important decisions when moving MaintainX data into MCe is determining how to interpret MaintainX Assets versus MaintainX Locations.

MaintainX keeps these concepts separate.

An asset represents equipment, while a Location identifies where equipment is located. A location can contain multiple assets, and MaintainX also supports parent and sub-locations.

That separation can be useful, but when constructing an MCe Asset Tree there may be opportunities to combine some of that information into a hierarchy that is particularly natural for maintenance personnel to navigate.

For example, MaintainX might contain:

Location: Calgary Plant Sub-Location: Building A

with assets:

  • Boiler 01
  • Boiler 02
  • AHU-01
  • AHU-02

MCe might represent this as:

Calgary Plant

  • Building A
    • Mechanical Room
      • Boiler 01
      • Boiler 02
    • HVAC
      • AHU-01
      • AHU-02

The exact conversion is not predetermined.

For one organization, MaintainX Locations may become portions of the MCe Asset Tree.

For another, they may remain attributes associated with assets.

For another, we may use a combination of Location, Asset Type, parent asset and other information to construct the desired tree.

The important point is that migration does not have to mean copying the MaintainX screen structure literally.

We should first determine how users actually think about and navigate the facility.

MaintainX Already Has Asset Hierarchies—but Consider How Far You Want to Take Them

If your organization has made extensive use of MaintainX sub-assets, much of the initial hierarchy may already exist.

For example:

Air Handler AHU-01

  • Supply Fan
    • Motor
  • Return Fan
    • Motor

That can be transferred naturally into MCe.

However, migration is also a good opportunity to ask whether this is where the hierarchy should stop.

Perhaps technicians actually think of AHU-01 as:

AHU-01

  • Supply Air
    • Supply Fan
      • Motor
        • Drive
        • Bearings
      • Fan Assembly
      • Belt Drive
    • Filter Bank
      • Pre-Filter
      • Final Filter
  • Return Air
    • Return Fan
      • Motor
      • Fan Assembly
  • Heating
    • Heating Coil
    • Control Valve
  • Cooling
    • Cooling Coil
    • Control Valve
  • Controls
    • Supply Air Temperature Sensor
    • Return Air Temperature Sensor
    • Differential Pressure Sensor
    • Damper Actuator

The question during migration is therefore not:

"How many levels did we have in MaintainX?"

It is:

"What is the useful maintenance hierarchy for this equipment?"

Your existing MaintainX structure gives us a very good starting point. It does not have to define the final MCe structure.

Do Not Create Detail Merely for the Sake of Detail

A deeper Asset Tree does not mean that every nut, bolt and filter needs to become an asset.

The question should always be whether treating something as an independent asset provides value.

A separate child asset becomes useful when you want to independently:

  • create work against it;
  • maintain its work history;
  • inspect it;
  • identify or scan it;
  • attach documents or procedures to it;
  • record specifications;
  • track condition;
  • track failures;
  • associate meters, IoT devices or sensor information with it;
  • replace or move it;
  • analyze its costs;
  • report against it; or
  • automate maintenance activity associated with it.

If none of those apply, the information may be more appropriately stored as specifications or other information associated with its parent.

The objective is not to build the deepest possible tree.

The objective is to build the most useful maintenance model.

Two Different Scenarios: Synchronization or Upgrade

There are two substantially different reasons a MaintainX customer may be implementing MCe.

Scenario 1 — MaintainX Remains in Use

In some organizations, MaintainX may continue to serve a particular group or business function while MCe is introduced for additional capabilities.

In that situation, the implementation is a synchronization project.

We need to decide:

  • Which MaintainX assets should exist in MCe?
  • Which MCe assets should exist in MaintainX?
  • Which system owns each piece of information?
  • Which system is allowed to create assets?
  • Which system controls parent relationships?
  • How should MaintainX Locations map into MCe?
  • Which changes should synchronize in each direction?
  • What happens when an asset is moved?
  • What happens when an asset is retired or deleted?
  • Can MCe contain additional assets that do not exist in MaintainX?

That last question can be particularly important.

MCe Does Not Necessarily Have to Be Limited to MaintainX Assets

Suppose MaintainX contains:

Packaging Line 1

  • Filler
  • Capper
  • Labeler

Those assets can synchronize into MCe.

But MCe might extend that structure:

Packaging Line 1 (MaintainX + MCe)

  • Filler (MaintainX + MCe)
    • Fill Pump (MCe)
      • Motor (MCe)
      • Pump Assembly (MCe)
    • Product Valve Bank (MCe)
    • Level Sensor (MCe)
  • Capper (MaintainX + MCe)
    • Cap Feed Motor (MCe)
    • Cap Sensor (MCe)
  • Labeler (MaintainX + MCe)
    • Drive (MCe)
    • Label Sensor (MCe)

The high-level equipment continues to synchronize with MaintainX, while MCe contains additional detail.

This allows an organization to introduce MCe without requiring that every new piece of maintenance information also be added to MaintainX.

Establish the MaintainX Synchronization Boundary

If the two products will coexist, it is important to establish a clear MaintainX synchronization boundary.

An MCe asset should be identifiable as either synchronized with MaintainX or managed exclusively within MCe.

Conceptually:

Site — synchronized ↳ Production Line — synchronized ↳ Filler — synchronized ↳ Pump Assembly — MCe only ↳ Motor — MCe only ↳ Bearings — MCe only

Adding Bearings underneath Motor should not cause Bearings, Motor and Pump Assembly to suddenly appear in MaintainX.

Likewise, changing an MCe-only asset should not generate meaningless synchronization traffic attempting to update a record that does not exist in MaintainX.

The integration needs a reliable identity and ownership mechanism so that it always knows which records participate in synchronization.

Decide Who Owns the Tree

This becomes especially important when both products support parent/child assets.

Suppose MaintainX says:

Line 1 → Pump 01

but an MCe user moves Pump 01 to:

Line 2 → Pump 01

Which one is correct?

There are several valid models.

MaintainX can be authoritative, in which case the next synchronization moves Pump 01 back under Line 1 in MCe.

MCe can be authoritative, in which case the change is synchronized back to MaintainX.

Or hierarchy changes can require explicit synchronization or approval.

What should generally be avoided is allowing both systems to independently own the same relationship without a conflict policy.

The same principle applies to fields such as:

  • asset name;
  • status;
  • location;
  • parent;
  • asset type;
  • manufacturer;
  • model;
  • serial number;
  • barcode;
  • criticality; and
  • other shared information.

For every synchronized field, the implementation should know which system is authoritative—or how a genuine bidirectional change is resolved.

Be Particularly Careful with Parent Changes

A hierarchy is more than a cosmetic display.

Suppose MaintainX contains:

Production Line 1

  • Pump 01

and MCe extends Pump 01:

Pump 01

  • Motor
  • Coupling
  • Pump Assembly
    • Impeller
    • Mechanical Seal

If MaintainX subsequently moves Pump 01 to Production Line 2, we normally want MCe to move the entire Pump 01 branch:

Production Line 2

  • Pump 01
    • Motor
    • Coupling
    • Pump Assembly
      • Impeller
      • Mechanical Seal

We do not want to lose the MCe-only structure simply because the synchronized parent changed.

This is one reason that synchronization should understand the tree rather than treating every asset as an isolated record.

Scenario 2 — Replacing MaintainX with MCe

The situation is different if the organization is upgrading from MaintainX to MCe and MaintainX will no longer be the operational maintenance system.

Now we do not have to preserve synchronization compatibility indefinitely.

Instead, the objective is:

Preserve the useful information from MaintainX, transform it into the best MCe structure, validate it, and then allow MCe to become the system of record.

That gives us considerably more freedom.

Preserve Existing Asset Relationships

Existing MaintainX parent/sub-asset relationships should normally be retained during migration unless there is a reason to change them.

The existing structure represents organizational knowledge that users have already invested time building.

If MaintainX contains:

CNC Mill 01

  • Spindle
  • Coolant System
  • Hydraulic System

then those relationships provide an obvious starting structure in MCe.

Preserve Asset Identity

We should also preserve the identity of the original MaintainX records.

Names are not necessarily identities.

"Pump 1" can become "CHWP-001" next year and still be the same physical pump.

A migration should therefore preserve the appropriate MaintainX identifiers or migration metadata so that the origin of an MCe asset can be determined after migration.

This is especially important if historical data is also being transferred.

Bring Across Useful Asset Information

Depending on the MaintainX data available and the scope of the migration, useful information associated with an asset may include things such as:

  • asset name and identifier;
  • description;
  • parent asset;
  • location;
  • asset type;
  • status;
  • criticality;
  • manufacturer;
  • model;
  • serial number;
  • QR code or barcode;
  • responsible teams;
  • vendors;
  • parts relationships;
  • associated documents;
  • meter information; and
  • maintenance and work history.

Not every field necessarily maps one-to-one into MCe.

The migration process should determine the semantic equivalent, rather than simply looking for columns with similar names.

Take Advantage of the Migration to Fix the Asset Model

One of the biggest mistakes in any CMMS migration is treating it purely as a database conversion.

If the old system contains:

Plant

  • Equipment 1
  • Equipment 2
  • Equipment 3
  • Equipment 4
  • Equipment 5
  • Equipment 6
  • ...

then successfully importing the same organization into the new system gives you a technically successful migration—but not necessarily an improved maintenance system.

An upgrade to MCe is an opportunity to ask:

If we were designing our asset structure today, knowing what we know now, how would we organize it?

Perhaps MaintainX currently has:

Calgary Facility

  • Compressor 01
  • Compressor 02
  • Boiler 01
  • Boiler 02
  • Pump 01
  • Pump 02
  • Pump 03
  • RTU-01
  • RTU-02

During the MCe implementation, we may decide that the more useful structure is:

Calgary Facility

  • Building A
    • Compressed Air
      • Compressor 01
      • Compressor 02
    • Boiler Plant
      • Boiler 01
      • Boiler 02
        • Burner
        • Feedwater System
        • Controls
    • HVAC
      • RTU-01
      • RTU-02
  • Process Systems
    • Cooling Water
      • Pump 01
      • Pump 02
      • Pump 03

That is more than an import.

It is an opportunity to turn accumulated maintenance data into a more useful maintenance model.

Locations Deserve Special Attention During a MaintainX Migration

Because MaintainX has separate Location and Asset concepts, this deserves specific attention during migration planning.

A MaintainX implementation might have:

Location: Edmonton Facility ↳ Sub-Location: Production

with assets assigned to Production:

  • Conveyor 01
  • Conveyor 02
  • Packaging Line 1

When moving to MCe, we should ask whether those concepts should remain separate or whether some of them belong naturally within the Asset Tree.

For example:

Edmonton Facility

  • Production
    • Packaging Line 1
      • Conveyor 01
      • Conveyor 02

Alternatively, the facility and area may remain location information while the MCe Asset Tree begins at Packaging Line 1.

Neither approach is inherently correct.

The correct model depends on questions such as:

  • How do technicians locate equipment?
  • How do users browse for work?
  • At what level are work orders created?
  • Do buildings, rooms or areas themselves require maintenance?
  • Do assets move between locations?
  • Does the organization report by facility or area?
  • Are locations physical places, logical systems, or both?
  • Does the organization want facility structures to participate directly in the maintenance hierarchy?

A warehouse, room or production area may itself be something that requires inspections and maintenance. In that case, representing it within the broader MCe structure may be valuable.

Portable Assets Need Different Treatment

Another reason not to blindly convert Location into hierarchy is movable equipment.

Consider:

Forklift 27

Today it is in Warehouse A.

Tomorrow it is in Warehouse B.

The warehouse should probably not become the permanent parent that defines the forklift's identity.

MaintainX explicitly tracks location and parent changes in its asset history. During migration, this distinction between "where an asset is" and "what an asset is part of" needs to be preserved.

For stationary plant equipment:

Building → Mechanical Room → Boiler → Burner

may be an excellent hierarchy.

For portable equipment:

Forklift 27 Current Location: Warehouse B

may be considerably better.

The migration design therefore needs to distinguish physical containment, functional parentage, and current location rather than assuming they are always the same relationship.

Work History Matters When Rebuilding the Hierarchy

When restructuring assets during an upgrade, historical work should continue to belong to the equipment on which it was performed.

For example, if MaintainX currently has:

AHU-01

with five years of work history, and during the migration we expand it into:

AHU-01

  • Supply Fan
  • Return Fan
  • Heating Coil
  • Cooling Coil
  • Controls

we should not arbitrarily redistribute five years of AHU-01 work history among those new components.

That historical work occurred against AHU-01 and should generally remain associated with the migrated AHU-01 record.

From the point MCe goes live, technicians can begin creating more granular work against the appropriate child assets.

Over time, MCe then accumulates the more detailed history naturally.

QR Codes and Barcodes Should Be Part of the Migration Plan

MaintainX supports QR codes and barcodes for assets, and organizations may already have labels physically attached to equipment.

Those labels should not be ignored during an upgrade.

If practical, retaining the existing identifier can avoid the cost and disruption of relabeling an entire facility.

Where identifiers need to change, the migration should determine whether existing labels can remain as alternate identifiers or whether a controlled relabeling process is appropriate.

A seemingly minor decision about asset IDs can otherwise result in hundreds or thousands of physical labels needing replacement.

The Migration Is Also an Opportunity to Standardize

Over time, CMMS databases tend to accumulate inconsistencies.

For example:

  • AHU 1
  • AHU-02
  • Air Handler #3
  • RTU4
  • Roof Top Unit 05

Likewise, asset types, manufacturers, locations and naming conventions may have evolved as different people administered the system.

Moving to MCe is an excellent opportunity to establish conventions for:

  • Asset IDs;
  • Asset Names;
  • hierarchy;
  • classifications;
  • locations;
  • manufacturers;
  • models;
  • criticality;
  • statuses;
  • specifications;
  • naming conventions; and
  • required asset information.

Migration tooling can often normalize much of this data instead of carrying every historical inconsistency forward.

Do Not Assume Everything in MaintainX Needs to Become an Asset

Migration is also an opportunity to reconsider records that may have been represented as assets simply because that was the easiest way to manage them.

Some information may be better represented in MCe as:

  • specifications;
  • classifications;
  • procedures;
  • parts;
  • documents;
  • meters;
  • organizational nodes;
  • other related information.

Conversely, something that was merely information attached to a MaintainX asset may deserve to become a separate MCe asset because technicians actually maintain it independently.

The question is always:

What representation will make the maintenance process better?

not:

What representation makes the import easiest?

A Practical MaintainX-to-MCe Planning Exercise

Before synchronization or migration begins, we recommend reviewing a representative portion of the customer's existing MaintainX data.

Do not start with the easiest ten assets.

Choose examples that represent the real complexity of the organization:

  • a large asset hierarchy;
  • a simple asset;
  • a portable asset;
  • an asset with substantial history;
  • equipment with several sub-assets;
  • several locations;
  • equipment that has moved;
  • assets with QR/barcodes;
  • assets with meters;
  • heavily maintained equipment;
  • and equipment that users believe is currently represented poorly.

Then build the proposed MCe structure for those examples.

This exercise usually answers many of the important questions before thousands of records are migrated.

Questions to Answer Before Synchronization

For a MaintainX/MCe synchronization, determine:

  1. Which system owns asset creation?
  2. Which system owns asset identity?
  3. Which system owns the parent/sub-asset relationship?
  4. How should MaintainX Locations and Sub-Locations map into MCe?
  5. Which asset fields synchronize?
  6. Which system is authoritative for each field?
  7. Can MCe contain additional assets?
  8. Can MaintainX contain assets that are deliberately excluded from MCe?
  9. What happens when an asset changes parent?
  10. What happens when an asset changes location?
  11. What happens when an asset becomes inactive?
  12. What happens when an asset is deleted?
  13. How are conflicts resolved?
  14. How are QR codes and barcodes handled?
  15. Which work and maintenance information is synchronized?
  16. How are new MCe-only child assets prevented from synchronizing back unintentionally?

These rules should be established before bidirectional synchronization is enabled.

Questions to Answer Before a Complete Upgrade

If MaintainX is being replaced rather than synchronized, the questions are somewhat different:

  1. Which assets should be retained?
  2. Which existing parent/sub-asset relationships should be preserved?
  3. Which hierarchies should be redesigned?
  4. How should Locations map into MCe?
  5. Should additional hierarchy levels be introduced?
  6. Which existing asset records should actually become structural nodes, specifications or other information?
  7. Which equipment deserves more detailed child assets?
  8. Which historical work should be migrated?
  9. How much history is useful?
  10. Which documents and attachments should be retained?
  11. How should existing QR/barcode labels be handled?
  12. Which naming and classification inconsistencies should be cleaned up?
  13. Which custom information needs an MCe equivalent?
  14. How will migrated records retain their original MaintainX identity?
  15. At what point does MCe become the authoritative system and MaintainX become read-only or get retired?

Synchronization and Migration Are Different Projects

This distinction is worth emphasizing.

If MaintainX will continue operating, the integration must respect the capabilities and data model of both systems. The MCe structure may extend beyond MaintainX, but the synchronization boundary needs to remain clear.

If the organization is replacing MaintainX, there is no reason to permanently constrain MCe to the structure of the system being replaced.

Preserve what is valuable:

asset identity → relationships → history → documents → maintenance knowledge

but reconsider the structures that existed primarily because of the previous system.

The Key Principle

A MaintainX implementation can already contain a significant amount of useful structure. Parent/sub-asset relationships, locations, asset types, QR/barcodes and the accumulated maintenance history all represent information that should be considered carefully during an MCe implementation.

That information should be treated as an investment, not an obstacle.

When MaintainX and MCe will coexist, we can preserve the MaintainX structure, synchronize the appropriate records, and establish a clear boundary where MCe can provide additional capabilities or detail.

When MCe is replacing MaintainX, we can go further.

The existing MaintainX hierarchy becomes the starting point, not a restriction on the new system.

The objective is not to make MCe look exactly like MaintainX.

It is to preserve the maintenance knowledge the organization has already accumulated while using the move to MCe as an opportunity to create a better asset model for the next ten years.