Addon:FamilyTree DNA

From Gramps
Gramps-notes.png
This is a Third-party Addon. The Addon/Plugin system is controlled by the Plugin Manager.

Please use carefully on data that is backed up, and help make it better by reporting any issues to the bug tracker.
Unless otherwise stated on this page, you can download this addon by following these instructions.
Please note that some Addons have prerequisites that need to be installed before they can be used.

Family Finder Tool - Options - dialog - addon default (aka: Family Tree DNA - Tool )

The FamilyTree DNA Tool allows you to import DNA Haplogroup and autosomal segment information from the FamilyTree DNA website. The tool creates a DNA Association between the Active person and each matched person. The reciprocal Association is not created.

Usage

  • Once this addon has been installed
  • Prepare the required files from the FamilyTree DNA website then:
  • Make sure to select the Gramps Active person who should be the person whose FamilyTree DNA was downloaded.
  • Select Menu Tools > Utilties -> FamilyTree DNA... to open the Family Finder Tool dialog.
  • Select the two previously downloaded files from the FamilyTree DNA website and the select the Import button to start the tool. If a file is missing you get the FamilyTree Import (No Family Finder File Specified or Chromosome Segment File Specified) warning dialog to remind you or if the filename are a problem read the issue section for further information.


Family Finder Tool dialog.

Family Finder Tool - Options - dialog - addon default (aka: Family Tree DNA - Tool )

The Family Finder Tool shows:

  • Active Person: the current active person for whom the Gramps Note is created and attached to the Association.
  • Enter FTDNA Family Finder Filename:
  • Enter FTDNA Chromosome Segment Filename:
  • Import Haplogroups - Check if the match haplogroup should be imported as an Attribute of the match. If the attribute already exists, it is not overwritten.
  • FTDNA Note String: The identifier used to extract the Gramps ID from the FamilyTree note in the first file. This defaults to "GRAMPSID=". The match GrampsID should immediately follow this string in the note

Shared Citation ID: The Citation ID attached to the Association. If none is specified, a new Source and Citation is created.

  • Import button: Press to start the tool.
  • Help button open a browser to this wiki webpage.


Purpose

The purpose of this tool is to import DNA Haplogroup and autosomal segment information from the FamilyTree DNA site. The autosomal test in FamilyTree DNA is called FamilyFinder. The tool requires the user to first tie the FamilyTree person to the Gramps person. Only those people who are tied to a Gramps ID will be processed. Once done, the user needs to download the FamilyFinder match CSV file and the Chromosome Browser file. The user can then execute the tool to extract the haplogroups for matches and the DNA segment information for use with the DNA Segment Map gramplet.

Specific Details

For every person in FamilyTreeDNA that is matched to a person in the Gramps tree (thru a FamilyTree DNA note), an Association is created. This Association has a Note that includes all of the Segment data. Optionally, for every person matched, the Y-DNA and mtDNA haplogroup will be added as an Attribute to the matched person.

The Gramps Active person should be the person whose FamilyTree DNA was downloaded. The tool creates a DNA Association between the Active person and each matched person. The reciprocal Association is not created.

If a DNA Association already exists between the Active person and a match person, nothing will be added. If the match person already has a Y-DNA or mtDNA haplogroup Attribute, it will not replace or change it. Therefore, the tool can be executed multiple times as more people are tied between FamilyTree DNA and Gramps.

FamilyTree DNA prep

Complete the following steps in the FamilyTree DNA app and to tie the matches to Gramps.

  1. Once you sign into the FamilyTreeDNA website, (in the mobile app, navigate to Results & Tools --> Autosomal DNA --> Matches).
  2. For each match that is present in your Gramps tree, click the Edit Note icon.
  3. Add the text 'GRAMPSID=' followed by the Gramps ID for that individual into the note. The note should change appearance to indicate it is non-blank. For instance, if you were to match I0000001, you would enter 'GRAMPSID=I0000001' as the Family Tree note.

Complete for all of the matches that are in your Gramps tree.

Export CSV

To create the FTDNA Family Finder File in the FamilyTree DNA app click the Export CSV icon and select All Matches to download the Family Finder match info. This will create a file <kit number>_Family_Finder_Matches_<YYYY-MM-DD>.csv . This file has the name of the match, the note, and (potentially) the haplogroups (depending on which tests have been purchased).

Sample Family Finder Matches CSV header

Full Name 	First Name 	Middle Name 	Last Name 	Match Date 	Relationship  Range 	Shared DNA 	Longest Block 	Linked Relationship 	Ancestral Surnames 	Y-DNA Haplogroup 	mtDNA Haplogroup 	Notes 	Matching Bucket 	X-Match 	Autosomal Transfer
John P. Тимофеев 	John 	P. 	Тимофеев 	4/19/2021 	Half Sibling, Uncle/Aunt/Niece/Nephew, Grandparent/Grandchild 	1976.62 	135.57 	Uncle 	Daniels / Тимофеев 	R-M269 		GRAMPSID=I01110 	Maternal 	No Match 	No

Download Segments

To create the FTDNA Chromosome Segment File in the FamilyTree DNA app navigate to Results & Tools --> Autosomal DNA --> Chromosome Browser. Click on the Download All Segments. This will create a <kit number>_Chromosome_Browser_Results_<YYYYMMDD>.csv file. This file has the name of the match and the segment info for all matches.

Sample Chromosome Browser Results CSV header

Match Name 	Chromosome 	Start Location 	End Location 	Centimorgans 	Matching SNPs
John P. Тимофеев 	1 	18481003 	61952574 	53.763832 	11126

Details

The tool reads the downloaded FTDNA Family Finder File to check for notes. If the note exists, then that person is a match with someone in Gramps. For each match, the haplogroup is extracted (if requested) and added as an Attribute on the match.

The tool reads the downloaded FTDNA Chromosome Segment File and tracks the segment info for each match. An Association is created for each match. If the DNA Association already exists, nothing is added. This Association is with the Active Person: and the match. For each match, a Gramps Note is created and attached to the Association. This Gramps Note contains the segment match information that can be read by Addon:DNASegmentMapGramplet. If the user specified a Citation ID, that ID is attached to each Association. Otherwise one Source / Citation is created and attached to each of the Associations.

Issues

The two download files from FamilyTree DNA ( FTDNA Family Finder File & FTDNA Chromosome Segment File ) are tied together using the name of the match. If the name of the match is not unique, then the match information will be incorrect. It uses the First, Middle, and Last names as specified by the match when they created their FamilyTree account.

See Also