UniqueID in PersonTable

#11 · 2026-08-13, 2:38 pm

Well done, Michael. A very efficient script. I ran it in SQLiteSpy on 1600 records in under 100ms.

Tom

#12 · 2026-08-15, 8:02 am

Thank you Tom, but I cannot take the credit. It was Gemini that figured out the UniqueID scheme for me and Claude that generated the validation script. I posted it here because @david-slatter had specifically asked about how to generate UniqueIDs in Python and this script answers that question.

My GEDCOM X RS server (discussed in another thread) is now using this information to generate UniqueIDs on demand (e.g. when loading individuals into a RootsMagic database via the API).