Recent Changes

Wednesday, September 20

  1. msg unifuzz run time loadable extension for OS's other than Windows message posted unifuzz run time loadable extension for OS's other than Windows I installed SQLite Expert Personal (5.2 (x64). I opened my RootsMagic database. I entered the f…
    unifuzz run time loadable extension for OS's other than Windows
    I installed SQLite Expert Personal (5.2 (x64).
    I opened my RootsMagic database.
    I entered the following in the SQL window:
    select surname
    from nametable;
    I got no such collation sequence: RMNOCASE

    I did a right click on my database
    I selected Load Extension
    I selected the the File Name (C:\Program Files\SQLite Expert\Personal 5\unifuzz.dll)
    I entered sqlite_extension_init for the Entry Point
    I left auto unchecked
    I clicked OK
    I got a popup of The specified module could not be found
    3:14 pm

Tuesday, September 19

  1. msg Add Married Name as Alternate message posted Add Married Name as Alternate I finally got the documentation done. One word document (Alternate name typos script explanation) …
    Add Married Name as Alternate
    I finally got the documentation done. One word document (Alternate name typos script explanation) explains the script and the reasoning behind the script. The second word document (Alternate Name Typo Steps) explains and shows the steps I used to find the typos. This is the script:
    -- Alternate name typos

    Select f.FamilyID,
    -- 1 -- Column B Gets the surname, given name and fathered for the fatherid from the famillytable for the fathers primary record. This is the husband.
    (select n1.surname || ", " || n1.given || " " || f.FatherID
    from nametable n1
    where f.fatherid = n1.ownerid -- Get the father info from the primary record
    and n1.isprimary = 1) as Husband,
    -- 2 -- Column C Gets the surname, given name and mothered from the familytable for the motherid from the mothers primary record. This is the Wife.
    (select n2.surname || ", " || n2.given || " " || f.MotherID
    from nametable n2
    where f.motherid = n2.ownerid -- Get the mother info from the primary record
    and n2.isprimary = 1) as Wife,

    -- 3 -- Column D -- Gets the wife’s given name, maiden name, married name, husband’s given name and MothersID from the wife’s alternate name record. This is the Alternate Name.
    (select n3.given || " " || n5.surname || " " || n5.suffix || " " || f.MotherID
    from nametable as n3

    inner join -- get the father's record from nametable file for the primary record
    nametable as n4
    on f.fatherid = n4.ownerid
    and n4.isprimary = 1

    inner join -- get the surname and suffix from the nametable for the father's primary record
    nametable as n5
    on "(" || n4.given || ")" = n5.suffix

    where f.motherid = n3.ownerid -- get the mother's information from the alternate record
    and n3.isprimary = 0) as Alternate,

    -- 4 -- Column E -- Gets the wife’ given name from the wife’s alternate record. This is the Alternate Maiden Name.
    (select n6.given
    from nametable n6

    inner join -- get the father's record from nametable file for the primary record
    nametable as n7
    on f.fatherid = n7.ownerid
    and n7.isprimary = 1

    where f.motherid = n6.ownerid -- get the mother's information for the alternate record and the husbands Surname
    and n6.isprimary = 0
    and n7.surname = n6.surname) as Alt_Maiden_Name,

    -- 5 -- Column F -- Gets the wife’s given name and surname from the wife’s primary record. This is the Primary Maiden Name.
    (Select n9.given || " " || n9.surname
    from nametable as n9
    where f.motherid = n9.ownerid
    and n9.isprimary = 1) as Pri_Maiden_Name,

    -- 6 -- Column G -- Gets the suffix for the wife from the alternate name record. This is the Alternate Suffix.
    (select n12.suffix
    from nametable as n10

    inner join -- get the father's record from nametable file for the primary record
    nametable as n11
    on f.fatherid = n11.ownerid
    and n11.isprimary = 1

    inner join -- get the suffix from the nametable for the father's primary record
    nametable as n12
    on n10.given || " " || n11.surname = n12.given || " " || n12.surname
    and "(" || n11.given || ")" = n12.suffix

    where f.motherid = n10.ownerid
    and n10.isprimary = 0) as Alt_Suffix,

    -- 7 -- Column H -- Puts parenthesis around the husbands given name from the primary records. This is the Primary Siffix.
    (select "(" || n13.given || ")"
    from nametable as n13

    where f.fatherid = n13.ownerid
    and n13.isprimary = 1) as Pri_Suffix,

    -- 8 -- Column I -- Gets the wife’s surname from the alternate record. This is the Alternate Surname.
    (select n18.surname
    from nametable as n16

    inner join -- gets the father's record from nametable file
    nametable as n17
    on (f.fatherid = n17.ownerid)

    inner join -- gets the father's record from the nametable with the the suffix
    nametable as n18
    on "(" || n17.given || ")" = n18.suffix
    and f.MotherID = n18.ownerid
    and n17.surname = n18.surname

    where f.motherid = n16.ownerid
    and n16.isprimary = 0) as Alt_Surname,

    -- 9 -- Column J -- Gets the husband’s surname form the husband’s primary record. This is the husband’s surname.
    from nametable as n19
    where f.fatherid = n19.ownerid
    and n19.isprimary = 1) as Primary_Surname

    from familytable f

    where f.FatherID is not 0 -- fatherid is not 0
    and f.MotherID is not 0 -- motherid is not 0
    --and substr(wife, 1, 1) <> "," -- the first position of the wife was not a comma
    --and $Enterfamilyid = f.familyid -- Inputs the familyid
    --and familyid in(66, 1617)

    order by husband, wife
    ;

    How do I attach or upload the two word document?
    8:11 pm

Sunday, September 17

  1. msg Add Married Name as Alternate message posted Add Married Name as Alternate Congrats! But that is a difficult script to understand. Jerry Bryan has posted in this wiki an exam…
    Add Married Name as Alternate
    Congrats! But that is a difficult script to understand. Jerry Bryan has posted in this wiki an example of building up a complex query by building it up from a sequence or combination of simpler queries saved as SQLite Views.

    I'm dubious that your script will show you typo mismatches between the Alt Name and the correct Husband's surname. Is that not what you are after? Perhaps you could revise the page to show your current results with a test database involving more than one married woman with multiple husbands and at least one mismatch.

    Tom
    7:48 am

Saturday, September 16

  1. msg Add Married Name as Alternate message posted Add Married Name as Alternate Would you believe I found a way to make it work!!! I had to do something like this 10 years ago an…
    Add Married Name as Alternate
    Would you believe I found a way to make it work!!! I had to do something like this 10 years ago and I found the query after a lot of searching. Here is the solution:

    -- Marriage list 2

    Select f.FamilyID,

    (select n1.surname || ", " || n1.given || " " || f.FatherID from nametable n1 where f.fatherid = n1.ownerid and n1.isprimary = 1) as Husband,

    (select n2.surname || ", " || n2.given || " " || f.MotherID from nametable n2 where f.motherid = n2.ownerid and n2.isprimary = 1) as Wife,

    (select n3.given || " " || n3.surname || " " || n6.suffix || " " || f.MotherID from nametable as n3

    inner join
    nametable as n5
    on (f.fatherid = n5.ownerid)

    inner join
    nametable as n6
    on "(" || n5.given || ")" = n6.suffix

    where f.motherid = n3.ownerid and n3.isprimary = 0) as Alternate,


    (select n4.given || " " || n4.surname from nametable n4 where f.motherid = n4.ownerid and n4.isprimary = 1) as Name

    from familytable f

    order by husband, wife
    ;
    9:00 pm
  2. msg Add Married Name as Alternate message posted Add Married Name as Alternate Sorry to be slow responding. I don't have a solution for you at the moment but I can say that the r…
    Add Married Name as Alternate
    Sorry to be slow responding. I don't have a solution for you at the moment but I can say that the reason your script does not work is because the two sub-queries for Alternate Names are always answered by the first Alt Name record for the person. They also do not filter on the type of Alt Name and cannot distinguish an alternate spelling of the maiden-type name from a married-type name. I'm unsure that there is a good solution because there is nothing in the database relating an Alt Name to a specific husband when there is more than one, other than a match on the surname. If there is a spelling difference, there is no match. So it is possible to identify those wives who have been assigned an Alt Name of type "married" that matches their husband's surname. It is also possible to identify those wives who have no Alt Name of type "married". I guess those wives left over that have an Alt Name of type "married" that is not matched with any of their husbands would be the ones with typographic differences that you are interested in finding.
    8:45 pm

Friday, September 15

  1. msg Add Married Name as Alternate message posted Add Married Name as Alternate Select f.FamilyID, (select n1.surname || ", " || n1.given || " " || f.Fathe…
    Add Married Name as Alternate
    Select f.FamilyID,

    (select n1.surname || ", " || n1.given || " " || f.FatherID from nametable n1 where f.fatherid = n1.ownerid and n1.isprimary = 1) as Husband,
    (select n2.surname || ", " || n2.given || " " || f.MotherID from nametable n2 where f.motherid = n2.ownerid and n2.isprimary = 1) as Wife,
    (select n3.given || " " || n3.surname || " " || n3.suffix || " " || f.MotherID from nametable n3 where f.motherid = n3.ownerid and n3.isprimary = 0) as Alternate,
    (select n4.given || " " || n4.surname from nametable n4 where f.motherid = n4.ownerid and n4.isprimary = 1) as Name

    from familytable f

    order by husband, wife
    ;
    9:41 am
  2. msg Add Married Name as Alternate message posted Add Married Name as Alternate (deleted)
    9:22 am
  3. msg Add Married Name as Alternate message posted Add Married Name as Alternate Okay, I understand that you have already manually created these Alternate Names and are looking for…
    Add Married Name as Alternate
    Okay, I understand that you have already manually created these Alternate Names and are looking for a way to detect errors. Is that your objective?

    If we are to tinker wit your script, it would be helpful if you would post the script file or copy the script onto the page.
    9:22 am
  4. msg Add Married Name as Alternate message posted Add Married Name as Alternate Are you acquainted with this script? http://sqlitetoolsforrootsmagic.wikispaces.com/Names+-+Add+M…
    Add Married Name as Alternate
    Are you acquainted with this script? http://sqlitetoolsforrootsmagic.wikispaces.com/Names+-+Add+Married
    9:15 am
  5. page Alternate Names List edited ... I copy all of the results of the query into a spreadsheet to verify there aren’t any typos in …
    ...
    I copy all of the results of the query into a spreadsheet to verify there aren’t any typos in the alternate name. (See Pic 6)
    Is it possible to create the query to get the results contained in the spreadsheet? (Column O and Column P)
    How could I put a where statement in thee query to select only certain ownerid's? I need to be able to hard code it and to be able to input the ownerid.
    (view changes)
    8:32 am

More