Wednesday, July 2, 2014

Genome Mate: Import Data Page

The Import Data page is the main function for imputing bulk data into the application.  To update your database with new matches just load a new version of the input file.  Genome Mate will skip duplicate data and just add the new matches and relatives.

Genome Mate accepts data from several sources.  Some data is copied and pasted from browser pages while others can be imported from a comma separated values (*.csv) file from different sites.

The format of these files is determined by the site creating the file so it is important to select the correct option when loading.  If you have difficulty loading a file, send the file and a description of the issue in an email to support@genomemate.org.

There are two types data that may be imported:

1.  DNA segments shared with a Relative
2.  Relative specific data such as surnames, ICWs, email address, etc.  

When DNA segment data is imported, a table will be presented for you to review prior to adding the data. Please review any messages and if everything is okay, press the Add Data button.

When Relative data is imported, it will be automatically updated.  

Import Data Page

Step 1 - Select Data Source

Choose the origin of the DNA data segments to be posted to Genome Mate - 23andMe, FTDNA, FTDNA or Ancestry (relative data only).

Step 2 - Set the Criteria for Adding Matches

This criteria can be modified on the Options Page but overridden here for the current import.
  • Minimum cMs - Only import DNA segments having a cMs greater than the value shown
  • Minimum #SNPs - Only import DNA segments having SNPs count greater than the value
  • Add New Relatives - Check to automatically add a new relative record if one is not found
  • Show Duplicate Matches - Display duplicate matches in the table and rejects report

Step 3 - Select the Import Option

The import options for the selected data source will be presented.  See these links for more specific information about each:
Rejects and Summary
After the data has been processed, a table of DNA segment matches will be displayed along with any error messages.  If it looks okay, press Add to load into the database and get a process summary.

For relative data only like surnames, email addresses, etc., Relative records will automatically be updated and a process summary shown as well as a list of any rejects.  The most common problem loading Relative data is the present of a new line character in the notes field.  If this occurs, delete the data in the original file and reprocess.

Backups & Restores 

Backups are recommended before loading new data to ensure that work is not lost!

Donations

Genome Mate's continued development, support and enhancements on the internet are funded by your donations.  If you use the application, please consider making a donation through Paypal.

Copyright © Beckins LLC 2013-2014

3 comments:

  1. Any recommendations for using the new 23&Me bulk download functionality with GenomeMate? Any problems if we want to re-import matches to take advantage of the exact start/stop bases? Thanks!

    ReplyDelete
  2. This site is NOT user friendly.

    ReplyDelete
  3. Please direct inquiries to https://www.facebook.com/groups/1487955884768702/

    ReplyDelete