SiteTrack O&M Management System

SiteTrack is a comprehensive MATLAB-based application designed to manage operations and maintenance (O&M) activities. It includes dedicated modules for warehouse inventory, road maintenance, and electrical infrastructure management. With an intuitive interface, SiteTrack simplifies work order tracking, materials management, and report generation.

---

Key Features

• Manage roads, buildings, and electrical networks in one platform
• Track inventory of materials and equipment
• Log detailed work orders and maintenance activities
• Monitor lighting, networks, and panel maintenance
• Plot inventory trends and maintenance activity
• Review records by day, week, or month
• Export data to Word and Excel
• Secure login for multi-user access
• Attach before/after images for maintenance records

---

📁 Project Structure

SiteTrack/
├── SiteTrack.m                # Main application launcher
├── assets/
│   ├── data/                  # Configs and templates
│   │   ├── headingsRoads.txt
│   │   ├── maintenanceType.txt
│   │   ├── roadsTables.mat
│   │   └── warehouse.xlsx
│   ├── databases/             # SQLite database files
│   ├── icons/                 # UI icons
│   ├── pictures/              # Work documentation photos
│   └── templates/             # Report templates
└── utilities/
    ├── createDB.m             # Script to initialize database
    └── SplashScreen.m         # App splash screen component

---

Getting Started

Prerequisites

• MATLAB R2021b or later
• SQLite database generated with createDB.m

Setup Instructions

1. Configure Data Files

   • Customize field names and types in assets/data/
   • Update warehouse.xlsx and warehouseElec.xlsx with your materials inventory

2. Create Database

   • Run createDB.m from the utilities/ folder
   • Move the generated dbOandM.db to assets/databases/

3. Launch Application

   • Open MATLAB
   • Run SiteTrack.m

---

Usage Overview

Login Screen

• Enter employee ID and password (default: 0000, 0000)
• Access levels vary by user type

Main Menu

• Navigate to Roads, Buildings, or Electrical modules
• Access warehouse and reporting functions

Work Orders

1. Choose module (e.g., Roads or Electrical)
2. Input:
   • Work description
   • Location
   • Materials and equipment used
   • Attach images (before/after)

Warehouse Management

• View/edit inventory
• Filter by category
• Track material usage
• Generate reports

Data Review

• Filter by date (daily/weekly/monthly)
• Search entries
• Export filtered data to reports

Reports

• Generate reports in Word and Excel
• Create summaries or inventory status reports

---

Module Details

Roads Maintenance

• Log concrete, asphalt, and interlock works
• Track infrastructure repairs, fencing, painting

Electrical Maintenance

• Record lighting and panel maintenance
• Log line hazards, lantern installs, and materials

Warehouse System

• Track multiple material categories
• Monitor stock levels and historical usage
• Set low-stock alerts

---

Developer Notes

Database

• Uses SQLite with schema defined in createDB.m
• Extensible for future features

Customization

• Update assets/data/ text files for labels and types
• Modify roadsTables.mat, elecTables.mat for structure
• Add icons to assets/icons/

Extensibility

• Add new modules by expanding SiteTrack.m
• Include additional templates in assets/templates/

---

License

This project is licensed under the MIT License.

---

Contact

For bug reports, feature requests, or collaboration:

• GitHub Issues: FEAnalysisApp Issues
• Email: a.k.y.dorgham@gmail.com
• Connect: LinkedIn | GoogleScholar | ResearchGate | ORCiD