Welcome to the DNAGedcom Client

Welcome to the DNAGedcom Client Introduction The DNAGedcom Client (“DGC”) is a Windows and Mac application that runs on a user’s machine. It will download AncestryDNA match, tree and shared matches data into .csv files. In addition, the Windows version also includes the capability to download 23andMe data. The 23andMe download will be added to the Mac version in the near future. FTDNA and other capabilities will also be added in the future. In order to give our users the best and easiest service we can provide, this client app will be available by subscription only. Monthly rates to become a subscriber are $5.00. The annual rate is $50, a 17% discount over the monthly rate. The subscription helps to support the other complimentary features on the DNAGedcom web site.

Instructions To subscribe to the DNAGedcom Client, login to DNAGedcom.com. Go to the "Members" tab and in the drop down menu, click on "Subscriber Information".

You will be taken to the subscriber page, where you can add a subscription. You can make your payment through PayPal for a recurring $5.00 per month or an annual subscription for $50.

1|Page © 2016 DNAGedcom – All rights reserved Updated 10/10/2016

If you don’t have a PayPal account or would prefer to send a check, please make checks payable to DNAGedcom LLC and mail to: Rob Warthen 13511 Moser Rd. Thurmont, MD 21788 After submitting your subscription, it can take up to 60 minutes for it to be processed. Once it is processed, you will see a link to the DNAGedcom Client tool as shown above. For Windows PC users, follow this link to http://www.dnagedcom.com/app/publish.htm.


We prefer that you click on “Install” but if you are sure you already have Microsoft .NET Framework 4.5 or greater installed, you can click on the “Launch” link to launch the application, otherwise, click “Install”. After clicking on “Install”, a setup.exe file will be downloaded to your computer. You may get a warning, please accept/keep the download. Save to a folder you will remember, then click on the setup.exe file to install the app. Again, you may get a warning, please allow the installation file to run. After installing, you will be able to run the program from your start menu under DNAGedcom / DNAGedcom or you can find it here: C:\Users\YourProfile\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\DNAGedcom\DNAGedcom Mac users can install the client by clicking on this link: http://www.dnagedcom.com/app/DNAGedcom.app.zip When the download completes, unzip the file by double-clicking on it in your Downloads folder. Then open the folder and copy the application to your Applications folder to install it. You can run the client just as you would any other Mac app.

Using the DNAGedcom Client After running the DNAGedcom client, a small box may come up verifying the application. It may also ask you to confirm. If your virus program or firewall give you a message or warning, please continue and accept the download. When it opens the first time, you will be asked for your DNAGedcom username and password to verify your subscription. An incorrect DNAGedcom username or password will prompt a message “Your username or password are incorrect”.


Windows DNAGedcom Logon Panel:

Macintosh DNAGedcom Logon Panel:


After verifying your subscription by logging into DNAGedcom, you will be taken to the main page where you will see three selections: “Options”, “Ancestry” and “23andMe”. Select “Options”, then “Export Folder” to choose a folder location where output files will be created. Then click “Save”. For Windows, use the little back arrow in the upper left to go back to the main page. Then select “Ancestry”. The Mac client will select Ancestry for you automatically. Enter the username and password for your Ancestry account, then click “Logon”. Windows Ancestry Logon Panel:

Macintosh Ancestry Logon Panel:


Once you are logged in, the profile drop-down box will show the DNA tests you have in your account. Choose the test you want to download.

Then Click “Gather Matches”. A progress bar will show the percentage downloaded and will then show you when that is complete. On Windows, the “Cancel” tab will also gray out when it is complete. The Mac client will display a message indicating successful completion. Next click “Gather Trees”. Again the progress bar will proceed. This portion will usually take much longer than gathering the matches depending on the number of matches as well as trees in the DNA account. The tree gathering for an AncestryDNA 6|Page © 2016 DNAGedcom – All rights reserved Updated 10/10/2016

