Jump to content
Jim Byram

mtDNA template

Recommended Posts

I've attached an alternative mtDNA template file.
Since mitochondrial DNA reporting is shifting from reporting markers relative to the Cambridge Reference Standard (rCRS) to reporting markers relative to the Reconstructed Sapiens Reference Sequence (RSRS), I revised the Mitochondrial DNA (mtDNA) template to include two tests... 'mtDNA Test (rCRS)' and 'mtDNA Test (RSRS)'. This allows you to record your results using both methods. Existing test data in your database won't be affected and will be under the 'mtDNA Test (rCRS)' test.
This template file will work with TMG7 and with TMG8. It should be unzipped into the appropriate user program data folder replacing the existing template. (see the Data File Storage topic in help for the folder location)

Mitochondrial DNA (mtDNA).zip

Share this post


Link to post
Share on other sites

Storing DNA test results in a genealogy database program such as TMG is only of limited value. Has anyone written a database program specifically designed for storing, comparing and printing DNA data?

 

Genealogy database programs that can store DNA data...

Ancestral Quest

Family Tree Maker

Legacy

Reunion?

RootsMagic

TMG

Share this post


Link to post
Share on other sites

I need to use this template as FamilyTree DNA has now reconfigured my HVR1 & HVR2 results to the new format and I have also just ordered a full sequence. I downloaded the file, and it went to Windows 7 Professional C:Downloads. I opened TMG & went to Help and searched Date File Storage and found that the exisiting file in question is in C:Users, etc. I opened that folder and can see the existing file. I then moved the new file from Downsloads to the TMG8 folder. Now I need to unzip it, but I can't. I clicked on it and it opened a new window showing the file extension .dna, which Windows doesn't recognize. Looking on the web, that doesn't seem to be the right extension. Before I clicked the extension was .zip, but when I checked my computer for a program to unzip it I couldn't find one, although I am sure I have opened zip files before, including ones from TMG. When I look at Properties for the zip file it says: Opens with Windows Explorer, which is certainly not right. What do I need to do to unzip this file?

Share this post


Link to post
Share on other sites

Open the ZIP file using Windows Explorer and drag the .DNA file into the user program data folder and replace the existing .DNA file. (Windows Explorer treats a ZIP file like a folder.) You don't open the .DNA file.

Share this post


Link to post
Share on other sites

Jim,

 

As a DNA project admim for several projects I use the (Y) DNA results stored in TMG all the time thanks to John Cardinal's secondsite.

It enables me to present both overall results and the links to individual people and my One Name Studies with ease, including any analysis done.

But any analysis has been manual.

 

For Family Finder data however I do have a separate MySQL database of downloaded results and several utilities (mostly for data filtering and consistency checking) that I've written to integrate with a private TNG website.

Sites like Gedmatch most certainly analyse and compare FamilyFinder results.

 

It is a little misleading to say that eg Family Tree Maker allows storage of DNA data.

As far as I can currently see, it allows you to input a tag labelled DNA with a date and notes which hardly compares with TMG, Legacy, RootsMagic (don't know about the others) where you can actually input which test, and the marker results.

I've not compared the output options.

 

 

Storing DNA test results in a genealogy database program such as TMG is only of limited value. Has anyone written a database program specifically designed for storing, comparing and printing DNA data?

 

Genealogy database programs that can store DNA data...

Ancestral Quest

Family Tree Maker

Legacy

Reunion?

RootsMagic

TMG

 

Share this post


Link to post
Share on other sites

I would love to see a database system for really working with DNA results and matches. Everyone seems to use spreadsheets for that and while admittedly I'm better with databases than spreadsheets, it seems to me that I've always got 3-4 spreadsheets and a Word document open at once when instead (in theory) I could have one database. However, it's about 20 years since I did any database programming (Paradox) and I have no intention of doing any more of it--I'll leave that to the more skilled, thank you.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×