Jump to content


Photo

mtDNA template


  • Please log in to reply
5 replies to this topic

#1 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 26 February 2013 - 07:19 AM

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)

Attached Files



#2 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 26 February 2013 - 07:41 AM

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



#3 bhinman

bhinman
  • Members
  • 3 posts

Posted 02 May 2013 - 08:01 AM

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?



#4 Jim Byram

Jim Byram
  • Moderators
  • 7,340 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 02 May 2013 - 08:15 AM

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.



#5 LornaHenderson

LornaHenderson
  • Senior Members
  • 834 posts
  • Gender:Female
  • Location:Waikanae, NZ

Posted 26 September 2013 - 12:53 PM

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

 


Regards,

Lorna
Win 7 Pro  SP1 (Desktop & MacBookPro with Parallels 9)


#6 Karla Huebner

Karla Huebner
  • Members
  • 38 posts
  • Location:Dayton, Ohio
  • Interests:Scotland, Germany, Norway, and Minnesota are my main geographic foci.

Posted 20 October 2013 - 10:12 AM

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.


Karla Huebner




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users