v1.0.0

Location Validator v1.0.0

🎉 Initial Release

This is the first official release of the Location Validator tool, designed to automate and validate Master Data - Location before importing into CMMS.

🚀 Features

• Graphical User Interface (GUI):
  • Modern, minimalist design using customtkinter.
  • Dynamic input fields for Sheet Name, Input File, and Database Code.
  • Real-time logging display with step-by-step progress.
  • Settings persistence (remembers last used file paths).
• Core Validation Logic:
  • Validates Location formats.
  • Checks System, EQ, and Component codes against a reference database.
  • Validates Cost Center and Hierarchy logic.
  • Generates detailed Excel reports with color-coded error highlighting.
• Standalone Executable:
  • Includes a pre-built .exe for easy distribution (no Python installation required).
  • Custom application icon.

📦 Installation

1. Download LocationValidator.exe from the Assets section below.
2. Run the executable directly.

🛠 Dependencies

• Python 3.12+
• pandas
• numpy
• openpyxl
• customtkinter