File size: 2,375 Bytes
119fd31
4e9de34
 
2b7f9dc
 
 
119fd31
4e9de34
119fd31
 
2b7f9dc
119fd31
2b7f9dc
119fd31
4e9de34
 
2b7f9dc
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
---
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