When I imported a RM7 gedcom to RM10 a few months back in order to match with FamilySearch, I forgot I had private facts relating to my various family members DNA matches. Some 10 months+ later I discover I lost these facts. I am considering creating new facts for these matches and typing the information from printouts back into to RM7.
I want it the fact to say something like:
In “2016” “MCOrcutt” had a “25 cM” Ancestry match to “MAS” common ancestor “John Smith”
I want the fact to be such that if I move to RM11 or later for my primary database that the fact will make sense in the later version. Guess I could simply move to RM 11 for my primary data entry database, but I don’t believe the current DNA fact in RM11 allows for the type of information I want in the above sentence and I still prefer RM7 to the later versions.
Instead of using a gedcom to create the tree have you considered creating a new file in either RM10 or RM11 by importing a copy of your RM7 database? That should import all your private facts and, if you use a copy of your database, will leave your original RM7 database intact and usable with RM7?
I already lost the private facts with the DNA information almost a year ago, so there is no going back as I done extensive editing to my database since I imported the database automatched in RM10 with FamilySearch back to RM7. I had checked some of my own created facts immediately to see if they went with the gedcom but simply forgot I had any private facts.
There might be away. I suspect Sqlite would be needed in part.
Since you use FamSearch – you could query info based FSID then bring in that data into your new datbase as a customer fact for example – this would leave your new DB untouched essentially other than adding one new fact to each person that needs a DNA fact. Depending on the scenario you could potentially do this in one day or maybe a few hours depending. The methods & details for doing this go beyond what is likely appropriate for this forum.
Essentially, you would export a table view (CSV file) from RM 7 of needed info - then import the matching people in the RM11/10 db via a custom DNA fact with that info from RM 7.
You could call the custom Fact “RM7DNAinfo” for example – the name of custom fact is not important but it should not be currently used fact.
Kevin
1 Like
I appreciate the replies to my query. I was not very clear. My missing DNA custom facts were never on FamilySearch. I had wanted to auto match my large database to FamilySearch to look for missing information after RM7 could no longer access it. Therefore I exported almost everything to RM10 (by gedcom forgetting those facts I made private) and ran the automatch. Then by gedcom I copied everything back to RM7 since that is the program I am using for data entry. I thought everything was just how I wanted it until I found I had lost my DNA facts in the original RM7 database.
What I was trying to do today was to make a custom —DNA common ancestor –fact in the format that would read something similar to:
In “2016” “MCOrcutt” had a “25 cM” Ancestry match to “MAS” common ancestor “John Smith”
My italics are where I want the information one places in brackets in the setup for the sentence structure. I have the RM book but I still cannot manage how to set up the new fact.
One key concept to understand/consider is:
The fact sentence template for built-in and custom fact-types can only extract info from the database record for the ONE individual currently being assigned a (defined )fact sentence.
In your sample sentence all the “quoted” parameters (ie. envisioned as bracketed) would need to be data You typed into that custom fact of that ONE individual.
The rub is that “MCOrcutt” and “MAS” and “John Smith” are THREE distinct individuals (in separate database records).
Your example sentence targets “MCOrcutt” for expressing his “shared cM value” with “MAS” via common ancestor “John Smith”.
Unfortunately, the Name details for “MAS” and “John Smith” aren’t stored in the database record of “MCOrcutt”. They’re stored in THEIR distinct database record.
So, in order to store those extra two Names, a Date and a cM value into your custom fact for “MCOrcutt” (or any ONE person), you must effectively use the fields available in creating a custom fact. Those are Date, Place, Place Detail, Description, Role and Notes …basically. Those are what the sentence template “draws” from. That one person’s record. (some fields are just not gonna work for your parameters).
Sidenote: There is a “Combining the fact sentence and the note text” trick described in the Help facility for Fact sentences .
Thanks for the explanation. For those interested in this topic the new fact I created is “Common Ancestor Match”. I was able to make the principal role as below:
[person]<[Desc]><had a common ancestor DNA match on Ancestry to MAS [Date]>.
This convention allows me to add in the description the name of the match, and the fact that the named individual or couple are say my 4th great grandparents as well as the date I added the match to my database.
Now I have to decide whether making over 300 entries to my database from my paper records is worth the time and effort.
But there were in your RM db correct?
No they are lost to the current database because I had forgotten they were there and had not chosen to have them exported in the database the new one is based on a year ago. They are in an old database from a yearbackk , but I cannot go back a year and lose a year’s worth of work for 300 entries when I would lost thousands of changes.
I was able to retrieve the sentence template from the old database which I copied and pasted to the one in my current database.
you are missing my reasons for asking – if they are in the old database – you can potentially retrieve them from old db and merge them into new db working mostly from scripts without redoing work. But I do not have enough info to know if that is possible - this sounds like it might be above your technical ability as it would involved sqlite scripts. Do you have basic
understanding of database and/or sql/sqlite?
I have used computers for years but have I have never learned to use sqlite scripts or other scripts, and at age 83 I am not sure this is a skill I want to take time to learn or can learn. My skills lie with researching rather than computers.
I had thought of trying to make a group of the individuals from the old database with my custom fact and then try to merge them to the current database. But with all the editing I have done to the database, I am afraid it would take me longer to clean up the mess caused by any attempt to merge duplicates than to retype the printout I have for the fact. These particular common ancestor matches were made about 2016, and given the fact the people who match my my known common ancestors likely have died or removed the databases they point to, I question the amount of effort involved to recreate what I lost. It is frustrating though that I neglected to save what I had could have saved if I had simply let the fact export in the gedcom.
