Jump to content


michelecolson

Member Since 05 Oct 2013
Offline Last Active Feb 17 2019 04:10 PM
-----

Posts I've Made

In Topic: Shared Facts in Ancestry Sync

14 February 2019 - 08:27 PM

I'll give that a try and see what happens. Thanks for the tips. 


In Topic: Shared Facts in Ancestry Sync

14 February 2019 - 03:16 PM

I tried the script and it worked great. However, I do notice that it creates duplicates when you run it multiple times.

 

I was thinking this might be the best approach: 

1) Run the 1st script to split the shared facts into individual facts. 

2) Run the sync to Ancestry.

3) Run the 3rd script to eliminate the individual facts created with the 1st script. 

 

Then when I have new edits with new shared facts & I re-run the 1st script, there will be no duplicate individual facts. Will that work? 


In Topic: Shared Facts in Ancestry Sync

09 February 2019 - 11:26 AM

Thanks, Rick - I'll give SQLite Spy a try. 


In Topic: Shared Facts in Ancestry Sync

03 February 2019 - 01:29 PM

Thanks so much, Tom. I will give this a try.  :) Any tips on a SQLite manager? I am experienced with Toad for Oracle db (PLSQL) & I work a little bit with SQL Server. Anything similar to Toad would be fantastic - the language seems very similar. I don't mind paying a reasonable fee if it does allow me to export queries to flat files.