Re: [LegacyUG] csv FILE

[Valerie Garton]

Many thanks to all who replied and/or listened to my problem. It turns out
that my tech person had Word for V2016 but Excel for V2007 - so much for
paying all that money.

Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - A086848,
T756083, H947365, MyHeritage & gedmatch


-Original Message-
From: LegacyUserGroup  On Behalf Of
Brian Kelly
Sent: Sunday, 16 September 2018 12:26 AM
To: Legacy User Group 
Subject: Re: [LegacyUG] csv FILE

What error messages or other indications do you get from Excel when you try
to open the Legacy created .csv file.

Brian Kelly

On 14-Sep-18 11:21 PM, Valerie Garton wrote:
> I must have confused you. I made a gedcom from ancestry and added it to
Legacy. From Legacy I created a csv file and tried to open it in Excel. It
is opening it in Excel that I am having a problem with. The csv file is
there but I cannot open it in Excel nor other downloaded csv files BUT I can
open Excel files that I have created in Excel.
> 
> Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - 
> A086848, T756083, H947365, MyHeritage & gedmatch
> 
> 
> -Original Message-
> From: Brian Kelly 
> Sent: Saturday, 15 September 2018 12:53 PM
> To: Legacy User Group ; Valerie 
> Garton 
> Subject: Re: [LegacyUG] csv FILE
> 
> I do not think that you can download a csv file from Ancestry. Just giving
a file a name like filename.csv does not change the content. if you
downloaded a file from Ancestry it is probably a GEDCOM file which is the
standard format for genealogical files.
> 
> Rename the file to filename.ged
> Open Legacy and use file > Import > GEDCOM file when you have finished the
import from filename.ged Go to View > Name List Click Options > Print Now
you will be able to define up to three rows of data you can include for each
person.
> Select CSV file in the lower right
> The print box in the upper right will change to Create Click create In the
dialog box select the folder where you want to save the file and assign a
file name Click save Remember where you saved that file Open Excel then open
the file you exported from legacy.
> 
> Brian Kelly
> 
> On 14-Sep-18 9:32 PM, Valerie Garton wrote:
>> I have a csv file of my latest ancestry download and I cannot open 
>> this is Excel - what am I doing wrong please?
>>
>> Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - 
>> A086848, T756083, H947365, MyHeritage & gedmatch
>>
>>
>>
> 
> .
> 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

Re: [LegacyUG] csv FILE

[Valerie Garton]

Yes I did that thanks. I also read somewhere to give the second file 3000 rins 
so you know which is old and which is new.

 

Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - A086848, 
T756083, H947365, MyHeritage & gedmatch

 

 

From: LegacyUserGroup  On Behalf Of 
bobstree2
Sent: Saturday, 15 September 2018 1:16 PM
To: Legacy User Group 
Subject: Re: [LegacyUG] csv FILE

 

Be sure to do the import of the GED file into a new blank family file or it 
will be merged with your existing file families. 

 

 

 

 

 

 Original message 

From: Brian Kelly mailto:exma...@gmail.com> > 

Date: 9/14/18 10:52 PM (GMT-05:00) 

To: Legacy User Group mailto:legacyusergroup@legacyusers.com> >, Valerie Garton mailto:vbgar...@gmail.com> > 

Subject: Re: [LegacyUG] csv FILE 

 

I do not think that you can download a csv file from Ancestry. Just 
giving a file a name like filename.csv does not change the content. if 
you downloaded a file from Ancestry it is probably a GEDCOM file which 
is the standard format for genealogical files.

Rename the file to filename.ged
Open Legacy and use file > Import > GEDCOM file
when you have finished the import from filename.ged
Go to View > Name List
Click Options > Print
Now you will be able to define up to three rows of data you can include 
for each person.
Select CSV file in the lower right
The print box in the upper right will change to Create
Click create
In the dialog box select the folder where you want to save the file and 
assign a file name
Click save
Remember where you saved that file
Open Excel then open the file you exported from legacy.

Brian Kelly

