GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2008-01 > 1199896204


From: John Rhodes <>
Subject: Re: [DNA] i1a project vastness.
Date: Wed, 9 Jan 2008 11:30:04 -0500 (EST)
In-Reply-To: <BFECJOAEEPCFBFFLLBGPOEKIEGAA.scorpion@netconnect.com.au>


Dennis,
Specifically, I wish to download all I1a records into Excel.
I go to Ysearch, click on 'Search by Haplogroup', select 'I1a' and obtain a list of 1914 user(s). Here I can "Check All" then click "Compare". I get the Research Tools screen with a window containing all 1914 UserIDs. I click "Show" comparative Y-DNA results. Here I get the first 145 records, not 1914 records. To get the NEXT 145 records I must manually check the records and do it again...and again... What am I doing wrong?

Dennis Wright <> wrote:
Ken,

I often download part of a project spreadsheet as follows:-

Go to the project that you require data from.
Display the spreadsheet by using the Y-Results button.
Click on the first record you require, then holding down the shift key, drag
the mouse down to the last record you require.
Ctrl-C to copy the data.
Open a new worksheet in Excel
Right click in the first cell
Select 'Paste Special' and 'Text'

The data appears in the new Excel spreadsheet

Hope this helps ... I love hearing of other peoples tips too!

Dennis W
************************************************************************

Explain. I have never seen a button or otherwise allowing only part of a
project spreadsheet to download?

Ken

> Ken Nordtvedt wrote:
> Ned, You are ahead of me in apparently knowing what the problem with the
> I1a project is? I can't get it to download period.
>
> It may be size, but it is hard for me to understand why software should be
> thrown for a loop just by size.
>
> You'd think at least FTDNA would send us an explanation of what is going
> on?
>
> Ken


-------------------------------
To unsubscribe from the list, please send an email to with the word 'unsubscribe' without the quotes in the subject and the body of the message

This thread: