Jump to content


GlenB

Member Since 01 Feb 2008
Offline Last Active Yesterday, 03:22 PM
-----

Posts I've Made

In Topic: Cleaning up FS data

Yesterday, 03:26 PM

Deleted the records in LinkTable as described and then ran the Database Tools in RM. Everything seems fine, and the info presented on Family Search Central makes a LOT more sense. I'm declaring success. Thanks to all for your help.


In Topic: Cleaning up FS data

15 October 2018 - 06:12 PM

DELETE FROM LinkTable WHERE rmID NOT IN (SELECT OwnerID FROM NameTable);

DELETE FROM LinkTable WHERE rmID NOT IN (SELECT PersonID FROM PersonTable);

 

These SHOULD be equivalent if the database has integrity since there's a 1-to-1 correspondence between NameTable and PersonTable as far as I can tell, but I think I like yours better anyway! Thanks.

 

I'm going to wait a little longer before trying it (and looking for unintended consequences) - just in case someone else rolls in with a suggestion.


In Topic: Cleaning up FS data

15 October 2018 - 04:04 PM

I don't use SQLite, but I assume that you do a backup before any database modification.

 

Seriously? If you used SQLite you'd see that as a FREQUENT AND COMMON warning with all the Scripts that have been published for use with RM. And I have way too many years of technical computing experience to miss that in any case.

 

But .... you don't know me so, thanks.


In Topic: Cleaning up FS data

15 October 2018 - 02:26 PM

I think this lists all the FS links that are broken:

        select extID, rmID from LinkTable where rmID not in (select OwnerID from NameTable)

I checked a couple of them and it looks right.

 

So I should be able to delete all those records from the LinkTable with

        delete from LinkTable where rmID not in (select OwnerID from NameTable)

 

But is there anything ELSE I need to do or is just deleting these records enough?


In Topic: How Merging Places works

13 June 2018 - 01:24 PM

OK, sounds like it works the way I hoped it would.

I just need to pay a little more attention to the cases I tried that seemed to not behave correctly.

No details to report of a problem, yet.

Let's close this issue here.

Thanks to both of you.