rene/transceiver-db
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
transceiver-db/sync/history/2026-05-09-fibermall-source-title-backfill.md
Rene Fichtmueller 6d8d7874d3 sync: record fibermall source backfill
2026-05-09 17:19:45 +02:00

1.2 KiB
Raw Permalink Blame History

FiberMall Source-Title Optical Detail Backfill - 2026-05-09

Context

FiberMall still had near-complete rows where price, image and source URL existed, but detail verification was blocked by missing normalized technical fields.

Precheck

  • 69 FiberMall rows had price + image + source URL but lacked detail verification
  • 69 had optical hints
  • 33 had deterministic reach evidence in product title or URL

DB Correction

  • Filled reach label/meters from explicit m/km evidence only
  • Filled fiber type from SMF/MMF/source-title evidence when missing
  • Filled wavelength from explicit nm or safe protocol-family evidence where present
  • Marked only source-backed rows with deterministic reach as details_verified

Result

  • 33 FiberMall rows detail-verified
  • 33 additional rows promoted to fully verified
  • Global details_verified=11595
  • Global fully_verified=10319

Health

  • TIP public health stayed healthy
  • Load status stayed ok
  • Memory used 13%

Truth Policy

Remaining FiberMall rows need stronger source parsing because many are OEM-compatible rows whose DB part number is only a brand name. Those rows must not be blindly marked complete without source-title/URL evidence for reach and core optical details.