Thanks Paula. Yes, that's how I was doing them, but Dennis Kowalleck, creator of the LTools product that works with Legacy, gave me a snippet of raw SQL code to enter into LTools after I loaded my Legacy database into LTools. It took care of 5,370 rows of sources in about three seconds! So, his product saved me a ton of time. But thanks for the suggestion - at least I know I was doing it about as well as I could until his fix came along.
Jerry - MerriamFamilyTree.org On 8/22/2011 11:24 AM, Paula Ryburn wrote: > Still, if you're using the clipboard, if you have "prompt for detail" > checked on the detail, then all you're really re-entering is the page > number. Apply the clipboard to the Unspecified field, enter the page #, > save, and remove citation from Name, save, untag individual and move to > next one. (just double-checking you and I are thinking the same on how > to use the clipboard in this case...?) Sometimes it just takes a while > to do what needs to be done. I still haven't finished removing the the > mother/father relationship values that were set during my import (in > 2002??) because of a bug in the program at that time that I didn't > detect until much later... finished my direct line, but the rest of > those folks are going to have to be fixed in small chunks as the mood > strikes me. haha Good luck! > --Paula in Texas > Researching: Adair Baker Beasley Benson Betz Bigley Blagrave Burton > Chapman Clement Clough Coppernoll Costine Daulton Dinwiddie Doody Ellis > Exline Field Floran Floyd Gates Goodale Gordon Gump Hale Harbaugh Hind > Hopkins Hughes Hurdle Jones Klein Koyle Laswell McDonald Misner > Passwaters Pelton Roberts Roche Ryburn Short Singer Sullivan Weller > Williams > > > ------------------------------------------------------------------------ > *From:* Jenny M Benson <[email protected]> > *To:* [email protected] > *Sent:* Thu, August 18, 2011 9:13:44 AM > *Subject:* Re: [LegacyUG] Any More Source Short-Cuts ? > > On 18/08/2011 13:10, Jerry wrote: > > Thanks Jenny, but how would that method handle each record's source > detail? > > That question implies that the Source Detail is not the same for every > record, as I was presuming. If it different, you would have to do the > copy and paste in batches. Hopefully, if you were starting from scratch > with 1000 records to update, you would not have 1000 different Source > Details to cope with! > > ...Jerry / MerriamFamilyTree.com <http://merriamfamilytree.com/> > > > > Jenny M Benson<[email protected] <mailto:[email protected]>> > wrote: > > > >> On 17/08/2011 22:19, Jerry wrote: > >>> Hello again. Is anyone aware of any shortcut keys (other than the > >>> source clipboard) that might help me out with my project? What I wish > >>> to do is to transfer a source that was input under NAME to the > >>> UNSPECIFIED source item. for over a thousand records. I'm doing this > >>> for consistency and because I don't want to populate multiple sources > >>> which would increase our website bandwidth until there are new sources > >>> to add to the individual fields. There is detail to go with each source > >>> record (page numbers from our large book), so I can't just change > >>> everything over without cutting and pasting the detail. I'm plugging > >>> along fairly fast, but just wondering if anyone knows of an even more > >>> stream-lined approach. > >> > >> Other than using Access, I can only think of one thing which would speed > >> up the process a little, but is not of any use to you because you have > >> already started to move the Source from Name to Unspecified. However, > >> FWIW I'll mention it. > >> > >> First make a copy of the Source and give the copy a different name. > >> Using Copy (once) and Paste (many, many times!) add the re-named version > >> of the Source to the Unspecified field for each individual. Then delete > >> the original version of the Source. > >> > >> (Note, this assumes you want to delete ALL instances of the original > >> Source.) > >> > >> You still need to visit every record to paste the Source into the > >> Unspecified field, but you don't have to spend extra time removing the > >> old Source from each record. > >> > >> -- > >> Jenny M Benson > > -- > Jenny M Benson > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages after Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > 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 > <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/[email protected]/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > 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/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ 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
