--- 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