Re: [LegacyUG] Search
Do a search under Search and Replace : Notes - General Sent from my iPhone > On Apr 9, 2019, at 8:07 PM, Gary Crull wrote: > > Is there any way to perform a search for a particular string/phrase embedded > in the GENERAL Notes section? > > I've used a particular phrase and would like to find, and create a report, of > individuals where I've used that phrase. > > Gary C > -- > > 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] new update
Cathy – The Source List Name is the problem I was referring to. Same problem I had with V.8. However, I just tried to use S with other data fields and they also do not change. Recorded Date and File ID seem to be OK. Don Quigley 945 Halecrest Drive Escondido, CA 92025 (H) 760-746-5887 (M) 925-367-5609 dwquig...@cox.net From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Cathy Pinner Sent: Monday, September 18, 2017 6:04 PM To: Legacy User Group <legacyusergroup@legacyusers.com> Subject: Re: [LegacyUG] new update Donald, What version of Legacy are you using and what build? Which fields are you using for the Search and Replace? There is a known bug with the Source List Name. Just wondering if you're finding a bug in another field. If so, please report as a bug. Cathy Donald Quigley wrote: The S changes get made to the master source on the Master Source List, but when you look for the changes in the Edit view, they have not been made. If you then save the source, the changes go away on the List as well. Donald Quigley Escondido, CA Quigley Doyle Family Tree -Original Message- From: Jenny M Benson [mailto:ge...@cedarbank.me.uk] Sent: Monday, September 18, 2017 9:47 AM To: Donald Quigley<dwquig...@cox.net <mailto:dwquig...@cox.net> > Subject: Re: [LegacyUG] new update O n 18-Sep-17 03:37 PM, Donald Quigley wrote: Yes, but unfortunately it did not fix Issue #7608 - Search& Replace not working for Source Writer master sources. In what way is it not working? I have not yet run into a problem, but have probably not used S& R on Master Sources very much. -- Jenny M Benson http://jennygenes.blogspot.co.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] new update
The S changes get made to the master source on the Master Source List, but when you look for the changes in the Edit view, they have not been made. If you then save the source, the changes go away on the List as well. Donald Quigley Escondido, CA Quigley Doyle Family Tree -Original Message- From: Jenny M Benson [mailto:ge...@cedarbank.me.uk] Sent: Monday, September 18, 2017 9:47 AM To: Donald Quigley <dwquig...@cox.net> Subject: Re: [LegacyUG] new update On 18-Sep-17 03:37 PM, Donald Quigley wrote: > Yes, but unfortunately it did not fix Issue #7608 - Search & Replace not > working for Source Writer master sources. In what way is it not working? I have not yet run into a problem, but have probably not used S & R on Master Sources very much. -- Jenny M Benson http://jennygenes.blogspot.co.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] new update
Yes, but unfortunately it did not fix Issue #7608 - Search & Replace not working for Source Writer master sources. Very frustrating to me because this was an issue that was finally fixed in Version 8, but then resurrected itself when Version 9 was issued. For a "extreme lumper" and 100% user of Source Writer, that wants to make my sources consistent, this makes me pull my hair out of my head. Very disappointed. Donald Quigley Escondido, CA Quigley Doyle Family Tree -Original Message- From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Jerry Kime Sent: Sunday, September 17, 2017 10:13 PM To: legacy <legacyusergroup@legacyusers.com> Subject: [LegacyUG] new update A new update just came out for Legacy version 198 Jerry Kime --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- 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] Query help
Carrie – Agree 100%. I usually work with copies of my Legacy fdb file until I know everything is working correctly. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Carrie Pillow Sent: Wednesday, July 19, 2017 11:11 AM To: Legacy User Group <legacyusergroup@legacyusers.com> Subject: Re: [LegacyUG] Query help Do a backup before working on your data in Access, it can be useful, but if you are not careful , you can corrupt your file Regards Carrie From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Scott Hall Sent: 19 July 2017 17:27 To: Legacy User Group <legacyusergroup@legacyusers.com <mailto:legacyusergroup@legacyusers.com> > Subject: Re: [LegacyUG] Query help Donald: Thanks. I just loaded Access on my computer as it seems improving my Access skills is going to be the best way to handle the various things I want to do with my database. At 102,000 individuals and growing, there's often a lot of this type of query and consideration I'd like to do. If OK with you, I may ask some query questions from time-to-time. Scott On Tue, Jul 18, 2017 at 8:44 PM, Donald Quigley <dwquig...@cox.net <mailto:dwquig...@cox.net> > wrote: Scott, I don’t believe that you can include an address in a search string. But you can find and tag all individuals with no Burial Place and then scroll through the Search Results list looking for the blue button adjacent to the “Buried in” field on the Edit page. If its shaded out, there is no address for the Buried Place. Tag such persons and you will have created the list you want – with one caveat: If the blue button is highlited, there is likely to be a burial address – but it could be just an indication of a Burial Note/Picture/Cremated (not likely, but possible). Klunky, but it might work for you. The only sure way I can think of is to go into MS Access and write a suitable query. Easy to say, but not if you don’t know Access. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com <mailto:legacyusergroup-boun...@legacyusers.com> ] On Behalf Of Scott Hall Sent: Tuesday, July 18, 2017 3:04 PM To: LegacyUserGroup@legacyusers.com <mailto:LegacyUserGroup@legacyusers.com> Subject: [LegacyUG] Query help I want to build a search query to identify all users with data in the burial place field but no attached burial address. Can anyone assist? I cannot figure out how to get attached addresses into the search string. Thanks, Scott -- 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] Query help
No worries, I’ll try to help. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Scott Hall Sent: Wednesday, July 19, 2017 9:27 AM To: Legacy User Group <legacyusergroup@legacyusers.com> Subject: Re: [LegacyUG] Query help Donald: Thanks. I just loaded Access on my computer as it seems improving my Access skills is going to be the best way to handle the various things I want to do with my database. At 102,000 individuals and growing, there's often a lot of this type of query and consideration I'd like to do. If OK with you, I may ask some query questions from time-to-time. Scott On Tue, Jul 18, 2017 at 8:44 PM, Donald Quigley <dwquig...@cox.net <mailto:dwquig...@cox.net> > wrote: Scott, I don’t believe that you can include an address in a search string. But you can find and tag all individuals with no Burial Place and then scroll through the Search Results list looking for the blue button adjacent to the “Buried in” field on the Edit page. If its shaded out, there is no address for the Buried Place. Tag such persons and you will have created the list you want – with one caveat: If the blue button is highlited, there is likely to be a burial address – but it could be just an indication of a Burial Note/Picture/Cremated (not likely, but possible). Klunky, but it might work for you. The only sure way I can think of is to go into MS Access and write a suitable query. Easy to say, but not if you don’t know Access. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com <mailto:legacyusergroup-boun...@legacyusers.com> ] On Behalf Of Scott Hall Sent: Tuesday, July 18, 2017 3:04 PM To: LegacyUserGroup@legacyusers.com <mailto:LegacyUserGroup@legacyusers.com> Subject: [LegacyUG] Query help I want to build a search query to identify all users with data in the burial place field but no attached burial address. Can anyone assist? I cannot figure out how to get attached addresses into the search string. Thanks, Scott -- 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] Query help
Scott, I don’t believe that you can include an address in a search string. But you can find and tag all individuals with no Burial Place and then scroll through the Search Results list looking for the blue button adjacent to the “Buried in” field on the Edit page. If its shaded out, there is no address for the Buried Place. Tag such persons and you will have created the list you want – with one caveat: If the blue button is highlited, there is likely to be a burial address – but it could be just an indication of a Burial Note/Picture/Cremated (not likely, but possible). Klunky, but it might work for you. The only sure way I can think of is to go into MS Access and write a suitable query. Easy to say, but not if you don’t know Access. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Scott Hall Sent: Tuesday, July 18, 2017 3:04 PM To: LegacyUserGroup@legacyusers.com Subject: [LegacyUG] Query help I want to build a search query to identify all users with data in the burial place field but no attached burial address. Can anyone assist? I cannot figure out how to get attached addresses into the search string. Thanks, Scott -- 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] New features suggestion
I use queries in MS Access to preprocess (ie, move data around) the Legacy “fdb” database (in a temporary fdb file) so that Legacy can create a gedcom (using the “Legacy” option) that best displays my data in TNG. The main issue I have with the transfer of data from Legacy to TNG is with sources and media. I am an extreme “splitter” – meaning that every source document is given a Master Source name. I name and file my sources, and associated media files, using the File ID (3225 in the example below). My source names typically look like this: Source List Name: 3225 - City Directory, CA, Santa Rosa; 1918 - Adelbert G. Quigley Family To achieve a “true” alphabetical sort of the sources in TNG, I use MS Access queries on tblBR (Media Files) and tblSR (Sources) to change the Master Source name to: Source List Name: City Directory, CA, Santa Rosa; 1918 - Adelbert G. Quigley Family [3225] I leave the File ID in the name so that I can search for it in TNG, which allows ad hoc searches. My media files typically look like this: Picture File Name: 3225_IMG.jpg Caption: City Directory, CA, Santa Rosa - Adelbert G. Quigley Family; Date: 1918 I use MS Access queries on tblBR (Media Files), tblSR (Sources) and tblAR (Addresses, incl. Repositories) to change the media file data so that it shows the date and adds the repository for display in TNG: Picture File Name: 3225_IMG.jpg Caption: City Directory, CA, Santa Rosa - Adelbert G. Quigley Family; Description: 1918 [from Ancestry.com] The queries also allow me to check for missing or incorrect File IDs for sources and media, and for missing Repositories. These omissions/errors have to be corrected in Legacy before the query process is completed. >>>>>>>>>> Regarding Scott Hall’s original question about transferring User ID values to the Find a Grave ID, it looks like this could be relatively easily done with queries in MS Access. The User ID is in the UserRef field in tblIR (Individual List). The FAG ID is in the Value field in tblIV (Find a Grave List). The two tables are linked by the common ID field. Obviously, you should work with a copy of your fdb file until you confirm that your queries work. Another option would be to export fields from each table and work with them in MS Excel and then copy back into MS Access. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Rick Koelz Sent: Thursday, July 13, 2017 7:44 AM To: Legacy User Group <legacyusergroup@legacyusers.com> Subject: Re: [LegacyUG] New features suggestion Yes, Donald, Tell us more about what you're doing with MS Access. On Wed, Jul 12, 2017 at 11:53 PM, Chris Bayley <krispi...@gmail.com <mailto:krispi...@gmail.com> > wrote: Donald, Could you please elaborate further on your "preprocessing" in MS Access. I was also a keen user of Ltools with its ability to have more focused queries. Thanks, Chris. On 13/07/2017 4:54 a.m., Donald Quigley wrote: Scott, Without getting into the FAG question, which others have commented on, I’ll second your suggestion that Legacy would be much improved by adding simple database tools (like the old LTools) to accommodate changes brought about by program updates or other user-specific reasons to move data around and do “global” manipulations electronically rather than manually. I now use MS Access to “preprocess” my Legacy fdb database before creating a GED file for uploading to my family (TNG) website and to Ancestry. A Millenia-built set of tools to do similar and other functions would make my life a lot easier by not having to write Access queries as I need them. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Scott Hall Sent: Tuesday, July 11, 2017 2:58 PM To: LegacyUserGroup@legacyusers.com <mailto:LegacyUserGroup@legacyusers.com> Subject: [LegacyUG] New features suggestion I submitted this through Milennia's suggest feature on their website, but also thought I'd post it here. It's great that Milennia keeps adding feature to LFT, but it would be really useful if you also added a way to convert existing data to take advantage of new features. For example, Find-a-Grave has been added to the SourceWriter, but no way has been provided to convert/update existing data using a different source template to the new one. This leaves the users either having to keep two sources for the same source, or manually identify and update the records -- for users with large files, that's a pain. In my case, given that LFT had no dedicated place to record Find-a-Grave memorial I use the flexible field "UserID" BUT ... when
Re: [LegacyUG] New features suggestion
Scott, Without getting into the FAG question, which others have commented on, I’ll second your suggestion that Legacy would be much improved by adding simple database tools (like the old LTools) to accommodate changes brought about by program updates or other user-specific reasons to move data around and do “global” manipulations electronically rather than manually. I now use MS Access to “preprocess” my Legacy fdb database before creating a GED file for uploading to my family (TNG) website and to Ancestry. A Millenia-built set of tools to do similar and other functions would make my life a lot easier by not having to write Access queries as I need them. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On Behalf Of Scott Hall Sent: Tuesday, July 11, 2017 2:58 PM To: LegacyUserGroup@legacyusers.com Subject: [LegacyUG] New features suggestion I submitted this through Milennia's suggest feature on their website, but also thought I'd post it here. It's great that Milennia keeps adding feature to LFT, but it would be really useful if you also added a way to convert existing data to take advantage of new features. For example, Find-a-Grave has been added to the SourceWriter, but no way has been provided to convert/update existing data using a different source template to the new one. This leaves the users either having to keep two sources for the same source, or manually identify and update the records -- for users with large files, that's a pain. In my case, given that LFT had no dedicated place to record Find-a-Grave memorial I use the flexible field "UserID" BUT ... when v9 added a dedicated field, there was no easy way to convert all the data in the flex field to the new field. In other words, we need some simple database tools added to the program. Perhaps not as much as the old LTools provided, but enough to be able to have a clean, consistent database that takes advantage of new features. For reference, my database is 102,100 individuals and growing. Manually moving data around is onerous. Thanks, Scott -- 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] Test Message
??? haven't rec'd any messages since Wednesday ??? Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree -- 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] Test Msg
Sorry..just checking new email account. Donald Quigley Escondido, CA <https://donquigley.net/> Quigley Doyle Family Tree -- 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/