... Try these in "View Legacy Tables"... Find AKAs same as Individual Name: SELECT tblIR.IDIR, tblIR.Prefix, tblIR.GivenName, tblIR.Surname, tblIR.Title,...
456
Ron Taylor
doit4ron
Dec 12, 2011 3:01 pm
I'll try these scripts this evening when I get home. What does the check for Order<>0 do? Are you saying that there are Order=0 records in the table that...
457
Dennis Kowallek
kowallekfamily
Dec 12, 2011 3:09 pm
On Mon, 12 Dec 2011 07:01:55 -0800 (PST), Ron Taylor ... When you add an individual in Legacy (tblIR), it also adds a row in tblNX (AKAs) with Order=0 behind...
458
Dennis Kowallek
kowallekfamily
Dec 12, 2011 3:10 pm
On Mon, 12 Dec 2011 07:01:55 -0800 (PST), Ron Taylor ... You have to look in tblSX. See http://zippersoftware.com/wp/ltools/legacys-database/tblsx-type/. -- ...
459
Dennis Kowallek
kowallekfamily
Dec 12, 2011 3:16 pm
... Try these in "View Legacy Tables": Find Potential Duplicate Individual Events SELECT DISTINCT tblER.IDIR AS RIN, tblER.IDType, tblET.EventType, ...
460
Ron Taylor
doit4ron
Dec 12, 2011 3:17 pm
Good to know about Order=0 AKA records. I will look at them. I wonder if the regular name fields are populated into this Order=0 AKA record. Thanks...
461
Dennis Kowallek
kowallekfamily
Dec 12, 2011 3:20 pm
On Mon, 12 Dec 2011 07:17:27 -0800 (PST), Ron Taylor ... Yes it does. I didn't explicitly state this. -- Dennis Kowallek (LTools/Custom Programming) ...
462
Richard Van Wasshnova
vanwasshnova
Dec 12, 2011 6:22 pm
Thanks for the 2 new select queries. Found 4 dupe Individual events - 2 were just different sources which I combined to one event. Two of the dupes had same...
463
doit4ron
Dec 29, 2011 3:34 pm
Dennis, I am anxious to use this new tool. This morning, I tried it on a copy of my database after setting Tag1 for a few people that I know are in SSDI and...
464
Dennis Kowallek
kowallekfamily
Dec 29, 2011 3:43 pm
On Thu, 29 Dec 2011 15:34:48 -0000, "doit4ron"; <doit4ron@...> ... First question ... did you read the Help? -- Dennis Kowallek (LTools/Custom...
465
tim0cd
Dec 29, 2011 3:52 pm
I have 104 indiviuals tagged with Legacy. When I select to fetch Tag 1, I just get 1 individual. *shrug* Tim...
466
Dennis Kowallek
kowallekfamily
Dec 29, 2011 3:57 pm
On Thu, 29 Dec 2011 15:52:57 -0000, "tim0cd" <Sparky@...> ... That's because only 1 individual met the SELECT criteria. Look at the Help and/or the...
467
Dennis Kowallek
kowallekfamily
Dec 29, 2011 4:26 pm
Anyone who still thinks that there is a problem with "Advanced SSDI Retrieval", AFTER READING THE HELP FILE, should send me (privately) a .fdb with the minimal...
468
Wm Voss
bellafortuni
Dec 29, 2011 4:35 pm
Ran on a number of created test files; no issues, worked a treat. In real life, I have two instances where the SSDI is known to be incorrect. Would it be...
469
Dennis Kowallek
kowallekfamily
Dec 29, 2011 4:40 pm
On Thu, 29 Dec 2011 15:34:48 -0000, "doit4ron"; <doit4ron@...> ... I thought about doing something like this but I could not come up with an elegant way...
470
Dennis Kowallek
kowallekfamily
Dec 29, 2011 4:43 pm
On Thu, 29 Dec 2011 08:35:59 -0800, Wm Voss <bellafortuni@...> ... You want to leave the death date blank? If the death date is populated, this LTool...
471
Tim Rosenlof
tim0cd
Dec 29, 2011 6:49 pm
Thanks. I should have researched it before opening my mouth. Tim Rosenlof...
472
Dennis Kowallek
kowallekfamily
Dec 31, 2011 1:35 pm
Someone mentioned that their routine also involved creating a "Social Security Number" event. Here is a way to do that. 1) Make a backup of your database and...
473
Richard Van Wasshnova
vanwasshnova
Dec 31, 2011 8:41 pm
I used this tool 2 days ago and updated 86 people. Was very happy with results. I already have a "Social Security Number" event so wanted to add the event...
474
Dennis Kowallek
kowallekfamily
Dec 31, 2011 8:51 pm
On Sat, 31 Dec 2011 12:41:44 -0800, Richard Van Wasshnova ... Because it counts both the event rcds and the citation rcds. I am somewhat inconsistent in what I...
475
tim0cd
Dec 31, 2011 9:24 pm
I am lazy... Dennis, Thanks for all the different tools. I don't know if it is on your todo list, but I would like to be able to capture all the data ie... o...
476
Richard Van Wasshnova
vanwasshnova
Dec 31, 2011 9:24 pm
Sourced birth and death for 2 people below. Then added event for both but they both got Source Citation for Alfred. Clicking <<< filled in 38708 I believe I...
477
Dennis Kowallek
kowallekfamily
Dec 31, 2011 9:28 pm
On Sat, 31 Dec 2011 13:24:38 -0800, Richard Van Wasshnova ... Ooops. I didn't consider that the citation was specific to an individual. I guess my method won't...
478
tim0cd
Dec 31, 2011 9:32 pm
Can't upload. I hope you will get the idea....
479
Dennis Kowallek
kowallekfamily
Dec 31, 2011 9:35 pm
On Sat, 31 Dec 2011 21:24:12 -0000, "tim0cd" <Sparky@...> ... I can add a substitution for {StateIssued} in the next release. ... Since there can be...
480
Richard Van Wasshnova
vanwasshnova
Dec 31, 2011 9:43 pm
OK, Citation can be copied from death event. ... [Non-text portions of this message have been removed]...
481
Cheryl Rothwell
genealogysleuth
Dec 31, 2011 11:12 pm
http://www.lavasurfer.com/info/socialsecurity.html <-how to decode a SSN. There are likely other sites. ... [Non-text portions of this message have been...
482
Dennis Kowallek
kowallekfamily
Dec 31, 2011 11:38 pm
On Sat, 31 Dec 2011 16:35:47 -0500, Dennis Kowallek <kowallek@...> ... The next patch will have {StateIssued} and {UserData} substitutions. The "User...
483
Tim Rosenlof
tim0cd
Dec 31, 2011 11:45 pm
Great ! That is pretty fast for new years eve ;-) Tim Rosenlof...
484
Ron Taylor
doit4ron
Jan 6, 2012 7:23 pm
Dennis, You've probably already been asked about how your SSDI tool might be tweaked to better acquire info on married females. What are your current...
