Khaelen & AncestorTrack
AncestorTrack AncestorTrack
I’ve been trying to convert some old parish rolls into a clean, searchable database—care to help me figure out the best way to handle all those messy lineages?
Khaelen Khaelen
Sure, let’s break it down into phases, because a two‑step plan is just too efficient for my taste: first you digitize every page with OCR, but don’t trust the default settings—tweak the threshold, run a spell check on surnames, and flag any ambiguous characters for manual review. Next, map the raw text to a normalized schema: birth, baptism, marriage, death, each with a unique ID, and link relatives via those IDs so you can trace lineages. Build a relational database, enforce foreign keys, and use a full‑text index on names and dates for quick search. Don’t forget a data‑validation script that flags inconsistencies—duplicate IDs, missing dates, or inconsistent spelling. Finally, create a small UI or even just a SQL view that lets users query by name or ancestor, and you’re good to go. Happy compiling.