Custom Template Examples
Caution: These templates have been provided by users who have created their own templates from their downloaded files in the past.
Please check the template against your files to ensure current accuracy.
23andMe downloaded via DNAGedcom Client
While the DNAGedcom Client can download data from 23andMe, it does take a extended amount of time, and for some people this means days for a single kit.
Downloading match and chromosome data direct from 23andMe, and using 529Renew to obtain targeted ICW / Triangulation information, is much faster.
For those who still wish to use the DNAGedcom Client to download 23andMe, the following template information has been supplied to enable you to create your own import templates. If a data item is not mentioned, it can be safely left blank.
There is no need to create a new source for these, as the existing source of 23andMe can be used.
Relatives / Matches
Menu Item: DNAGedcom
Enter a unique template description: 1: 23andMe : Load RF File
Select Source: 23andMe
Input Type: .csv
Select Data Type: Relatives
Select Profile Location: Use Current Profile (this may turn grey automatically on selection of "Relatives" data type)
Enter Import Instructions:
This imports Relative data like surnames and locations.
Using the DNAGedcom Client:
1. Select 23andMe
2. Enter 23andMe Email address and password
3. Select profile from drop down list
4. Click on Gather Matches button and wait to finish
5. On GDAT import: select {name}_23andMe_RF.csv file
Enter Column where each Data Item can be found:
Primary Key 28
Relative Name 1
Ethnicity 13
Family Locations 15
Family Tree Link 28
DNA Profile Link 27
Sex 2
Surnames 14
Total Segments 8
Tick the box "Import Data has a Header Row"
Your finished template should look like this.
Click "Save" to save and activate your template.
Remember to Export your custom template for backup.
Segments and Shared Data
Menu Item: DNAGedcom
Enter a unique template description: 2: 23andMe : Load FIA File
Select Source: 23andMe
Input Type: .csv
Select Data Type: DNA Segments
Select Profile Location: Find Profile in File
Enter Import Instructions:
This imports DNA Segment data. Gather Matches has to be run before this import.
Using the DNAGedcom Client:
1. Select 23andMe
2. Enter 23andMe Email address and password
3. Select profile from drop down list
4. Click on Gather ICW Overlapped and wait to finish
5. On GDAT import: select {name}_Overlap_23andMe_FIA.csv file
Enter Column where each Data Item can be found:
Relative Key 1 8
Relative Key 2 9
Relative Name 1 1
Relative Name 2 2
Chromosome 3
Start Point 4
End Point 5
cMs 6
SNPs 7
Tick the box "Import Data has a Header Row"
Your finished template should look like this.
Click "Save" to save and activate your template.
Remember to Export your custom template for backup.
Geneanet
Geneanet has a service which allows you to upload the raw data of a DNA test kit taken with any company, to compare it to other Geneanet members’ DNA data, and to find members with whom you share DNA segments. More information can be found on their FAQ at https://en.geneanet.org/dna/help/
If you choose to load your DNA data to Geneanet, below is a User Designed import template that may be able to assist you to import your Geneanet match data into GDAT.
Before starting however, you will need to create a custom source as explained on the Source Settings page.
You will then need to add your unique match key to your profile as explained on the Profile Keys page.
To find your Geneanet Profile Key, go to your "View DNA Matches" page, and copy all characters After the last / slash.
This key is 30 characters long, typically contains letters and numbers and takes the format of xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
To Create your import template, go to Preferences F11.
Right click (Control-Click on Mac) anywhere within the central area underneath the heading "Import Data templates", and select "Add New Template".
Adjust each field shown as below.
Menu Item Geneanet
Enter a unique template description 1: Geneanet Combined"
Select Source Geneanet
Input Type .csv
Select Data Type DNA Segments
Select Profile Location Use Current Profile
Once you have made these adjustments, you should see the lower portion of this area populate Data Item names.
Enter the import instructions of
This loads the Relative and DNA Segment data from Geneanet.
On Geneanet
- Select DNA -> View DNA Matches
- Select Export this data into CSV file format (at page bottom)
On import: select the file called geneanetADN_export_segments_all_matches_{ProfileKey}.csv
Enter Column where each Data Item can be found:
Relative Key 1 1
Relative Name 1 2
Chromosome 4
Start Point 5
End Point 6
cMs 8
SNPs 7
Tick the box "Import Data has a Header Row"
If a data item is not mentioned, it can be safely left blank.
Your finished template should look like this.
Click "Save" to save and activate your template.
Remember to Export your custom template for backup.
One word of note: When a person uploads either their own DNA or that or a family member, there is an extra step that can be missed by many regarding the name of the kit. If the match manager has not taken this extra step, your resulting match list in GDAT can be filled with matches all named "Private name".
If you have loaded your DNA to Geneanet, you can fix this for others by going to your "Manage DNA Data page" and then selecting "Edit Information" for each DNA Data file. Then, select "Edit the Public Name" and select the appropriate option for your kit/s.
(I don't know how to make individual's visible in a family tree yet, but I can at least guide you making appropriate kit names known to others.)
Over time, more example templates may be included here.