Re: [LegacyUG] Children
Thank you all for your responses to my posting. I will also make a Children suggestion, piggybacking on Ron Taylor's posting: 1In Marriage, add the total number of children in a data box (if known). Legacy program to display the current number of children. 2In the Edit Children window, Legacy program to include Death Date column. Add an optional research date in a data box (remember the last used date). Legacy program to display number of current children to marriage and alive at that research date, and the total number of children from the marriage data box. 3Family window to include Children numbers (with or without names) up to the number in the data box, with the click to add in the next unrecorded line. 4Family Group Records (and similar) to include a line for every child recorded and additional numbered blank lines up to the total number in the data box. In the meantime I have decided to use [[private notes]] (eg [[4 children]]) in the Marriage Notes. This way there is minimal input effort, and minimal clean-up required, and no mess (eg confusion, redundancy etc) if the note is left after the children have been entered, in part or in total. The down side is that I will be relying on the Marriage Note highlight to remind me of what I have done, and there is no clear indication of the children on the Family screen. And I will wait for Legacy to add a children number feature! Cheers, Brett B McL Robinson Tel +64 7 856 6582, 0277 500 714, fax +64 7 856 6582, Skype AB1252 PO Box 1252, Hamilton 3240, New Zealand (abridged) On 1/08/2014 8:42 a.m., Ron Taylor wrote: Submitted...hope it gets implemented. On Thursday, July 31, 2014 12:40 PM, Larry Lee ldlee...@gmail.com wrote: Ron, I like the idea and think you should submit it. The only addition I would like to see is to have a related field for Surety since the number is only as reliable as the source as is all data in the file. Larry On Jul 30, 2014 6:46 AM, Ron Taylor doit4...@yahoo.com mailto:doit4...@yahoo.com wrote: This is an area that has not been programmed into Legacy (yet). It would be nice if the marriage record had a numberic field to record how many children were from the union. It could default to -1 to indicate that the value was never set. If the number of children is not -1, then the computer could tally the actual number in the database and compare it with the expected count to produce a Potential Problem alert. A zero should coincide with This couple had no children being checked. A census shows that there were 7 children with 4 living but the database only has 3...alert, 4 children are probably missing. An obituary shows 5 children but 6 are in the database...alert, more children recorded than source indicates. Many other combinations could be detected but the obvious one is the situation described by Brett in this thread. If the Legacy user does not want to use the feature, it would just be left at the default and bypassed by reports and exports. Ron Taylor Original message From: Brett McL Robinson Date:07/30/2014 5:07 AM (GMT-05:00) To: legacyusergroup@LegacyUsers.com mailto:legacyusergroup@LegacyUsers.com Subject: [LegacyUG] Children I have been adding family details and have several families where my source (a descendant of one of the families) has merely noted the number of children, with no names. I am tempted to ignore the number, but realise that it would be useful to note it with the family to help as a check in the future. Is there any way to add a number to the family records that will show up in the children display? I tried adding an unknown gender child named Given: 4 children (Colin+Karen) (for example), and wonder if anyone has tried this or something like it and can report on its success or limitations. This child would be over-written when the last child was added. -- Cheers, Brett Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
[LegacyUG] Ancestors and descendants listings
I am trying to produce separate reports (as noted above) which includes every individual - person, parents, children, brothers, sisters, aunts, uncles, etc. This may not be very clear, however, when I prepare these reports, I want every person in my data base with any connection to be listed on the reports. Any suggestions would be appreciated. Ed Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Ancestors and descendants listings
Ed, You can do this with the Family Group or Individual Reports. Click on the Record Selection button at the bottom of the main window for those reports to select everyone or a tagged or focus group. Sincerely, Sherry Technical Support Legacy Family Tree On Fri, Aug 1, 2014 at 6:00 AM, Ed Newman em...@comcast.net wrote: I am trying to produce separate reports (as noted above) which includes “every individual – person, parents, children, brothers, sisters, aunts, uncles, etc. This may not be very clear, however, when I prepare these reports, I want every person in my data base with any connection to be listed on the reports. Any suggestions would be appreciated. Ed Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Ancestors and descendants listings
Sherry I do understand those options, however I was wanting to have the reports in a narrative form! Any chance of making that work? Ed From: Sherry/Support [mailto:she...@legacyfamilytree.com] Sent: Friday, August 01, 2014 10:52 AM To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] Ancestors and descendants listings Ed, You can do this with the Family Group or Individual Reports. Click on the Record Selection button at the bottom of the main window for those reports to select everyone or a tagged or focus group. Sincerely, Sherry Technical Support Legacy Family Tree On Fri, Aug 1, 2014 at 6:00 AM, Ed Newman em...@comcast.net wrote: I am trying to produce separate reports (as noted above) which includes “every individual – person, parents, children, brothers, sisters, aunts, uncles, etc. This may not be very clear, however, when I prepare these reports, I want every person in my data base with any connection to be listed on the reports. Any suggestions would be appreciated. Ed Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Geo_code places How to review large numbers for correct placement
Aha! Too many variables these days; Hadn't seen just the word (City) in parens. Yes, thanks, that's in there in my old version. Cheryl Ron Taylor wrote: This entry is in v7.5 and v8 Winchester, Winchester (City), Virginia, United States On Thursday, July 31, 2014 7:33 PM, BobsTree2-Gmail bobstr...@gmail.com wrote: A few questions as I ponder the options ... 1. If a tool could flag a certain variance from Google, would that help? 2. Why should Google be the standard, assumed correct? 3. How about a tool that got the Google value and over writes the Legacy value, or gives a choice to choose between them? Bob Hansen On Jul 31, 2014, at 19:22, Jay 1FamilyTree 1familytree@gmail.com mailto:1familytree@gmail.com wrote: Anyone have any workable solutions? Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Geo_code places How to review large numbers for correct placement
For the US, that sole-source would most likely be the GNIS link I included. I've always found it more useful than the other mapping sources...and, it gives you both pairs of coordinates, no translating needed. Cheryl Ron Taylor wrote: So, instead of every one of us trying to verify every location in our master location list...wouldn't it be a good idea if we had a known-to-be-correct locations table that might verify a majority of the entries in our individual files? Users like CE Wood could indicate that a location is good or bad and over time those locations with the most good votes should rise to the top and the ones with the most bad votes should drop. The ones left in the middle will need some serious arbitration. Zero votes means nobody is working on that location. Later, add the castles, churches, hospitals, cemeteries, etc. Ron Taylor On Thursday, July 31, 2014 8:53 PM, CE WOOD wood...@msn.com wrote: I *_never _*use just one mapping source. With Google, one has the ability to move the arrow if it, for instance, is not precisely on the right spot, and give you the coordinates of the spot to which you moved the cursor. Bing, in Legacy, will do that too, but gives the coordinates in degrees, minutes, seconds. Unfortunately, the Legacy converter is not always accurate. Bing maps itself will not allow you to move the cursor and get the coordinates for the new pinpoint. Microsoft has told me they don't know why the difference between Legacy Bing maps and internet Bing maps. Check, check, recheck. Many sites, such as Find A Grave, require decimal coordinates, and the Legacy converter does not always convert correctly. I have double checked the Legacy converted decimal coordinates, and often found they did not put the cursor correctly. You can always overwrite whatever coordinates you already have found (the Legacy converter seems to be precise going from decimal to degrees, just not the other way, but be sure to save the original Legacy coordinates somewhere until you like how the map looks. Bottom line: if you really want the exact coordinates, you must double, triple, and sometimes quadruple check. When I view the map of a church, castle, etc., I want to see the church, castle, etc. or its ruins. For a town, I am more sanguine. CE From: bobstr...@gmail.com To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] Geo_code places How to review large numbers for correct placement Date: Thu, 31 Jul 2014 21:32:43 -0400 A few questions as I ponder the options ... 1. If a tool could flag a certain variance from Google, would that help? 2. Why should Google be the standard, assumed correct? 3. How about a tool that got the Google value and over writes the Legacy value, or gives a choice to choose between them? Bob Hansen On Jul 31, 2014, at 19:22, Jay 1FamilyTree 1familytree@gmail.com wrote: Anyone have any workable solutions? Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Prepositions for locations- Family View and Family Group Records ?
I know there are those on this list who will shoot down this idea quickly and
vehemently, but...
Have you thought of using the Address field?
I used to do this to indicate probably or add on the farm... that was
awhile ago, so my memory is fuzzy.
I have seen many, many threads here discussing the use of locations and
addresses so I won't go into details (you can search the archives) don't
need to hear both sides again. ;)
I'm not sure it would work for John's Poland/Russia examples, but maybe for
Ron's Salt Lake City examples? Especially if there is a known city used in
most cases you just have a few cases of near to indicate...?
You would need to try it on a field or two run some reports to see if you
like the format.
This approach would probably not work for someone who uses the Address table
for addresses. ;) ...or maybe it would?
Legacy is flexible; I'm just offering up another table/place to be flexible.
--Paula
From: johnbernac...@iprimus.com.au johnbernac...@iprimus.com.au
To: legacyusergroup@LegacyUsers.com
Sent: Wednesday, July 30, 2014 10:43 PM
Subject: Re: [LegacyUG] Prepositions for locations- Family View and Family
Group Records ?
Hi Ron,
I have been doing something
similar to you but I am trying to minimise the number variations of the same
location in the Master Location List e.g.
Sitaniec, Zamość, Crown
Province of Galicia, Habsburg Empire
Sitaniec, Zamość, Lublin,
Duchy of Warsaw
Sitaniec, Zamość, Lublin,
Kingdom of Poland ('Russian Poland')
Sitaniec, Zamość, Lublin,
Republic of Poland
of Sitaniec, Zamość,
Lublin, Kingdom of Poland ('Russian Poland')
of Sitaniec, Zamość,
Lublin, Republic of Poland
I am trying to make my
family history story very readable and presented elegantly without sacrificing
accuracy or details, so I am conscious that my Location Index may be confusing
for readers, especially with modifiers.
I think what I would need
is another field, where you add Individuals’ Information to the Family View (and
Family Group Reports). This could be an optional drop down field (probably
placed below “Christened”) and where you could add your own element e.g.
“Earliest Known Residence” or whatever individual Legacy users may want. I
realize such information could be added as an Event or in notes, but it would
much more convenient for me while researching, or for readers of my family
history, to immediately see
accurate details about each person without having to dig for it.
John
From: Ron Taylor
Sent: Wednesday, July 30, 2014 11:33 PM
To: legacyusergroup@LegacyUsers.com
Subject: Re: [LegacyUG] Prepositions for locations- Family View and
Family Group Records ?
John,
If
you add the modifiers to the Master Location List and link your individual
records to those modified locations, they should show in the reports and
elsewhere. Look at the examples I gave of Salt Lake City. Those are
actual entries in my Master Locations List.
Ron
Taylor
On Wednesday, July 30, 2014 4:30 AM,
johnbernac...@iprimus.com.au johnbernac...@iprimus.com.au
wrote:
It seems that adding prepositions or modifiers at the
end of locations and adding them as new entries to the Master Location List is
the best I can do for my database purposes, at least for now. I eventually want
to include a number of Family Group Records as ‘Family Story’ chapters in a
book. I will have to convert them to a word document, and then add the
prepositions or modifiers before publishing it.
From: Ron Taylor
Sent: Wednesday, July 30, 2014 12:22 AM
To: legacyusergroup@LegacyUsers.com
Subject: Re: [LegacyUG] Prepositions for locations- Family View and
Family Group Records ?
There is a field in the tblLR (Master Locations Table) called
Preposition which can be set and used in reports as you described. There
is also a file C:\...Documents\Legacy Family
Tree\_AppData\Misc\Preposition_English.lst which is used by the Master Locations
List to sort locations. It does it by removing the words in that file from
the location, putting it on the end of the location name, then sorting the list
so that all locations that are the same will display next to each other and the
preposition tacked onto the end. That is helpful. Some of the
entries in that list are not actually prepositions. In fact, some of
the entries are multiple words. I think a better term for them would be
location modifiers instead of prepositions.
What
would be great but would require some extensive re-writing would be to have an
actual database table of location modifiers. That table could come into
play as a pull down list (similar to Child Status, Event Type, Surname List,
etc.) where you can select the location modifier to be applied to a specific
location field. That would mean that a location modifier key field be
inserted into every table where a link to the tblLR is used. The
preposition field that is in tblLR would only be used for reports when the
location modifier is blank. The main effect that a
Re: [LegacyUG] Children
Ruff and Bick -- love it! ;) From: singhals singh...@erols.com To: legacyusergroup@LegacyUsers.com Sent: Wednesday, July 30, 2014 5:11 PM Subject: Re: [LegacyUG] Children Jessica Morgan wrote: Thanks for the thumbs up. Someone else stated that it wasn't wise to number the children, because it could be in error. I Yes, of course it could be in error. OTOH, I've had experiences where we knew there were 6 children but 8 names were cited in an obit...turned out that Ruff and Melanie were the same person and Bick and Leonard were the same person. snip Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Ancestors and descendants listings
Sherry, I jumped to conclusions too quickly. Thanks for the info. From: Sherry/Support [mailto:she...@legacyfamilytree.com] Sent: Friday, August 01, 2014 10:52 AM To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] Ancestors and descendants listings Ed, You can do this with the Family Group or Individual Reports. Click on the Record Selection button at the bottom of the main window for those reports to select everyone or a tagged or focus group. Sincerely, Sherry Technical Support Legacy Family Tree On Fri, Aug 1, 2014 at 6:00 AM, Ed Newman em...@comcast.net wrote: I am trying to produce separate reports (as noted above) which includes “every individual – person, parents, children, brothers, sisters, aunts, uncles, etc. This may not be very clear, however, when I prepare these reports, I want every person in my data base with any connection to be listed on the reports. Any suggestions would be appreciated. Ed Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Ancestors and descendants listings
Ed, There is one called Multiple Lines of Descent. You would have to read the Help. I am not familiar with it, but I have seen it recommended here when someone asked for an everyone report. Are you on 7.5 or 8.0? How many individuals are we talking about here? 1000? 100,000? For me, I could run an Ancestor Book Report starting with my daughter and get just about everyone in an inverted triangle... know what I mean? Then, I could run Descendant Books ( or Desc. Narratives) starting with the oldest ancestors. Lots of redundancy, but (in my case) I would see all my daughter's 2nd, 3rd, 4th, etc. cousins (that I know about have entered). Now... these are not narrative in the sense that you could read it like a book (even if you choose the right event print options)... What are you really trying to DO? What do you need the report or data FOR? ;) We have folks here who have done it all and done a lot of unique reporting. But sometimes we need more information. Thanks, --Paula From: Ed Newman em...@comcast.net To: legacyusergroup@LegacyUsers.com Sent: Friday, August 1, 2014 8:00 AM Subject: [LegacyUG] Ancestors and descendants listings I am trying to produce separate reports (as noted above) which includes “every individual – person, parents, children, brothers, sisters, aunts, uncles, etc. This may not be very clear, however, when I prepare these reports, I want every person in my data base with any connection to be listed on the reports. Any suggestions would be appreciated. Ed Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] SQL Queries Library
Larry LTools has a wide selection of SQL routines. Ron Ferguson Sent from my Xperia™ smartphone Larry Lee ldlee...@gmail.com wrote: I renamed this to SQL Queries Library. I know what SQL Queries are but I do not know how they are used with Legacy and if they would have much demand. Is this something that is appropriate for only advanced users? Jay, if you feel this would be useful maybe you could maintain an online library for these as I doubt Millennia would officially sanction support them. Larry On Jul 16, 2014 2:24 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: Ron, Not sure why your emails keep ending up in my spam folder.. Anyway, there is a reason, Many years ago I had Dennis at LTools create a process to automatically add spouses and parents to my database. (see the Create spouses option in LTools) That worked fine, but as the years have gone by, I realized that the process was a bit too much. I should have limited it to specific descendant lines and not the entire database. So, I have these parents out there, most all are UnknownM (Surname) + UnknownF Unknown that are not really needed, as maybe they are the parents of an aunt or cousin. I want to 'trim' those from the database. But, some of the parents have a second child married into the database, in which case I want to keep them (in order to preserve the relationships) Hence, the search for parents with only one child. Your code worked well and provides a list from which I can use to review and delete the couple if appropriate. Which just helps to keep my database relevant and compact. I really wish Legacy would have a central page where the various SQL queries could be posted for all to share and use. Thanks for your help!! Jay On Fri, Jul 11, 2014 at 7:01 AM, Ron Taylor doit4...@yahoo.com wrote: Jay, I'm wondering what prompted you to search for this combination. What are you trying to solve? Ron Taylor On Wednesday, July 9, 2014 8:33 AM, Ron Taylor doit4...@yahoo.com wrote: This one could be fun. 1) Clear tag1 2) use LegacySearchFindMiscellaneousLinked individuals with no parents then click Clear List before this search and click Create List. When then search results list is displayed, click OptionsAdvanced TaggingTag and make changes to tag1. Click Everyone in Search List. Now all individuals without parents have tag1. 3) Create and save the following query which will be used in step4. Name it qtblMR_parents_eol SELECT DISTINCT tblCR.IDMR FROM ((tblCR INNER JOIN tblMR ON tblCR.IDMR=tblMR.IDMR) INNER JOIN tblIR ON tblMR.IDIRHusb=tblIR.IDIR) INNER JOIN tblIR AS tblIR_1 ON tblMR.IDIRWife=tblIR_1.IDIR WHERE (((tblCR.IDMR)0) AND ((tblIR.Tag1)0) AND ((tblIR_1.Tag1)0) AND ((tblMR.IDIRHusb)0) AND ((tblMR.IDIRWife)0)); 4) Run this query to find the marriage records to answer your question. SELECT tblCR.IDMR, Count(tblCR.IDIR) AS Children FROM qtblMR_parents_eol INNER JOIN tblCR ON qtblMR_parents_eol.IDMR = tblCR.IDMR GROUP BY tblCR.IDMR HAVING (((Count(tblCR.IDIR))=1)) ORDER BY tblCR.IDMR; Let me know if this is what you needed. Note you could tweak the Having number of children as desired. Ron Taylor On Tuesday, July 8, 2014 8:33 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: I would like to create a report of all parents that only have one child AND the parents have no father or mother in my database. If any great sql coders could help me out, that would be great. Thanks Jay Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009:
Re: [LegacyUG] Prepositions for locations- Family View and Family Group Records ?
Wow, thank you Paula! I have rediscovered the Address field! I had completely
forgotten about it as I only ever used it a few times, a number of years ago,
but did not find it useful for my purposes. I did not even realise Address
could be displayed in book reports or Family Group Records. As you suggested, I
played around with it and think I can use it to meet my needs- to comment on
locations, rather than adding locations in the Address field. It does not
display in the Family View but I think I can live with that.
I use another database for addresses of living cousins, and it is very rare to
get an address of ancestors from hamlets or villages in Europe. Occasionally I
get something like “house 18”. Therefore the Address field is freely available
for other uses.
I agree with Paula- software such as Legacy is to be used however one wants or
needs. Legacy is very flexible but all programs have limitations so users may
need to “think outside the box”.
John
From: Paula Ryburn
Sent: Saturday, August 02, 2014 5:24 AM
To: legacyusergroup@LegacyUsers.com
Subject: Re: [LegacyUG] Prepositions for locations- Family View and Family
Group Records ?
I know there are those on this list who will shoot down this idea quickly and
vehemently, but...
Have you thought of using the Address field?
I used to do this to indicate probably or add on the farm... that was
awhile ago, so my memory is fuzzy.
I have seen many, many threads here discussing the use of locations and
addresses so I won't go into details (you can search the archives) don't
need to hear both sides again. ;)
I'm not sure it would work for John's Poland/Russia examples, but maybe for
Ron's Salt Lake City examples? Especially if there is a known city used in
most cases you just have a few cases of near to indicate...?
You would need to try it on a field or two run some reports to see if you
like the format.
This approach would probably not work for someone who uses the Address table
for addresses. ;) ...or maybe it would?
Legacy is flexible; I'm just offering up another table/place to be flexible.
--Paula
From: johnbernac...@iprimus.com.au johnbernac...@iprimus.com.au
To: legacyusergroup@LegacyUsers.com
Sent: Wednesday, July 30, 2014 10:43 PM
Subject: Re: [LegacyUG] Prepositions for locations- Family View and Family
Group Records ?
Hi Ron,
I have been doing something similar to you but I am trying to minimise the
number variations of the same location in the Master Location List e.g.
Sitaniec, Zamość, Crown Province of Galicia, Habsburg Empire
Sitaniec, Zamość, Lublin, Duchy of Warsaw
Sitaniec, Zamość, Lublin, Kingdom of Poland ('Russian Poland')
Sitaniec, Zamość, Lublin, Republic of Poland
of Sitaniec, Zamość, Lublin, Kingdom of Poland ('Russian Poland')
of Sitaniec, Zamość, Lublin, Republic of Poland
I am trying to make my family history story very readable and presented
elegantly without sacrificing accuracy or details, so I am conscious that my
Location Index may be confusing for readers, especially with modifiers.
I think what I would need is another field, where you add Individuals’
Information to the Family View (and Family Group Reports). This could be an
optional drop down field (probably placed below “Christened”) and where you
could add your own element e.g. “Earliest Known Residence” or whatever
individual Legacy users may want. I realize such information could be added as
an Event or in notes, but it would much more convenient for me while
researching, or for readers of my family history, to immediately see accurate
details about each person without having to dig for it.
John
From: Ron Taylor
Sent: Wednesday, July 30, 2014 11:33 PM
To: legacyusergroup@LegacyUsers.com
Subject: Re: [LegacyUG] Prepositions for locations- Family View and Family
Group Records ?
John,
If you add the modifiers to the Master Location List and link your individual
records to those modified locations, they should show in the reports and
elsewhere. Look at the examples I gave of Salt Lake City. Those are actual
entries in my Master Locations List.
Ron Taylor
On Wednesday, July 30, 2014 4:30 AM, johnbernac...@iprimus.com.au
johnbernac...@iprimus.com.au wrote:
It seems that adding prepositions or modifiers at the end of locations and
adding them as new entries to the Master Location List is the best I can do for
my database purposes, at least for now. I eventually want to include a number
of Family Group Records as ‘Family Story’ chapters in a book. I will have to
convert them to a word document, and then add the prepositions or modifiers
before publishing it.
From: Ron Taylor
Sent: Wednesday, July 30, 2014 12:22 AM
To: legacyusergroup@LegacyUsers.com
Subject: Re: [LegacyUG] Prepositions for locations- Family View and Family
Group Records ?
There is a field in the tblLR (Master Locations Table) called Preposition which
Re: [LegacyUG] SQL Queries Library
Larry and all, I would be willing to help start the files, but the actual local master and primary admin rights should probably be somewhere more centrally located, like an Legacy Wiki page, If they have such a thing. Millenia isn' t very current on things like that. If anyone has a good suggestion as to where to place the content, let me know. In the meantime I will gather my own little list of often useful SQL Queries. Thanks Jay . On Thu, Jul 31, 2014 at 12:22 PM, Ron Ferguson ronfergy@tiscali.co.uk wrote: Larry LTools has a wide selection of SQL routines. Ron Ferguson Sent from my Xperia™ smartphone Larry Lee ldlee...@gmail.com wrote: I renamed this to SQL Queries Library. I know what SQL Queries are but I do not know how they are used with Legacy and if they would have much demand. Is this something that is appropriate for only advanced users? Jay, if you feel this would be useful maybe you could maintain an online library for these as I doubt Millennia would officially sanction support them. Larry On Jul 16, 2014 2:24 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: Ron, Not sure why your emails keep ending up in my spam folder.. Anyway, there is a reason, Many years ago I had Dennis at LTools create a process to automatically add spouses and parents to my database. (see the Create spouses option in LTools) That worked fine, but as the years have gone by, I realized that the process was a bit too much. I should have limited it to specific descendant lines and not the entire database. So, I have these parents out there, most all are UnknownM (Surname) + UnknownF Unknown that are not really needed, as maybe they are the parents of an aunt or cousin. I want to 'trim' those from the database. But, some of the parents have a second child married into the database, in which case I want to keep them (in order to preserve the relationships) Hence, the search for parents with only one child. Your code worked well and provides a list from which I can use to review and delete the couple if appropriate. Which just helps to keep my database relevant and compact. I really wish Legacy would have a central page where the various SQL queries could be posted for all to share and use. Thanks for your help!! Jay On Fri, Jul 11, 2014 at 7:01 AM, Ron Taylor doit4...@yahoo.com wrote: Jay, I'm wondering what prompted you to search for this combination. What are you trying to solve? Ron Taylor On Wednesday, July 9, 2014 8:33 AM, Ron Taylor doit4...@yahoo.com wrote: This one could be fun. 1) Clear tag1 2) use LegacySearchFindMiscellaneousLinked individuals with no parents then click Clear List before this search and click Create List. When then search results list is displayed, click OptionsAdvanced TaggingTag and make changes to tag1. Click Everyone in Search List. Now all individuals without parents have tag1. 3) Create and save the following query which will be used in step4. Name it qtblMR_parents_eol SELECT DISTINCT tblCR.IDMR FROM ((tblCR INNER JOIN tblMR ON tblCR.IDMR=tblMR.IDMR) INNER JOIN tblIR ON tblMR.IDIRHusb=tblIR.IDIR) INNER JOIN tblIR AS tblIR_1 ON tblMR.IDIRWife=tblIR_1.IDIR WHERE (((tblCR.IDMR)0) AND ((tblIR.Tag1)0) AND ((tblIR_1.Tag1)0) AND ((tblMR.IDIRHusb)0) AND ((tblMR.IDIRWife)0)); 4) Run this query to find the marriage records to answer your question. SELECT tblCR.IDMR, Count(tblCR.IDIR) AS Children FROM qtblMR_parents_eol INNER JOIN tblCR ON qtblMR_parents_eol.IDMR = tblCR.IDMR GROUP BY tblCR.IDMR HAVING (((Count(tblCR.IDIR))=1)) ORDER BY tblCR.IDMR; Let me know if this is what you needed. Note you could tweak the Having number of children as desired. Ron Taylor On Tuesday, July 8, 2014 8:33 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: I would like to create a report of all parents that only have one child AND the parents have no father or mother in my database. If any great sql coders could help me out, that would be great. Thanks Jay Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online
RE: [LegacyUG] pictures
Ron, thanks for the informed answer. It makes a little more sense now. You are saying I can create a folder, I am assuming in Legacy, in which to place all of my media and Legacy will recognize and locate it at the appropriate time. Should I place all of the media I have previously linked in there, transferring from their location to the new one? Will I have to relink again after doing so? Thanks again for your response. Donna From: Ron Taylor [mailto:doit4...@yahoo.com] Sent: Thursday, July 31, 2014 7:37 PM To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] pictures Donna, You may have been linking to media files that were inside a zipped file which is a special kind of folder. That method was addressed recently by some users on this group and it helped to resolve several problems. The conclusion was to not do that. Always link to media that is not in a compressed folder. Other than that, you can place your media files just about anywhere you wish, link to them, and be happy. I like to put my media files in a root level folder because I collaborate with several other researchers. Some of those researchers still use Windows XP while others use Vista, Windows7, and Windows8. With a root level folder like C:\Collaborator1 it is easy for collaborator 1 to put whatever media they want in that folder and not be concerned with other collaborators messing with their collection. Collaborator2 likewise has their own collection folder and so forth. The collaborators can make any sub-folders they need under their root level folder. The Legacy backup of media only puts the media files into the backup for the database being backed up. The only precaution with this method is to not use the Gather Media routine as it will move all the media to some other location regardless of the various collaborators who collected it and kept it separately. The Gather routine probably does work for a single researcher that does not collaborate. Ron Taylor On Thursday, July 31, 2014 1:12 PM, Donna Newell djnewel...@gmail.com wrote: I am trying to save a picture of a census record to Legacy 8. In Legacy 7 my folder on the drive I used looked like this: 1 Legacy12/29/2012 3:57 PM File folder 1 Irwin 2014-07-08 1,48.48 PM 7/8/2014 1:48 PM Compressed (zipped) Folder I could click on Legacy and it would open to: 1 Pictures 12/29/2012 3:55 PM File folder Which I then could click and it would open to smaller folders and pictures that I had stored for my data base. In Legacy 8 I am unable to do that. There is no Legacy folder, only the name folders and media folders. There is one labeled with a circle and an L in the middle with 11,448 KB in it, plus an Microsoft Assess Record-Locking Information icon with 0 KB in it. I would before save the picture to my computer, then copy it to the folder with Pictures and from there go to the Picture Center and find the picture in the Browse slot. Now I cannot find where to put the picture to load it into Legacy. I would like someone to help me out. Donna in Ardmore Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] pictures
You could put all the pictures in one folder or put them in any structure of folders and sub-folders you wish. Then run the Relinker. If the actual file names have not changed, the Relinker should be able to find them and fix the link to them. Once you have all media relinked, then you can backup the data and media. Delete the media folders if you don't need the pictures for anything else. Then unzip the backup media file to the C:\ and it will lay down the folders and files as they were at the time of the backup. Only the linked files will be in the backup. So, if you had 10,000 picture files that you copied from the Mac to the PC and only 5,000 of them were linked to the Reunions file, you should only have 5,000 on the PC when you finish with the Relinker, Backup, Delete, and restore. Ron Taylor On Friday, August 1, 2014 7:54 PM, Donna Newell djnewel...@gmail.com wrote: Ron, thanks for the informed answer. It makes a little more sense now. You are saying I can create a folder, I am assuming in Legacy, in which to place all of my media and Legacy will recognize and locate it at the appropriate time. Should I place all of the media I have previously linked in there, transferring from their location to the new one? Will I have to relink again after doing so? Thanks again for your response. Donna From:Ron Taylor [mailto:doit4...@yahoo.com] Sent: Thursday, July 31, 2014 7:37 PM To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] pictures Donna, You may have been linking to media files that were inside a zipped file which is a special kind of folder. That method was addressed recently by some users on this group and it helped to resolve several problems. The conclusion was to not do that. Always link to media that is not in a compressed folder. Other than that, you can place your media files just about anywhere you wish, link to them, and be happy. I like to put my media files in a root level folder because I collaborate with several other researchers. Some of those researchers still use Windows XP while others use Vista, Windows7, and Windows8. With a root level folder like C:\Collaborator1 it is easy for collaborator 1 to put whatever media they want in that folder and not be concerned with other collaborators messing with their collection. Collaborator2 likewise has their own collection folder and so forth. The collaborators can make any sub-folders they need under their root level folder. The Legacy backup of media only puts the media files into the backup for the database being backed up. The only precaution with this method is to not use the Gather Media routine as it will move all the media to some other location regardless of the various collaborators who collected it and kept it separately. The Gather routine probably does work for a single researcher that does not collaborate. Ron Taylor On Thursday, July 31, 2014 1:12 PM, Donna Newell djnewel...@gmail.com wrote: I am trying to save a picture of a census record to Legacy 8. In Legacy 7 my folder on the drive I used looked like this: 1 Legacy 12/29/2012 3:57 PM File folder 1 Irwin 2014-07-08 1,48.48 PM 7/8/2014 1:48 PM Compressed (zipped) Folder I could click on Legacy and it would open to: 1 Pictures 12/29/2012 3:55 PM File folder Which I then could click and it would open to smaller folders and pictures that I had stored for my data base. In Legacy 8 I am unable to do that. There is no Legacy folder, only the name folders and media folders. There is one labeled with a circle and an L in the middle with 11,448 KB in it, plus an Microsoft Assess Record-Locking Information icon with 0 KB in it. I would before save the picture to my computer, then copy it to the folder with Pictures and from there go to the Picture Center and find the picture in the Browse slot. Now I cannot find where to put the picture to load it into Legacy. I would like someone to help me out. Donna in Ardmore Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical
Re: [LegacyUG] SQL Queries Library
Simple place to start would be a Google shared folder. Each file in the folder should be descriptively named and there should be one Index file in the folder also that could list all the files and include a short summary of how the routine is used and maybe a little about why it was developed. I have quite a few scripts that I am willing to share also. They can all be loaded into Ltools and run from it. Handy if someone does not have their own copy of Microsoft Access or is unfamiliar with some of the other free database tools like LibreOffice or OpenOffice. Ron Taylor On Friday, August 1, 2014 7:18 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: Larry and all, I would be willing to help start the files, but the actual local master and primary admin rights should probably be somewhere more centrally located, like an Legacy Wiki page, If they have such a thing. Millenia isn' t very current on things like that. If anyone has a good suggestion as to where to place the content, let me know. In the meantime I will gather my own little list of often useful SQL Queries. Thanks Jay . On Thu, Jul 31, 2014 at 12:22 PM, Ron Ferguson ronfergy@tiscali.co.uk wrote: Larry LTools has a wide selection of SQL routines. Ron Ferguson Sent from my Xperia™ smartphone Larry Lee ldlee...@gmail.com wrote: I renamed this to SQL Queries Library. I know what SQL Queries are but I do not know how they are used with Legacy and if they would have much demand. Is this something that is appropriate for only advanced users? Jay, if you feel this would be useful maybe you could maintain an online library for these as I doubt Millennia would officially sanction support them. Larry On Jul 16, 2014 2:24 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: Ron, Not sure why your emails keep ending up in my spam folder.. Anyway, there is a reason, Many years ago I had Dennis at LTools create a process to automatically add spouses and parents to my database. (see the Create spouses option in LTools) That worked fine, but as the years have gone by, I realized that the process was a bit too much. I should have limited it to specific descendant lines and not the entire database. So, I have these parents out there, most all are UnknownM (Surname) + UnknownF Unknown that are not really needed, as maybe they are the parents of an aunt or cousin. I want to 'trim' those from the database. But, some of the parents have a second child married into the database, in which case I want to keep them (in order to preserve the relationships) Hence, the search for parents with only one child. Your code worked well and provides a list from which I can use to review and delete the couple if appropriate. Which just helps to keep my database relevant and compact. I really wish Legacy would have a central page where the various SQL queries could be posted for all to share and use. Thanks for your help!! Jay On Fri, Jul 11, 2014 at 7:01 AM, Ron Taylor doit4...@yahoo.com wrote: Jay, I'm wondering what prompted you to search for this combination. What are you trying to solve? Ron Taylor On Wednesday, July 9, 2014 8:33 AM, Ron Taylor doit4...@yahoo.com wrote: This one could be fun. 1) Clear tag1 2) use LegacySearchFindMiscellaneousLinked individuals with no parents then click Clear List before this search and click Create List. When then search results list is displayed, click OptionsAdvanced TaggingTag and make changes to tag1. Click Everyone in Search List. Now all individuals without parents have tag1. 3) Create and save the following query which will be used in step4. Name it qtblMR_parents_eol SELECT DISTINCT tblCR.IDMR FROM ((tblCR INNER JOIN tblMR ON tblCR.IDMR=tblMR.IDMR) INNER JOIN tblIR ON tblMR.IDIRHusb=tblIR.IDIR) INNER JOIN tblIR AS tblIR_1 ON tblMR.IDIRWife=tblIR_1.IDIR WHERE (((tblCR.IDMR)0) AND ((tblIR.Tag1)0) AND ((tblIR_1.Tag1)0) AND ((tblMR.IDIRHusb)0) AND ((tblMR.IDIRWife)0)); 4) Run this query to find the marriage records to answer your question. SELECT tblCR.IDMR, Count(tblCR.IDIR) AS Children FROM qtblMR_parents_eol INNER JOIN tblCR ON qtblMR_parents_eol.IDMR = tblCR.IDMR GROUP BY tblCR.IDMR HAVING (((Count(tblCR.IDIR))=1)) ORDER BY tblCR.IDMR; Let me know if this is what you needed. Note you could tweak the Having number of children as desired. Ron Taylor On Tuesday, July 8, 2014 8:33 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: I would like to create a report of all parents that only have one child AND the parents have no father or mother in my database. If any great sql coders could help me out, that would be great. Thanks Jay Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail
Re: [LegacyUG] SQL Queries Library
Ok how do I use these SQL code modules with Legacy? Or are they only used with Access? It's been 15 years since I used it routinely. On Aug 1, 2014 6:20 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: Larry and all, I would be willing to help start the files, but the actual local master and primary admin rights should probably be somewhere more centrally located, like an Legacy Wiki page, If they have such a thing. Millenia isn' t very current on things like that. If anyone has a good suggestion as to where to place the content, let me know. In the meantime I will gather my own little list of often useful SQL Queries. Thanks Jay . On Thu, Jul 31, 2014 at 12:22 PM, Ron Ferguson ronfergy@tiscali.co.uk wrote: Larry LTools has a wide selection of SQL routines. Ron Ferguson Sent from my Xperia™ smartphone Larry Lee ldlee...@gmail.com wrote: I renamed this to SQL Queries Library. I know what SQL Queries are but I do not know how they are used with Legacy and if they would have much demand. Is this something that is appropriate for only advanced users? Jay, if you feel this would be useful maybe you could maintain an online library for these as I doubt Millennia would officially sanction support them. Larry On Jul 16, 2014 2:24 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: Ron, Not sure why your emails keep ending up in my spam folder.. Anyway, there is a reason, Many years ago I had Dennis at LTools create a process to automatically add spouses and parents to my database. (see the Create spouses option in LTools) That worked fine, but as the years have gone by, I realized that the process was a bit too much. I should have limited it to specific descendant lines and not the entire database. So, I have these parents out there, most all are UnknownM (Surname) + UnknownF Unknown that are not really needed, as maybe they are the parents of an aunt or cousin. I want to 'trim' those from the database. But, some of the parents have a second child married into the database, in which case I want to keep them (in order to preserve the relationships) Hence, the search for parents with only one child. Your code worked well and provides a list from which I can use to review and delete the couple if appropriate. Which just helps to keep my database relevant and compact. I really wish Legacy would have a central page where the various SQL queries could be posted for all to share and use. Thanks for your help!! Jay On Fri, Jul 11, 2014 at 7:01 AM, Ron Taylor doit4...@yahoo.com wrote: Jay, I'm wondering what prompted you to search for this combination. What are you trying to solve? Ron Taylor On Wednesday, July 9, 2014 8:33 AM, Ron Taylor doit4...@yahoo.com wrote: This one could be fun. 1) Clear tag1 2) use LegacySearchFindMiscellaneousLinked individuals with no parents then click Clear List before this search and click Create List. When then search results list is displayed, click OptionsAdvanced TaggingTag and make changes to tag1. Click Everyone in Search List. Now all individuals without parents have tag1. 3) Create and save the following query which will be used in step4. Name it qtblMR_parents_eol SELECT DISTINCT tblCR.IDMR FROM ((tblCR INNER JOIN tblMR ON tblCR.IDMR=tblMR.IDMR) INNER JOIN tblIR ON tblMR.IDIRHusb=tblIR.IDIR) INNER JOIN tblIR AS tblIR_1 ON tblMR.IDIRWife=tblIR_1.IDIR WHERE (((tblCR.IDMR)0) AND ((tblIR.Tag1)0) AND ((tblIR_1.Tag1)0) AND ((tblMR.IDIRHusb)0) AND ((tblMR.IDIRWife)0)); 4) Run this query to find the marriage records to answer your question. SELECT tblCR.IDMR, Count(tblCR.IDIR) AS Children FROM qtblMR_parents_eol INNER JOIN tblCR ON qtblMR_parents_eol.IDMR = tblCR.IDMR GROUP BY tblCR.IDMR HAVING (((Count(tblCR.IDIR))=1)) ORDER BY tblCR.IDMR; Let me know if this is what you needed. Note you could tweak the Having number of children as desired. Ron Taylor On Tuesday, July 8, 2014 8:33 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: I would like to create a report of all parents that only have one child AND the parents have no father or mother in my database. If any great sql coders could help me out, that would be great. Thanks Jay Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages
[LegacyUG] Backing up family file and what to do with the backup
I understand that it is a good idea to backup my family file on a separate drive. I have been able to do that. It gives the family file name, date and time, and that it is a compressed (zipped) file. When I look in my hard drive, I see files that have a circle at the beginning with an L in it. The file type for those is Legacy Genealogy Software. Then for some of my family files I also have GED, Text Document, and TC files. For some other family files I have those 4 files plus FG file. And for another, those 5 files plus a PPL file. When I am looking at a family file in Legacy and wish to open another family file, I am offered only the circles with the L -- the Legacy Genealogy Software type of files -- not all of the type of files that are in the hard drive. That seems to work and what I have added to a file seems to be there after closing the file and opening it again. * What are all of these files -- GED, Text Document, TC, FG, and PPL ? * At what point do I need to use the compressed (zipped) file and how do I open that ? When I am using family file B and want to go to family file A which I have saved, I look in the other drive and it does not show up. There is no possibility of finding a compressed (zipped) file. That is not a type of file that is listed to open. Also, how many of these zipped files do other people keep? Do you delete some of the older ones after you've saved the next one? Thanks, Priscilla Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] SQL Queries Library
Crossposting. I just saw this after sending my previous post. Would it be possible for Legacy to provide a tool where these could be used from within the program rather than LTools? On Aug 1, 2014 7:49 PM, Larry Lee ldlee...@gmail.com wrote: Ok how do I use these SQL code modules with Legacy? Or are they only used with Access? It's been 15 years since I used it routinely. On Aug 1, 2014 6:20 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: Larry and all, I would be willing to help start the files, but the actual local master and primary admin rights should probably be somewhere more centrally located, like an Legacy Wiki page, If they have such a thing. Millenia isn' t very current on things like that. If anyone has a good suggestion as to where to place the content, let me know. In the meantime I will gather my own little list of often useful SQL Queries. Thanks Jay . On Thu, Jul 31, 2014 at 12:22 PM, Ron Ferguson ronfergy@tiscali.co.uk wrote: Larry LTools has a wide selection of SQL routines. Ron Ferguson Sent from my Xperia™ smartphone Larry Lee ldlee...@gmail.com wrote: I renamed this to SQL Queries Library. I know what SQL Queries are but I do not know how they are used with Legacy and if they would have much demand. Is this something that is appropriate for only advanced users? Jay, if you feel this would be useful maybe you could maintain an online library for these as I doubt Millennia would officially sanction support them. Larry On Jul 16, 2014 2:24 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: Ron, Not sure why your emails keep ending up in my spam folder.. Anyway, there is a reason, Many years ago I had Dennis at LTools create a process to automatically add spouses and parents to my database. (see the Create spouses option in LTools) That worked fine, but as the years have gone by, I realized that the process was a bit too much. I should have limited it to specific descendant lines and not the entire database. So, I have these parents out there, most all are UnknownM (Surname) + UnknownF Unknown that are not really needed, as maybe they are the parents of an aunt or cousin. I want to 'trim' those from the database. But, some of the parents have a second child married into the database, in which case I want to keep them (in order to preserve the relationships) Hence, the search for parents with only one child. Your code worked well and provides a list from which I can use to review and delete the couple if appropriate. Which just helps to keep my database relevant and compact. I really wish Legacy would have a central page where the various SQL queries could be posted for all to share and use. Thanks for your help!! Jay On Fri, Jul 11, 2014 at 7:01 AM, Ron Taylor doit4...@yahoo.com wrote: Jay, I'm wondering what prompted you to search for this combination. What are you trying to solve? Ron Taylor On Wednesday, July 9, 2014 8:33 AM, Ron Taylor doit4...@yahoo.com wrote: This one could be fun. 1) Clear tag1 2) use LegacySearchFindMiscellaneousLinked individuals with no parents then click Clear List before this search and click Create List. When then search results list is displayed, click OptionsAdvanced TaggingTag and make changes to tag1. Click Everyone in Search List. Now all individuals without parents have tag1. 3) Create and save the following query which will be used in step4. Name it qtblMR_parents_eol SELECT DISTINCT tblCR.IDMR FROM ((tblCR INNER JOIN tblMR ON tblCR.IDMR=tblMR.IDMR) INNER JOIN tblIR ON tblMR.IDIRHusb=tblIR.IDIR) INNER JOIN tblIR AS tblIR_1 ON tblMR.IDIRWife=tblIR_1.IDIR WHERE (((tblCR.IDMR)0) AND ((tblIR.Tag1)0) AND ((tblIR_1.Tag1)0) AND ((tblMR.IDIRHusb)0) AND ((tblMR.IDIRWife)0)); 4) Run this query to find the marriage records to answer your question. SELECT tblCR.IDMR, Count(tblCR.IDIR) AS Children FROM qtblMR_parents_eol INNER JOIN tblCR ON qtblMR_parents_eol.IDMR = tblCR.IDMR GROUP BY tblCR.IDMR HAVING (((Count(tblCR.IDIR))=1)) ORDER BY tblCR.IDMR; Let me know if this is what you needed. Note you could tweak the Having number of children as desired. Ron Taylor On Tuesday, July 8, 2014 8:33 PM, Jay 1FamilyTree 1familytree@gmail.com wrote: I would like to create a report of all parents that only have one child AND the parents have no father or mother in my database. If any great sql coders could help me out, that would be great. Thanks Jay Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook
