Addon:FamilyTree DNA
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. |
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.
Contents
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.
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:
- To choose the downloaded file. This is a required field.
- Enter FTDNA Chromosome Segment Filename:
- To choose the Segment downloaded file. This is a required field.
- 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.
- Once you sign into the FamilyTreeDNA website, (in the mobile app, navigate to Results & Tools --> Autosomal DNA --> Matches).
- For each match that is present in your Gramps tree, click the Edit Note icon.
- 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 matchI0000001, 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
- "New 5.2 gramplet for review: FamilyTreeDNA" Discourse Topic page (note that from version 1.0.30 the Gramplet was changed to a Tool. ) Created by GaryGriffin
- Sync Association addon tool
- DNA Segment Map addon Gramplet
- Roles, Relationships & Associations
- Genetics
