README.md

metadata

title: Turbo Air Equipment Viewer
emoji: ❄️
colorFrom: green
colorTo: blue
sdk: docker
pinned: false
license: apache-2.0

Turbo Air Equipment Viewer

Professional equipment specification database viewer for Turbo Air products.

Features

• 🔍 Smart Search: Type model numbers to instantly find equipment
• 📋 Detailed Specs: View comprehensive technical specifications
• 📄 PDF Viewer: Access original specification sheets
• 📌 Bookmarking: Create custom equipment lists
• 📊 Export Options: Download data as CSV or PDF reports
• 🖼️ Product Images: Visual previews extracted from PDFs
• 🔗 Price Search: Quick Google search for current pricing

File Structure

/
├── turbo_air_viewer.py    # Main Streamlit application
├── turbo_air_db_online.sqlite    # Equipment database
├── requirements.txt       # Python dependencies
├── Dockerfile            # Docker configuration
├── README.md            # This file
├── .gitattributes       # Git LFS configuration
└── pdfs/                # PDF specification sheets
    ├── TSR-23SD.pdf
    ├── TSF-49SD.pdf
    └── ...

Database Schema

The SQLite database contains equipment specifications with the following key fields:

• Model numbers and variations
• Dimensions (inches and millimeters)
• Electrical specifications (voltage, amperage, phase)
• Refrigeration details
• Capacity
• Refrigerant type
• Compressor specifications

Usage

1. Search for Models: Use the dropdown to select or type a model number
2. View Specifications: See detailed technical specs and features
3. Access PDFs: Click "View PDF" to see the original specification sheet
4. Bookmark Models: Save models to your selection list
5. Export Data: Download your selections as CSV or PDF reports

Technical Stack

• Frontend: Streamlit with custom dark theme
• Database: SQLite for fast local queries
• PDF Processing: PyMuPDF for document handling
• Reporting: ReportLab for PDF generation
• Image Processing: Pillow for thumbnail extraction

Notes

• All PDFs should be placed in the pdfs/ directory
• The database file turbo_air_db_online.sqlite must be in the root directory
• Product images are extracted from PDFs on-demand and cached

License

Apache 2.0 License