On 14-Sep-18 9:32 PM, Valerie Garton wrote:
> I have a csv file of my latest ancestry download and I cannot open this 
> is Excel - what am I doing wrong please?
> 
> Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - A086848, 
> T756083, H947365, MyHeritage & gedmatch
> 
> 
> 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com <mailto:LegacyUserGroup@legacyusers.com> 
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

Re: [LegacyUG] csv FILE

[Valerie Garton]

Been on the phone to Microsoft yesterday waiting for over 6.25 hours when
the phone rang out of batttery. Been on the phone again now for 37 minutes.
What I have done is: Open an excel file, select the file I want to open and
try to open this when the excel page then goes blue with no grid. Would it
be OK for me to ring you please ?

Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - A086848,
T756083, H947365, MyHeritage & gedmatch


-Original Message-
From: LegacyUserGroup  On Behalf Of
Brian Kelly
Sent: Sunday, 16 September 2018 12:26 AM
To: Legacy User Group 
Subject: Re: [LegacyUG] csv FILE

What error messages or other indications do you get from Excel when you try
to open the Legacy created .csv file.

Brian Kelly

On 14-Sep-18 11:21 PM, Valerie Garton wrote:
> I must have confused you. I made a gedcom from ancestry and added it to
Legacy. From Legacy I created a csv file and tried to open it in Excel. It
is opening it in Excel that I am having a problem with. The csv file is
there but I cannot open it in Excel nor other downloaded csv files BUT I can
open Excel files that I have created in Excel.
> 
> Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - 
> A086848, T756083, H947365, MyHeritage & gedmatch
> 
> 
> -Original Message-
> From: Brian Kelly 
> Sent: Saturday, 15 September 2018 12:53 PM
> To: Legacy User Group ; Valerie 
> Garton 
> Subject: Re: [LegacyUG] csv FILE
> 
> I do not think that you can download a csv file from Ancestry. Just giving
a file a name like filename.csv does not change the content. if you
downloaded a file from Ancestry it is probably a GEDCOM file which is the
standard format for genealogical files.
> 
> Rename the file to filename.ged
> Open Legacy and use file > Import > GEDCOM file when you have finished the
import from filename.ged Go to View > Name List Click Options > Print Now
you will be able to define up to three rows of data you can include for each
person.
> Select CSV file in the lower right
> The print box in the upper right will change to Create Click create In the
dialog box select the folder where you want to save the file and assign a
file name Click save Remember where you saved that file Open Excel then open
the file you exported from legacy.
> 
> Brian Kelly
> 
> On 14-Sep-18 9:32 PM, Valerie Garton wrote:
>> I have a csv file of my latest ancestry download and I cannot open 
>> this is Excel - what am I doing wrong please?
>>
>> Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - 
>> A086848, T756083, H947365, MyHeritage & gedmatch
>>
>>
>>
> 
> .
> 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

Re: [LegacyUG] csv FILE

[Brian Kelly]

What error messages or other indications do you get from Excel when you 
try to open the Legacy created .csv file.


Brian Kelly

On 14-Sep-18 11:21 PM, Valerie Garton wrote:

I must have confused you. I made a gedcom from ancestry and added it to Legacy. 
From Legacy I created a csv file and tried to open it in Excel. It is opening 
it in Excel that I am having a problem with. The csv file is there but I cannot 
open it in Excel nor other downloaded csv files BUT I can open Excel files that 
I have created in Excel.

Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - A086848, T756083, 
H947365, MyHeritage & gedmatch


-Original Message-
From: Brian Kelly 
Sent: Saturday, 15 September 2018 12:53 PM
To: Legacy User Group ; Valerie Garton 

Subject: Re: [LegacyUG] csv FILE

I do not think that you can download a csv file from Ancestry. Just giving a 
file a name like filename.csv does not change the content. if you downloaded a 
file from Ancestry it is probably a GEDCOM file which is the standard format 
for genealogical files.

