RE: [LegacyUG] Creating date-sorted 'shopping lists'

[Jack Cardwell]

Title: RE: [LegacyUG] Creating date-sorted 'shopping lists'

If you know this already I apologize but if you get the following format from the File | Export function, it is nothing more than a comma-delineated file. Simply open it in Word or WordPad and save as a text file. You can then easily imported it into Excel and manipulated via it's database functions such as sort which can be on any single or combination of columns.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Doug McKay
Sent: Monday, November 05, 2001 2:49 PM
To: [EMAIL PROTECTED]
Subject: RE: [LegacyUG] Creating date-sorted 'shopping lists'

If you use the File | Export function to save to a Clooz file, you'll get data in this format:

PersonID,Surname,Given,BirthYear,MarriageYear,DeathYear
1,Kennedy,Joseph Patrick,6 Sep 1888,7 Oct 1914,18 Nov 1969
2,Fitzgerald,Rose,22 Jul 1890,7 Oct 1914,22 Jan 1995
3,Kennedy,Joseph Patrick Jr.,Jul 1915,,2 Aug 1944

It may not have all of the data you're after, but it's a start.

   ...Doug

-----Original Message-----
From: John_Evans [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 05, 2001 1:29 PM
To: [EMAIL PROTECTED]
Subject: [LegacyUG] Creating date-sorted 'shopping lists'

Greetings,

What I'd like to do is create a printout or report from a created list of folks, say, in a certain locale, and have the list sorted by birth date, or burial date, for example, so I can then use this 'date sorted list' as a shopping list when perusing newspaper films or other date ordered sources.

I will continue to play with printing to a generic text only file and then sort the data externally myself. Plus, I have submitted a suggestion to Millennia and asked for the ability to export data to a comma-delimited file or worksheet that Lotus or Excel could then manipulate.

Anyone else dealt with this type of problem and come up with a solution??

tnx,
john

To unsubscribe: http://www.legacyfamilytree.com/LegacyLists.asp