shawn
99cef94153
- Scanned all 15 photos in uploads/photos/ via vision + Tesseract OCR - Matched keurig_label.jpg → Asset #5144 (machine_id 636671) - Updated Asset #5144 photo_path in assets.db - Created scripts/crossref_photos.py for reusable batch matching - Reported unmatched IDs for coca_cola_label.jpg and telemetry_device.jpg - Generated crossref_report.md with full findings
40 lines
1.4 KiB
Markdown
40 lines
1.4 KiB
Markdown
# Photo Cross-Reference Report
|
|
**Generated:** 2026-05-29
|
|
|
|
## Database
|
|
- assets.db: 7,488 assets
|
|
|
|
## Photos Scanned
|
|
15 files in uploads/photos/
|
|
|
|
## Results
|
|
|
|
### Matched (1 photo → 1 asset update)
|
|
|
|
| Photo | Asset ID | Machine ID | Name | Action |
|
|
|-------|----------|------------|------|--------|
|
|
| keurig_label.jpg | 5144 | 636671 | 636671 / 956 Cypress Way | ✅ photo_path set to /uploads/photos/keurig_label.jpg |
|
|
|
|
### Unmatched — For Investigation (2 photos)
|
|
|
|
**coca_cola_label.jpg** — Coca-Cola branded label
|
|
- Extracted IDs: RY10006338, RVCC-660-8, 201037BA00039
|
|
- RY10006338 is Royal-pattern serial but not in DB
|
|
- 201037BA00039 is Royal serial format; closest DB match: Asset #6815 (A201037BA00030)
|
|
- Likely a pulled/retired or unregistered machine
|
|
|
|
**telemetry_device.jpg** — 4G telemetry device
|
|
- Extracted IDs: 4434331624226353 (ICCID), 48602143 (Monyx ID)
|
|
- These are telemetry/sim identifiers, not vending machine assets
|
|
- Consider tracking in a separate telemetry devices table
|
|
|
|
### Test Data (3 photos)
|
|
- 557ba8d1..., 59dd8174..., a8c7e553...: "Machine 1D 12845-678901" — app test pattern, no DB match
|
|
|
|
### No Text (9 photos)
|
|
- Icon-sized images (100x100 to 200x100): no readable text
|
|
|
|
## Files Changed
|
|
- `/home/oplabs/projects/canteen-asset-tracker/assets.db` — Asset #5144 photo_path updated
|
|
- `/home/oplabs/projects/canteen-asset-tracker/scripts/crossref_photos.py` — reusable batch matching script
|