Rename the file to filename.ged
Open Legacy and use file > Import > GEDCOM file when you have finished the import 
from filename.ged Go to View > Name List Click Options > Print Now you will be able 
to define up to three rows of data you can include for each person.
Select CSV file in the lower right
The print box in the upper right will change to Create Click create In the 
dialog box select the folder where you want to save the file and assign a file 
name Click save Remember where you saved that file Open Excel then open the 
file you exported from legacy.

Brian Kelly

On 14-Sep-18 9:32 PM, Valerie Garton wrote:

I have a csv file of my latest ancestry download and I cannot open
this is Excel - what am I doing wrong please?

Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA -
A086848, T756083, H947365, MyHeritage & gedmatch





.



--

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

Re: [LegacyUG] csv FILE

[bobstree2]

Be sure to do the import of the GED file into a new blank family file or it 
will be merged with your existing file families. 




 Original message From: Brian Kelly  Date: 
9/14/18  10:52 PM  (GMT-05:00) To: Legacy User Group 
, Valerie Garton  Subject: 
Re: [LegacyUG] csv FILE 
I do not think that you can download a csv file from Ancestry. Just 
giving a file a name like filename.csv does not change the content. if 
you downloaded a file from Ancestry it is probably a GEDCOM file which 
is the standard format for genealogical files.

Rename the file to filename.ged
Open Legacy and use file > Import > GEDCOM file
when you have finished the import from filename.ged
Go to View > Name List
Click Options > Print
Now you will be able to define up to three rows of data you can include 
for each person.
Select CSV file in the lower right
The print box in the upper right will change to Create
Click create
In the dialog box select the folder where you want to save the file and 
assign a file name
Click save
Remember where you saved that file
Open Excel then open the file you exported from legacy.

Brian Kelly

On 14-Sep-18 9:32 PM, Valerie Garton wrote:
> I have a csv file of my latest ancestry download and I cannot open this 
> is Excel - what am I doing wrong please?
> 
> Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - A086848, 
> T756083, H947365, MyHeritage & gedmatch
> 
> 
> 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

Re: [LegacyUG] csv FILE

[Brian Kelly]

I do not think that you can download a csv file from Ancestry. Just 
giving a file a name like filename.csv does not change the content. if 
you downloaded a file from Ancestry it is probably a GEDCOM file which 
is the standard format for genealogical files.


Rename the file to filename.ged
Open Legacy and use file > Import > GEDCOM file
when you have finished the import from filename.ged
Go to View > Name List
Click Options > Print
Now you will be able to define up to three rows of data you can include 
for each person.

Select CSV file in the lower right
The print box in the upper right will change to Create
Click create
In the dialog box select the folder where you want to save the file and 
assign a file name

Click save
Remember where you saved that file
Open Excel then open the file you exported from legacy.

Brian Kelly

On 14-Sep-18 9:32 PM, Valerie Garton wrote:
I have a csv file of my latest ancestry download and I cannot open this 
is Excel - what am I doing wrong please?


Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - A086848, 
T756083, H947365, MyHeritage & gedmatch






--

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

[LegacyUG] csv FILE

[Valerie Garton]

I have a csv file of my latest ancestry download and I cannot open this is
Excel - what am I doing wrong please?

 

Cheers from Valerie Garton [nee Vaughan] in sunny Sydney. DNA - A086848,
T756083, H947365, MyHeritage & gedmatch

 

 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

Re: [LegacyUG] CSV file with hashtags

[Jenny M Benson]

On 04/03/2018 04:11, Teresa Williams wrote:

I'd like to get a list of individuals and the hashtags that apply to them as a 
CSV file to track my checking (there's a LOT of checking to do). Searching one 
hashtag at a time gives me 8 CSV files, but these are not easily merged: the 
David Smith tagged 1841 and 1851 may not be the same David Smith tagged 1861.


I always put the RIN after a person's name in Notes (such as listing the 
household members in a Census) and add the RINs to lists etc, so it is 
always easy to distinguish people who have the same name.  (I have 9 
people in my family file named Abraham Molyneux!)


