I see in the Endnotes section of my journal report I have several duplicate sources.  I have merged some by going through the Master list of sources but there are still many more.  Is there a report I can print to help find these duplicate sources?  I have almost 3000 sources.  I am a splitter as opposed to a lumper. Nancy

On 2/17/2019 12:09 PM, Nancy W. wrote: > I see in the Endnotes section of my journal report I have several duplicate sources.  I have merged some by going through the Master list of sources but there are still many more.  Is there a report I can print to help find these duplicate sources?  I have almost 3000 sources.  I am a splitter as opposed to a lumper. Nancy, What is it about a pair of Sourced that makes them duplicates? What specific element(s) in the Source Definition have to match to identify a duplicate? Knowing that we can suggest a report to find them. Terry Reigel

I took a lesson from a past/former/silent member who said she sorted her sources by the two letter postal abbreviation, then a description of the source.  Example: CA, 1910 Cen Lowrie, George P. Sr.I just merged two of those. Three Letters are used for other countries and there are several others where a place does not apply. I think it might be just as easy to go through the Master Source List as print out a list to go through. Today I have found 4 to be merged - but am working in California which probably has the most, maybe Connecticut will not be too far behind California.  These duplicates come from merging two data sets. I knew there were people who would be duplicates and took care of merging them but I forgot about the sources.  They are just beginning to plaque me now. Nancy On Sunday, February 17, 2019, 11:58:59 AM CST, Terry Reigel <terry@reigelridge.com> wrote: On 2/17/2019 12:09 PM, Nancy W. wrote: > I see in the Endnotes section of my journal report I have several duplicate sources.  I have merged some by going through the Master list of sources but there are still many more.  Is there a report I can print to help find these duplicate sources?  I have almost 3000 sources.  I am a splitter as opposed to a lumper. Nancy, What is it about a pair of Sourced that makes them duplicates? What specific element(s) in the Source Definition have to match to identify a duplicate? Knowing that we can suggest a report to find them. Terry Reigel _______________________________________________ Email preferences: http://bit.ly/rootswebpref Unsubscribe https://lists.rootsweb.com/postorius/lists/tmg@rootsweb.com Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community

Nancy, I'm not aware of a report to find duplicate sources. To be "duplicate" two sources would have to have exactly the same content for every source element, memo content and reminder content on the Supplemental tab, linked repositories, exhibits, etc. You could look for candidates by sorting the Master Source List by Title and scanning it (all 3000) then opening any with duplicated titles to see if they are truly duplicates. That said, duplicate endnotes don't necessarily mean duplicate sources. Multiple citations to the same source can produce identical endnotes depending on the use of the CM and CD fields, the Short Title field, as well as the content of the Full Footnote and Short Footnote templates. This can happen with and without the Unique Endnotes option selected. If you think your issue might be duplicate endnotes instead of duplicate sources you may find Michael Hannah's discussion helpful here: https://www.mjh-nm.net/SRCGUIDE.HTML#IbidUnique On 2/17/2019 9:09 AM, Nancy W. wrote: > I see in the Endnotes section of my journal report I have several duplicate sources.  I have merged some by going through the Master list of sources but there are still many more.  Is there a report I can print to help find these duplicate sources?  I have almost 3000 sources.  I am a splitter as opposed to a lumper. > Nancy >

At 2/17/2019 12:09, Nancy W. wrote >I see in the Endnotes section of my journal >report I have several duplicate sources. I >have merged some by going through the Master >list of sources but there are still many >more. Is there a report I can print to help >find these duplicate sources? I have almost >3000 sources. I am a splitter as opposed to a lumper. As Terry says, we need more information to be able to give you speicifc help. But, there are a couple of things that you might look at. One is the List of Sources report. You would not want to print such a report for 3000 Sources, but you could generate the report to a file (word processor, spreadsheet, Rich Text Format, or even PDF) and review it on screen. There are a number of options for the report that you could select. You can select to have a columnar report in which case you select which Source Elements are included in the Output Columns. The problem I have with this is deciding shich Source Element to select as not all Sources have the same Source Elements and there is a limit of nine columns. But, depending on what I think I want, I can usually figure something out. You can also select an indented report. This option gives the Source ID# and either the Title or Abbreviation. You may also choose to print the report with the Source ID# and Bibliography. One or all of these indented lists may solve most of your problem or at least narrow down the work. Once you have the work reduced to the "hard to find", the columnar list may help. Another possibility is the List of Citations report. Again, there are a number of options available. Finally, there is John Cardinal's TMG Utility. It can generate a Source Page that can be viewed in your browser of your Sources. The page would include the Source #, Abbreviation, and Title. Some Sources here will also display an e-mail address or a URL. The page is sorted by the Source Title. The contents of the page could be copied to a spreadsheet and re-sorted as you wish. The advantage of this over the Lists generated by TMG is that this report include both the Abbreviation and the Title columns. Lee

Nancy W. asked: > I see in the Endnotes section of my journal report > I have several duplicate sources... > I have merged some by going through the Master list of sources... > Is there a report I can print to help find these duplicate sources? The quick answer is no. I know of no report which will only output source definitions which are duplicated. As Lee mentioned, there is the TMG List of Sources report. But even that list, appropriately sorted, would have to be visually reviewed to notice that two sources sorted together were duplicates. And as Lee mentioned there are only nine possible output columns, so you would have to be careful which fields you chose to be in the report. However, by sending it to a file, e.g. Word, you could go through the file on screen and delete lines of the report as you reviewed and finished with them. Michael