Hi I am Tim Dunn and am working on a web app to help people research their family history. I am wondering how to merge records from the same table into one record based on if they are exact or partial matches in any given set of fields. for example:
Record 1: Name:John Smith source 1 for name: Minnesota Death Records listed as in source 1 for Name: John Smith listed column in source 1 for Name:Husband determined logic in source 1 for Name:Exact As Record Birthdate:1856 source 1 for birthdate:Minnesota Death Records listed as in source 1 for birthdate:1856 listed column in source 1 for birthdate:Birthdate determined logic in source 1 for birthdate: Exact As Record Birthplace:Minnesota,USA source 1 for birthplace:Minnesota Death Records listed as in source 1 for birthplace:Minnesota,USA listed column in source 1 for birthplace:Birthplace determined logic in source 1 for birthplace:Exact As Record FathersName:Bob Smith source 1 for fathersname:Minnesota Death Records listed as in source 1 for fathersname:Bob Smith listed column in source 1 for fathersname:fathers name determined logic in source 1 for fathersname:Exact As Record SpousesName:Sally Johnson source 1 for spousesname:Minnesota Death Records listed as in source 1 for spousesname:Sally Johnson listed column in source 1 for spousesname:Spouses Name determined logic in source 1 for spousesname:Exact As Record Deathdate:feb 4 source 1 for deathdate:Minnesota Death Records listed as in source 1 for deathdate:feb 4 listed column in source 1 for deathdate:Deathdate determined logic in source 1 for deathdate:Exact As Record Deathplace:Los Angeles,CA,USA source 1 for deathplace:Minnesota Death Records listed as in source 1 for deathplace:Los Angeles, CA, USA listed column in source 1 for deathplace:Deathplace determined logic in source 1 for deathplace:Exact As Record Record 2: Name:John Henry Smith source 1 for name: Smith Family Bible listed as in source 1 for Name:John Henry Smith listed column in source 1 for Name:Name determined logic in source 1 for Name:Exact As Record Birthdate:4 july 1856 source 1 for birthdate:Smith Family Bible listed as in source 1 for birthdate:4 july 1856 listed column in source 1 for birthdate:birthdate determined logic in source 1 for birthdate:Exact As Record Birthplace:USA source 1 for birthplace:Smith Family Bible listed as in source 1 for birthplace:USA listed column in source 1 for birthplace:birthplace determined logic in source 1 for birthplace:Exact As Record FathersName:Robert James Smith source 1 for fathersname:Smith Family Bible listed as in source 1 for fathersname:Robert James Smith listed column in source 1 for fathersname:FathersName determined logic in source 1 for fathersname:Exact As Record SpousesName:Sally Jean Johnson source 1 for spousesname:Smith Family Bible listed as in source 1 for spousesname:Sally Jean Johnson listed column in source 1 for spousesname:SpousesName determined logic in source 1 for spousesname:Exact As Record Deathdate:1930 source 1 for deathdate:Smith Family Bible listed as in source 1 for deathdate:1930 listed column in source 1 for deathdate:Deathdate determined logic in source 1 for deathdate:Exact As Record Deathplace:CA,USA source 1 for deathplace:Smith Family Bible listed as in source 1 for deathplace:CA, USA listed column in source 1 for deathplace:Deathplace determined logic in source 1 for deathplace:Exact As Record to become 1 record that says: Name:John Henry Smith source 1 for name: Minnesota Death Records listed as in source 1 for Name: John Smith listed column in source 1 for Name:Husband determined logic in source 1 for Name:Exact First Name and Exact Last Name as source 2 source 2 for name: Smith Family Bible listed as in source 2 for Name:John Henry Smith listed column in source 2 for Name:Name determined logic in source 2 for Name:Exact As Record Birthdate:4 july 1856 source 1 for birthdate:Minnesota Death Records listed as in source 1 for birthdate:1856 listed column in source 1 for birthdate:Birthdate determined logic in source 1 for birthdate: Exact Year as source 2 source 2 for birthdate:Smith Family Bible listed as in source 2 for birthdate:4 july 1856 listed column in source 2 for birthdate:birthdate determined logic in source 2 for birthdate:Exact As Record Birthplace:Minnesota,USA source 1 for birthplace:Minnesota Death Records listed as in source 1 for birthplace:Minnesota,USA listed column in source 1 for birthplace:Birthplace determined logic in source 1 for birthplace:Exact As Record source 2 for birthplace:Smith Family Bible listed as in source 2 for birthplace:USA listed column in source 2 for birthplace:birthplace determined logic in source 2 for birthplace:Exact country as source 1 FathersName:Robert James Smith source 1 for fathersname:Minnesota Death Records listed as in source 1 for fathersname:Bob Smith listed column in source 1 for fathersname:fathers name determined logic in source 1 for fathersname:First Name is Nick Name and Last Name Exact as source 2 source 2 for fathersname:Smith Family Bible listed as in source 2 for fathersname:Robert James Smith listed column in source 2 for fathersname:FathersName determined logic in source 2 for fathersname:Exact As Record SpousesName:Sally Jean Johnson source 1 for spousesname:Minnesota Death Records listed as in source 1 for spousesname:Sally Johnson listed column in source 1 for spousesname:Spouses Name determined logic in source 1 for spousesname:Exact First Name and Last Name as source 2 source 2 for spousesname:Smith Family Bible listed as in source 2 for spousesname:Sally Jean Johnson listed column in source 2 for spousesname:SpousesName determined logic in source 2 for spousesname:Exact As Record Deathdate:feb 4 1930 source 1 for deathdate:Minnesota Death Records listed as in source 1 for deathdate:feb 4 listed column in source 1 for deathdate:Deathdate determined logic in source 1 for deathdate:Possible same year as source 2 source 2 for deathdate:Smith Family Bible listed as in source 2 for deathdate:1930 listed column in source 2 for deathdate:Deathdate determined logic in source 2 for deathdate:Possible same month and day as source 1 Deathplace:Los Angeles, CA, USA source 1 for deathplace:Minnesota Death Records listed as in source 1 for deathplace:Los Angeles, CA, USA listed column in source 1 for deathplace:Deathplace determined logic in source 1 for deathplace:Exact As Record source 2 for deathplace:Smith Family Bible listed as in source 2 for deathplace:CA, USA listed column in source 2 for deathplace:Deathplace determined logic in source 2 for deathplace:Exact State and Country as source 1 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
