Fix: Recategorize 5 assets using MSFS/Dynamics 365 manufacturer data, revert 6 National BEV-MAX #60

Open
opened 2026-05-31 05:30:26 +00:00 by shawn · 0 comments
Owner

What: Cross-referenced our DB against the merged-assets.json from Dynamics 365 Field Service to find real manufacturer info for Unknown/Other assets.

Fixed:

→ Bev (3):

  • 95368 (id=9694) — VENDO 621 soda machine, was Unknown/Other
  • 95391 (id=9695) — VENDO 721 soda machine, was Unknown/Other
  • 98099 (id=9701) — DIXIE NARCO 5800 SERIES beverage, was Unknown/Other

→ Equipment (2):

  • 98112 (id=9702) — NATIONAL 3008 CHANGER (bill changer), was Unknown/Other
  • 84356 (id=1564) — UNKNOWN BILL CHANGER MISC, was UNKNOWN/Other

Reverted (6):
National EPROM (ids 859,875,1005,1014,1017,1122) — were incorrectly moved from Bev→Snack. MSFS shows model BEV-MAX MEDIA WIDE and original seed data had canteen_cat=Bev. These are beverage machines. Reverted to Bev.

Still in Other (9): Generic Fixtures (Other make, no manufacturer data) at Canteen Corp, Epcot, JELD-WEN, plus 1 UNKNOWN CAN BEV MISC.

Source: /home/oplabs/projects/ms-field-service-extraction/web/static/data/merged-assets.json (10K records from D365)

**What:** Cross-referenced our DB against the merged-assets.json from Dynamics 365 Field Service to find real manufacturer info for Unknown/Other assets. **Fixed:** **→ Bev (3):** - 95368 (id=9694) — VENDO 621 soda machine, was Unknown/Other - 95391 (id=9695) — VENDO 721 soda machine, was Unknown/Other - 98099 (id=9701) — DIXIE NARCO 5800 SERIES beverage, was Unknown/Other **→ Equipment (2):** - 98112 (id=9702) — NATIONAL 3008 CHANGER (bill changer), was Unknown/Other - 84356 (id=1564) — UNKNOWN BILL CHANGER MISC, was UNKNOWN/Other **Reverted (6):** National EPROM (ids 859,875,1005,1014,1017,1122) — were incorrectly moved from Bev→Snack. MSFS shows model BEV-MAX MEDIA WIDE and original seed data had canteen_cat=Bev. These are beverage machines. Reverted to Bev. **Still in Other (9):** Generic Fixtures (Other make, no manufacturer data) at Canteen Corp, Epcot, JELD-WEN, plus 1 UNKNOWN CAN BEV MISC. **Source:** /home/oplabs/projects/ms-field-service-extraction/web/static/data/merged-assets.json (10K records from D365)
shawn self-assigned this 2026-05-31 05:30:26 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: shawn/canteen-asset-tracker#60