SCADA vs DWG Manifest Comparison Tool

A Flask web application to compare and reconcile mechanical manifest data (chutes and conveyors) against extracted device data from DWG files and SCADA object metadata.

Features

Upload Excel files containing manifest and DWG data
Specify a GitHub repository URL containing SCADA JSON files
Compare names across all three data sources
Normalize names for consistent comparison (uppercase, strip whitespace)
View discrepancies in a user-friendly tabbed interface
Re-upload updated files for comparison against the same repository
Persistent storage of repository clones

Installation

Clone this repository:

git clone <repository-url>
cd <repository-directory>

Install the required dependencies:
```
pip install -r requirements.txt
```

Usage

Start the Flask application:
```
flask run
```
Open your web browser and navigate to http://127.0.0.1:5000/
On the homepage:
- Enter the GitHub repository URL containing SCADA JSON files
- Upload your Excel file containing the manifest data (must include a "Name" column)
- Upload your Excel file containing the DWG data (must include a "Name" column)
- Click "Compare" to proceed
View the comparison results in the tabbed interface:
- SCADA vs DWG: Compare SCADA names with DWG names
- DWG vs Manifest: Compare DWG names with manifest names
- SCADA vs Manifest: Compare SCADA names with manifest names
To update files for re-comparison:
- Use the form at the bottom of the results page
- Upload new versions of the manifest and/or DWG files
- The application will automatically pull the latest changes from the repository

Data Normalization

All names from the three sources are normalized for consistent comparison:

Leading and trailing whitespace is removed
All text is converted to uppercase
Duplicate names are removed from each source

Directory Structure

project/
├─ app.py                 # Main Flask application
├─ requirements.txt       # Python dependencies
├─ README.md              # This documentation
├─ clones/                # Repository clones storage
├─ templates/             # HTML templates
│  ├─ base.html           # Base template with common layout
│  ├─ index.html          # Homepage with upload form
│  └─ results.html        # Results page with comparison tabs
└─ static/                # Static assets
   ├─ css/                # CSS stylesheets
   └─ js/                 # JavaScript files

2.5 KiB Raw Permalink Blame History