Jump to content


How would you do it? (Starter)

  • Please log in to reply
1 reply to this topic

#1 Kamolga


    Advanced Member

  • Members
  • PipPipPip
  • 69 posts

Posted 13 April 2019 - 11:11 AM



My story: I have started genealogy as a hobby a couple of weeks ago, grew a tree of +-3500 people through Myheritage.com when I realised a lot of things went wrong, especially since it is based mostly on shared trees.

I am a Microsoft Excel specialist and quite a good user of Microsoft Access and was looking for something closer to them (Tables/List wit tools to spot inconsistencies) than what we find online. RM is above expectations on many sides (sources, follow up on research and possibilities to adapt most of the pre-built functions...most of all I spot really quickly if someone misses capital letters, a place is not entered the same way, etc.). So I start my database all over again, hopefully reliable and consistent, manually in RM but before I start filling it (I have about 70 living people so far), I look for the most efficient way to work.


What I try to get:


1.   See child birth in parents facts (and death if they are alive when it happens) as well as parents death in the children facts and spouse death in own facts.

   I played in a dummy database and sharing birth with a parents shows exactly what I am looking for but I am afraid that an export/manipulation/import in a few years could read those as multiple births for the person: I don't mind it does not appear in other softwares / sites but fear multiple entries in Gedcom manipulations. In addition, doing that manually is quite time consuming, is there a way to automate the sharing of the facts (if sharing is the solution) ?


2. Godfather / Godmother relationships

     Because many in my family have godparents without getting baptised and I like to see who is the Godparent of who, I created a Godfather and a Godmother fact (and role) that I share with the Godparent with a sentence for each.

[Person] is the godchild of [Godfather]


[ThisPerson] is the godfather of [Person]

Right method? Hopefully I will not have to change the method in 6 months because it creates an issue.


3. See full tree with siblings, second spouses, etc.


    I get used to navigate in family view but will look for an extra software that show full trees (no click to see second spouse ancestors). In my dream, I would even get a colored spot line for godparents.


4. Clearly see if people are dead


   It is strange that entering the parent of a dead person does not suppose them dead. I would rather click "Living" when they are alive as it will be a much smaller percentage of the tree. Any easy way to review who is dead or alive?


5. Have photo stored online

 I would like to save photos in https://imgbb.com/ and mention URL instead of file path to get links valid among sites, computers and softwares.


Please, answer with any recommendations (good habit, do's and don't, best practice,...) that could help any beginner

Rootsmagic with a lot of SQL queries (SQLiteSpy) and a bit of Family Historian 6.2 (tree view and map)

#2 TomH


    Advanced Member

  • Members
  • PipPipPip
  • 6251 posts

Posted 13 April 2019 - 01:20 PM

With your Excel and Access skills, you're a rather special beginner. Both can be connected to a RM database via a SQLite ODBC. Find out more at https://sqlitetoolsforrootsmagic.com

Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.