--
Jenny M Benson - http://jennygenes.blogspot.co.uk/
Wrexham, UK

--

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

Re: [LegacyUG] CSV file with hashtags

[Teresa Williams]

Many thanks Cathy.

It puts all the hashtags into one string, but LibreOffice can split them out.

> Sent: Sunday, March 04, 2018 at 5:27 PM
> From: "Cathy Pinner" 
> To: "Legacy User Group" 
> Subject: Re: [LegacyUG] CSV file with hashtags
>
> Teresa,
> 
> You are missing that you can include the Hashtags when you customise the 
> Print to create the CSV. There is currently a bug if you choose 
> particular hashtags but "all assigned" are being included in one column.
> 
> Cathy
> 
> > Teresa Williams <mailto:teresa.willi...@gmx.us>
> > Sunday, 4 March 2018 12:11 PM
> > Hi again.
> >
> > I have generated census lists for all the censuses appropriate to my 
> > people. And I can give them a hashtag such as '1911_check' to indicate 
> > that I should check the census in 1911 for that individual. Of course 
> > some individuals get more than one hashtag.
> >
> > I'd like to get a list of individuals and the hashtags that apply to 
> > them as a CSV file to track my checking (there's a LOT of checking to 
> > do). Searching one hashtag at a time gives me 8 CSV files, but these 
> > are not easily merged: the David Smith tagged 1841 and 1851 may not be 
> > the same David Smith tagged 1861.
> >
> > I can build a search list of all those with hashtag 1911_check or 
> > 1901_check etc, but can't export the resulting search list to a CSV 
> > with the hashtags displayed.
> >
> > Am I missing something? I there a way to generate a CSV file showing 
> > the hashtags for an individual?
> >
> > Thanks
> > Teresa
> >
> 
> 
> -- 
> 
> LegacyUserGroup mailing list
> LegacyUserGroup@legacyusers.com
> To manage your subscription and unsubscribe 
> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
> Archives at:
> http://www.mail-archive.com/legacyusergroup@legacyusers.com/
> 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

Re: [LegacyUG] CSV file with hashtags

[Cathy Pinner]

Teresa,

You are missing that you can include the Hashtags when you customise the 
Print to create the CSV. There is currently a bug if you choose 
particular hashtags but "all assigned" are being included in one column.


Cathy


Teresa Williams 
Sunday, 4 March 2018 12:11 PM
Hi again.

I have generated census lists for all the censuses appropriate to my 
people. And I can give them a hashtag such as '1911_check' to indicate 
that I should check the census in 1911 for that individual. Of course 
some individuals get more than one hashtag.


I'd like to get a list of individuals and the hashtags that apply to 
them as a CSV file to track my checking (there's a LOT of checking to 
do). Searching one hashtag at a time gives me 8 CSV files, but these 
are not easily merged: the David Smith tagged 1841 and 1851 may not be 
the same David Smith tagged 1861.


I can build a search list of all those with hashtag 1911_check or 
1901_check etc, but can't export the resulting search list to a CSV 
with the hashtags displayed.


Am I missing something? I there a way to generate a CSV file showing 
the hashtags for an individual?


Thanks
Teresa




--

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

[LegacyUG] CSV file with hashtags

[Teresa Williams]

Hi again.

I have generated census lists for all the censuses appropriate to my people. 
And I can give them a hashtag such as '1911_check' to indicate that I should 
check the census in 1911 for that individual. Of course some individuals get 
more than one hashtag.

I'd like to get a list of individuals and the hashtags that apply to them as a 
CSV file to track my checking (there's a LOT of checking to do). Searching one 
hashtag at a time gives me 8 CSV files, but these are not easily merged: the 
David Smith tagged 1841 and 1851 may not be the same David Smith tagged 1861.

I can build a search list of all those with hashtag 1911_check or 1901_check 
etc, but can't export the resulting search list to a CSV with the hashtags 
displayed.

Am I missing something? I there a way to generate a CSV file showing the 
hashtags for an individual?

Thanks
Teresa

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/