1

Seed Data Import

Shawn edited this page 2026-05-28 23:28:14 -04:00

Table of Contents

• Seed (mycantaloupe.com) Data Import
• Overview
• Match
• Schema Changes
• API
• Frontend
• Usage
• Notes

Seed Import

Seed (mycantaloupe.com) Data Import

Overview

Imported Machine List(8).xlsx (1,854 rows, 62 columns) from Seed/Cantaloupe into the Canteen Asset Tracker.

Match

• Key: Seed Asset ID ↔ DB machine_id
• Matched: 1,655 assets (89.3%)
• Unmatched: 199 — in Seed but not in MSFS data

Schema Changes

• 51 new columns on assets table (route, subroute, barcode, sales data, contact info, alerts, etc.)
• seed_data table — one row per matched asset with full 62-field JSON blob

API

• GET /api/assets/{id} → result.seed (object) + result.seed_imported_at
• Key columns exposed directly on asset rows

Frontend

• Asset detail view shows 🌱 Cantaloupe/Seed Data card

Usage

python3 import_seed.py

Notes

• GPS data from Seed was NOT imported (address-derived, not real coordinates)
• 51 DB columns from key Seed fields + full JSON dump in seed_data table