Direct Import of RM8 database into RM7 – Part 1
This topic has the same title as my lastest blog post Direct Import of RM8 database into RM7 - Part 1 and is intended to spread the word, invite you to try it out if it is of interest and collect feedback.
Tom
Thanks Tom. The script ran without issue for me; will reply back after digging deeper. An initial thought is that including the ancestry table might also be low hanging fruit as your script is already reverting citation and media links. I realize that most of the folks in this group enter ancestry data by hand so perhaps that's an aspect I can help test.
Thanks, Kevin. Looking forward to your feedback.
Yes, TreeShare and FamilySearch are also low-hanging fruit which I have running in version 2.
Currently struggling with the conversion from RM8 Tasks and Folders back to RM7 Research Tasks and Items and Logs. Making headway but my brain is frying. Unlike most other things, it won't be transparent making the round trip from either starting point.
Quite right. RM8 Tasks seems like an encryption problem - relatively straight forward to solve in one direction and nearly impossible in the other. (Of course that's easy for me to say.) Good luck!!
My testing uncovered an issue w/ Treeshare on 8.1.8. After a disconnect of a rm8 db from ancestry and then a push of a new ancestry tree via treeshare, all sources now show up as "Other Sources", even those that should be "Ancestry Sources". The same procedure in rm7 behaves as expected so this is a RM8 api issue. (ie rm7 db pushes new tree to ancestry via treeshare with LinkAncestry table event entries resulting in "Ancestry Sources" as appropriate, then import that rm7 db to rm8, run db tools, disconnect from Treeshare and repush new tree yields 100% "Other Sources". ) I've reported this issue to RM support; apparently something changed in 8.1.7. Anyway, further testing is in a holding pattern at the moment.
Am hoping this is related.. when I converted your 'Split Shared Facts to Indiv' sql to work on rm8, I thought the Ancestry table rmid contained the citationlink value. I noticed your 'Import Rm8 db to Rm7' script uses the Citation ID value. Not sure if this also changed in 8.1.7 or whether I made a mistake earlier. (I thought I had tested pushing a new tree but perhaps not.) Net, I will update the rm8 update to 'Split Shared Facts to Indiv' sql if needed once this whole treeshare thing gets sorted.
Thanks for those comments. Did you take a new RM8 file TreeShared from Ancestry, import into RM7 using my Part 2 version and then check RM7's TreeShare compare for differences, then Disconnect and TreeShare to a new AMTree and see if Ancestry Sources are preserved?
I can think of no reason why the Ancestry link table record for an Ancestry Source would link to the CitationLinkTable; it is related solely to the Master Citation.
I think this discussion belongs in a topic other than this one - this RM8 to 7 import Part 1 version does not support Ancestry and the issue seems to be more about debugging RM8. I'll have a look at your RM8 version of 'Split Shared Facts to Indiv' sql when I get a chance.
Thanks Tom. Yes, it makes sense for the AncestryTable rmid field to contain the Citation ID. I'll fix that and thanks for your offer to review.
Re: rm8-rm7 import test. My intent was to test if the script impacts ancestry integration, specifically to validate that Ancestry sources were preserved after a TreeShare to a new AMTree, but my test sequence was different. I took a rm7 db that was connected to ancestry, imported from rm7 into rm8, disconnected from ancestry, made a few edits to add citations and Ancestry table entries and then ran your script to convert it back to a rm7 db. For completeness, I tested a TreeShare to a new AMTree before running your script and ran into this new rm8 issue.
Will look for the best place to post rm8-rm7 import Part 2 test results once I finish testing.