Technical notes on web development, DevOps, and AI integration.
1 article
22 heritage records, one swapped column pair, and six drafts: what an honest data import looks like.
TL;DR: While importing a heritage site spreadsheet, the author found latitude and longitude columns swapped, plus typo'd prefixes, duplicate coordinates, and one missing record. The fixed importer parses with column swap, preserves raw DMS strings, and routes suspect rows to draft with a geo_review flag instead of publishing. Result: 16 records published, 6 drafted, and reruns are fully idempotent.