Most maintenance departments have the same Excel problem. There are four spreadsheets tracking asset information, maintained by three different people, none of which agree with each other. The equipment register has not been updated since 2021. The PM schedule exists in someone's calendar. And when a technician needs the maintenance history on a compressor, they ask the most senior person in the room.
Moving to a GMAO (Gestión del Mantenimiento Asistida por Ordenador—the Spanish equivalent of CMMS) fixes all of that. But the migration itself is where most implementations go wrong. This guide gives you a practical, sequenced approach that produces a working digital maintenance system in 90 days without destroying your team's productivity in the process.
Step 1: Build Your Asset Register Before Touching the Software
The biggest mistake in GMAO implementations is trying to configure the software before you have clean asset data. You end up entering messy data fast and spending months cleaning it up later.
Spend two to three weeks creating a flat asset register in a spreadsheet first. For each asset, capture: asset name, asset tag or serial number, location (building, floor, room, or production line), manufacturer, model, installation year, and criticality rating (A for critical, B for important, C for non-critical).
Do not overthink the criticality rating. Ask one question: if this asset failed right now, would it stop production or create a safety hazard? If yes, it is a Class A asset. If it would cause significant inconvenience but not stop operations, Class B. Everything else is Class C.
A typical industrial facility with 300 assets can complete this register in two to three weeks with one dedicated person doing physical walkdowns. Do not rely on existing documentation—it is almost always incomplete or outdated. Walk the facility with a tablet.
Step 2: Set Up QR Codes and Asset Identification
Before entering a single asset into your GMAO, decide on your asset identification system. This decision is harder to change later than you might expect.
QR codes on equipment are the most practical solution for most operations. They cost almost nothing to print, attach in seconds, and allow any technician to scan and pull up the equipment record instantly. Industrial-grade QR code labels with UV and chemical resistance cost around €0.15-0.30 each and hold up in most plant environments.
Assign your asset tag numbers before printing labels. Use a logical numbering system: facility code, area code, asset type code, and sequential number. For example: FAC01-COMP-001 for the first compressor in facility one. Avoid descriptive names that change when equipment is moved or repurposed.
GMAO platforms like Limble CMMS and UpKeep generate QR code labels directly from the asset record, which eliminates the manual step of linking printed labels to system records. Print from the system, not from a separate label template.
Step 3: Migrate Data from Excel Systematically
Every GMAO platform supports CSV or Excel import for asset data. Do not manually enter 300 assets one by one—you will make errors and the team will lose confidence in the data quality before the system is live.
Clean your spreadsheet data to match the import template before uploading. Remove duplicate entries. Standardize location names—if some records say 'Building A' and others say 'Bldg A' and others say 'Block A,' pick one format and apply it consistently. Blank fields are acceptable; inconsistent formats are not.
Import assets first, then PM templates, then historical work order data. Do not try to import everything simultaneously. Each import creates a dependency for the next one—assets must exist before you can assign PM schedules, and PM schedules must exist before historical completion records make sense.
Plan for two rounds of cleanup after each import. The first import will reveal data problems you could not see in the spreadsheet. Fix them in the source spreadsheet, then reimport. Build this cleanup time into your implementation schedule.
Step 4: Configure Preventive Maintenance Templates
PM templates are the operational core of your GMAO. Each template defines what gets done, who does it, how often, and what parts are needed. Getting templates right at the start saves significant rework later.
Start with manufacturer-recommended maintenance procedures for your Class A assets. These exist in the equipment manuals—extract them, translate them into numbered steps that a technician can follow on a mobile device, and assign estimated labor time. Overly long, ambiguous procedures do not get followed consistently.
Set initial PM intervals at manufacturer recommendations. You can optimize intervals after 12 months of data—extending intervals where inspections consistently find no defects, shortening them where inspections regularly find developing issues. Starting with manufacturer intervals is defensible if something goes wrong and gives you a baseline for optimization.
Configure parts lists on PM templates for any procedure that requires materials. When a technician opens a PM work order and the parts list is already there, they can check inventory before leaving the shop and order what is needed without a separate process.
Step 5: Train Technicians on the Mobile App First
GMAO adoption fails most often because technicians were trained on the web interface, which they rarely use, rather than on the mobile app, which is their primary tool.
Run mobile-first training sessions in groups of five to eight technicians. Give each person a phone with the app installed and walk through four workflows: scanning an asset QR code and viewing its history, opening and completing a work order, requesting a part, and logging a corrective maintenance event. Those four workflows cover 90% of what a field technician does daily.
Keep the first training session under 90 minutes. Technicians do not retain more than that in a single sitting, and making the system feel complicated on day one creates resistance that is hard to overcome. Run a follow-up session two weeks after go-live to address the questions that emerged from actual use.
Step 6: IoT Integration and the Path to Predictive Maintenance
After your GMAO is stable and your team is using it consistently—typically three to six months after go-live—you can start connecting sensor data to create condition-based maintenance triggers.
Start with vibration sensors on your highest-value rotating equipment. Vibration analysis is the most mature IoT maintenance technology and has the clearest ROI case. A vibration sensor that catches a developing bearing failure two weeks before it would cause catastrophic damage saves the repair cost plus production downtime—typically €5,000-50,000 per event depending on equipment and industry.
Platforms like Fiix and IBM Maximo have native IoT integration modules. UpKeep and Limble can connect to IoT data via API. The integration setup requires someone with basic API or automation knowledge, but does not require a dedicated IT project.
Measure your progress at the 90-day and 12-month marks: work order completion rate, PM compliance percentage, mean time to repair, and unplanned downtime hours. These four metrics tell you whether your GMAO implementation is delivering operational value or just adding administrative overhead.