account with 2,767 matches took just about a half-hour to complete. Accounts with over 10,000 matches will take much longer. Connecting your computer with an Ethernet cable will give you better performance than over WIFI. The third file you can download is the ICW file (Shared Matches in Ancestry's terminology), which will show you which of your matches have others of your matches in common. You can also choose “Quick” download to skip collecting ethnicity and segment information (which requires a separate page load) and/or you can download only 4th cousins or closer. Note that you will not be able to download trees or ICWs unless you have run Gather Matches in the current session for the current profile. This is because Gather Matches creates an in-memory table of matches that both Gather Trees and Gather ICWs depend on. Once all the data has been downloaded, go to the export folder you set under “Options”. The files will be named m_ProfileName.csv (“m” file is Matches file), a_ProfileName.csv (“a” file is Ancestors of Matches file - the trees) and ICW_ProfileName.csv (ICW file is the In Common With matches).

What can I do with these files? See the documentation for GWorks, a Gedcom Comparison Utility, produced by DNAGedcom.com for additional information how to work with these files. See: http://www.dnagedcom.com/docs/GWorks_Howto_Revised_Final.pdf The files can also be used in Excel or any spreadsheet program for analysis or even in Microsoft WORD or any text editor to view and search. For example, you can search in the matches file for Ancestry usernames - something that is not possible within the Ancestry web interface. Or you can search in the Ancestors/Tree file for death locations, something that is also not possible on Ancestry itself.


23andMe Downloads (Windows client only presently) Go back to the main page and select “23andMe”. Log in to 23andMe with the correct credentials.

Select the profile from the drop down menu next to “Profile”. Click on “Gather Matches”. A green progress bar will show the percentage downloaded. When completed, click on “Gather FIA”. Once this is done the people you are sharing genomes with will appear in the “Share/FIA” drop down menu. You can gather them all by clicking on “Gather All FIA” or do them individually by selecting each one and click on “Gather FIA”. The “Gather All FIA” will default to a file named “Combined_23andMe_FIA.csv”. We recommend once this file is complete you change the name of the file or move it out of the Export Folder as any new “Gather All FIA” files will overwrite it. Please be patient as some of these files can take quite a while to download. Future downloads for the same account will be faster as the previous information is cached. 8|Page © 2016 DNAGedcom – All rights reserved Updated 10/10/2016

Your matches file from 23andMe will be named ProfileName_23andMe_RF.csv. The Chromosome Browser is the FIA file and is named ProfileName_23andMe_FIA.csv. The Full FIA filed is named Combined_23andMe_FIA.csv. Once the Combined file is completed, we suggest you change the name of this file to ProfileName_Combined_23andMe_FIA.csv.

Problems? 1. If your log in credentials seem to be failing and you get an “Invalid logon”, please check the appropriate website and make sure you are using the correct credentials. https://www.dnagedcom.com/Account/Login.aspx https://secure.ancestry.com/login? https://www.23andme.com/cas/signin/

2. Occasionally new subscribers to the client may see a delay in the processing of their subscriptions. If you can’t log in within 24 hours of subscribing please contact the support email below. 3. Sometimes an error box in Windows will show “Value Null” while downloading. Close the box and click on “Gather Matches” again and it should complete. 4. When doing a “Gather All FIA” for 23andMe, if you get an “Object Reference” error, close the error box. All downloading will stop. Return to the homepage, click on “23andMe” and log in again, then “Gather Matches”, then “Gather FIA”. These will complete very quickly. Then click on “Gather All FIA” and the previous downloads, which are cached, will quickly populate until you get to the match that was not yet downloaded. It should then continue. 5. Please send an email to [email protected] if none of the instructions above answer your question.


Match-O-Matic The Match-O-Matic tool in the DNAgedcom client slices and dices the match files you have downloaded using the Ancestry downloader. It is particularly useful if other persons who have tested at Ancestry have shared their DNA results with you. Anyone can share their DNA test results with others by clicking on the SETTINGS link in Ancestry:

Once shared, the invited person can use the DNAgedcom Client to gather matches, trees, and ICWs from the test results of the person who shared it. Match-O-Matic will read two lists of matches in .csv format and perform various comparisons to produce up to four files as output: ALL - a file containing all matches in both input files (with duplicates eliminated), ICW - a file containing matches in common between the two files, ANB - a file with matches that appear in the first file but not the second file, and BNA - a file containing the matches in the second that are not in the first.

10 | P a g e © 2016 DNAGedcom – All rights reserved Updated 10/10/2016

Output files can be fed back into Match-O-Matic to perform multiple passes for more complex comparisons. For example, you can merge yours and a sibling's lists of matches to produce a list of all matches belonging to either sibling (ALL), then that file can be fed in, comparing to the match file of a cousin to identify matches that are in common with the cousin that are likely to be related to that specific branch of your family. Or you could run comparisons between descendants of a specific ancestral couple to see what other matches there are that might descend from them. It can also be used to compare before and after the Ancestry algorithm change, or to compare downloads done at different times to see which matches are new (and whether any have disappeared!)

Using Match-O-Matic The Match-O-Matic screen looks like this:

To start, click on Select Input File A and choose an input matches file. Normally they will be in your Export Folder with a name like "m_My Name.csv". Input files must be match files. They cannot be Tree or ICW files. Now do the same for your second file, File B. Click on "Specify Output Folder and Prefix for File Names" to indicate where you want Match-O-Matic to put its output files. It assumes the Export Folder but you can use another folder. The "file name" you create is used to form a prefix for the output filenames. Output files have names like "prefixyouchose_nn_XXX.csv" where "prefixyouchose" is the name you specified, "nn" is a two digit number assigned sequentially to avoid overwriting your older files, and XXX is the type of output file (ALL, ICW, ANB, or BNA). 11 | P a g e © 2016 DNAGedcom – All rights reserved Updated 10/10/2016

Once you have selected something for all three buttons you can click the Create Files button to begin processing. If you don't want all four files you can uncheck any that are not needed. (You will still see the count of records that would have been in each of them whether or not a file is written.) A typical output after processing completes might look like this:

What can I do with these files? These output files can be run back into Match-O-Matic to create further combinations, or you can load them into a spreadsheet program like Excel or even a word processor to examine the subsetted matches further.

Troubleshooting If you receive this error message: File A header doesn't look like a Matches file It means that the header row in the file you provided does not have columns that would be found in a match file. Probably you have selected a tree or ICW file by mistake. If you see: Invalid CSV format in File A - redownload


It probably means that your csv file is damaged. Load it into Excel and scroll down. Usually you will find an unbalanced double-quote that causes one of the rows to be shorter or longer than the others. If this is the case, redownload the match file and try again. Match-O-Matic uses CSwiftV, created by Created by Daniel Haight, copyright (c) 2014 ManyThings. All rights reserved.

Thanks for using DNAGedcom!
