shawn/canteen-asset-tracker
1
0
Fork 0
Code Issues 8 Pull Requests Actions Packages Projects Releases Wiki Activity

Import Seed (mycantaloupe.com) data — 50+ new fields + detail enrichment #47

New Issue
Closed
opened 2026-05-29 03:28:03 +00:00 by shawn · 0 comments
shawn commented 2026-05-29 03:28:03 +00:00
Owner
Copy Link
Copy Source

Summary

Imported the Machine List(8).xlsx export from Seed (Cantaloupe) into the canteen asset tracker, enriching 1,655 assets with 50+ new fields. GPS columns were ignored per request.

Match Logic

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

Schema Changes

  • 51 new columns added to assets table (device, route, class, customer, branch, barcode, sales data, contact info, alerts, etc.)
  • seed_data table created — one row per matched asset with full 62-field JSON blob

What's New in the App

  • Asset detail view now shows a 🌱 Cantaloupe/Seed Data card with all imported fields
  • Data like Route/Subroute, Daily/Monthly/Yearly Sales, Cashless flags, Alerts, Customer contact info, and more
  • Full Seed JSON available via /api/assets/{id} → result.seed

API Changes

  • GET /api/assets/{id} now includes seed (object) and seed_imported_at when available
  • New columns exposed directly in asset rows

Closes: #46 (part of clean-slate + enrichment effort)

## Summary Imported the `Machine List(8).xlsx` export from Seed (Cantaloupe) into the canteen asset tracker, enriching 1,655 assets with 50+ new fields. GPS columns were ignored per request. ### Match Logic - **Key:** Seed `Asset ID` ↔ DB `machine_id` - **Rows in Excel:** 1,854 - **Matched:** 1,655 (89.3%) - **Unmatched:** 199 — assets in Seed but not in our MSFS import ### Schema Changes - **51 new columns** added to `assets` table (device, route, class, customer, branch, barcode, sales data, contact info, alerts, etc.) - **`seed_data` table** created — one row per matched asset with full 62-field JSON blob ### What's New in the App - Asset detail view now shows a 🌱 Cantaloupe/Seed Data card with all imported fields - Data like Route/Subroute, Daily/Monthly/Yearly Sales, Cashless flags, Alerts, Customer contact info, and more - Full Seed JSON available via `/api/assets/{id}` → `result.seed` ### API Changes - `GET /api/assets/{id}` now includes `seed` (object) and `seed_imported_at` when available - New columns exposed directly in asset rows Closes: #46 (part of clean-slate + enrichment effort)
shawn closed this issue 2026-05-29 03:28:03 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
blocked
Kanban task is blocked
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
shawn
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: shawn/canteen-asset-tracker#47
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?