If your sources are not EXACTLY the same they will duplicate. All of the punctuation and spacing must agree, otherwise they re-add. You may be able to clean up the spacing and punctuation and merge them together so they are still attached to your people. If they are not exactly the same they will not merge. Been there, done that! Even an extra line feed at the end will throw it off. Jinny Angelis > Date: Fri, 22 Apr 2016 18:29:21 -0400 > To: rootsmagic-users@rootsweb.com > Subject: Re: [RMagic] Fw: RM Database Tools & Duplicate Source Templates > From: rootsmagic-users@rootsweb.com > > Hi, > > I have this problem too! I have SOURCE TEMPLATES duplicated many > times. I think, but I'm not sure, this happened after dragging and > dropping people from one database to another. > > I am not at all computer savvy either! I think that RM should address > this problem and fix it. If it is a consequence of dragging and > dropping, they certainly shouldn't be recommending the procedure in > their videos! Instead, they should be warning people never to do it. > > I certainly don't know what to do about the duplicates. > > Someone recommended that I go through the source list and eliminate > any duplicates. I tried that. There weren't many and deleting them in > no way affected the duplicate source templates. One of them is > duplicated 8 times. > > Carol Anne > > On Fri, Apr 22, 2016 at 4:23 PM, Tom Holden via > <rootsmagic-users@rootsweb.com> wrote: > > Sandra, if you want, I will have a look at your database. Send me a backup > > (.rmgb file). > > > > Tom > > > > On Fri, Apr 22, 2016 at 4:16 PM, Sandra Studebaker via < > > rootsmagic-users@rootsweb.com> wrote: > > > >> Had no response to my earlier plea below. So, in an attempt to resolve > >> the issue of duplicate source templates, I made a copy of the 945-name > >> database currently in RM4, then imported the copy into RM6 and ran all > >> Database Tools options on the imported database hoping for a miracle. > >> Nada! Nothing! Still stuck with 10 identical new source templates when I > >> should have only one -- which needs a bit of project-specific tweaking. > >> Bruce, Tom, somebody - HELP! > >> --A longtime user, and advocate, of FO/RM for the Studebaker Family > >> National Association's ongoing digitization project. > >> > >> ----- Original Message ----- > >> From: Sandra Studebaker > >> To: rootsmagic-users@rootsweb.com > >> Sent: Tuesday, April 19, 2016 12:09 AM > >> Subject: RM Database Tools & Duplicate Source Templates > >> > >> > >> A belated thank you to Paul, Pat, Margaret and Rick for responding to my > >> earlier (4/4) query about RM's database tools. Long a user--and lover--of > >> RM3 and earlier versions since FO7, I didn't realize that later versions of > >> RM have useful database tools that RM4 lacks. But, apparently, even RM7 > >> still does not have one to help with the issue of duplicate source > >> templates of my one new user-created project-specific template. Twenty-one > >> copies of that template seemed to appear suddenly in one RM4 database of > >> 945 names entered individually. None had been entered via drag-and-drop > >> from another database. Managed to carefully identify and eliminate all but > >> ten of the culprets without losing anything, but the remainder have me > >> stymied. See that Tom Holden has an SQLITE solution for duplicate source > >> templates, but this soon-to-be-octagenarian doesn't have a clue, nor the > >> courage, to try to apply it. Don't want to risk deleting any, as all are > >> said to "have sources using this sour! > >> ce," and I see no way of determining what they are. But maybe someone on > >> the list can hold my hand in merging these apparently identical duplicate > >> templates. TIA > >> --Sandra Studebaker in Michigan > >> > >> > >> =================================== > >> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: > >> http://blog.rootsmagic.com/ > >> > >> > >> ------------------------------- > >> To unsubscribe from the list, please send an email to > >> ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without > >> the quotes in the subject and the body of the message > >> > > > > > > =================================== > > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > > > > ------------------------------- > > To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

On 4/23/2016 1:13 PM, Jinny Angelis via wrote: > If your sources are not EXACTLY the same they will duplicate. All of the punctuation and spacing must agree, otherwise they re-add. The easiest way to "clean up the spacing and punctuation..." is to cut and paste all the text from one to the other. > You may be able to clean up the spacing and punctuation and merge them together so they are still attached to your people. If they are not exactly the same they will not merge. > Been there, done that! Even an extra line feed at the end will throw it off. > > Jinny Angelis >