Erroneous duplicates in bibliography

Hello to all. Can someone kindly help? I've come across the duplicate bibliography issue, which I am assuming is somehow my fault. I'm using the Word add-in, by the way. I've searched the forums here for a solution, but am not finding a step-by-step solution. This thread was the closest I found, but it's still not clear for me:
https://forums.zotero.org/discussion/63882/why-alphabetic-letters-a-b-or-c-appearing-after-year-for-some-references-and-how-to-avoid-this/p1

I have a rather lengthy dissertation I am working through, and have found at least 20 or so duplicates. I did use the merge tool when I came across duplicates, so I'm not sure where I caused this error to occur. That said, I really could use some help in cleaning this up. I'd rather not have to export my references to some other tool only to have to rewrite and insert all over again.

Thanks ahead of time for any assistance I can get.

Patrick
  • Can you say more about the exact problem you're facing and what you don't understand?
  • edited May 2, 2019
    Thanks for jumping in. Yes, here is what I see in my bibliography and don't know how to resolve:

    Ajzen, I. (1991a). The theory of planned behavior. Organizational Behavior and Human Decision Processes, 50(2), 179–211. https://doi.org/10.1016/0749-5978(91)90020-T

    Ajzen, I. (1991b). The theory of planned behavior. Organizational Behavior and Human Decision Processes, 50(2), 179–211. https://doi.org/10.1016/0749-5978(91)90020-T

    When I look in Zotero, I have only one entry for this citation.

    Here are the codes from the "a" entry:

    ADDIN ZOTERO_ITEM CSL_CITATION {"citationID":"ap68pjad8k","properties":{"formattedCitation":"(Ajzen, 1991a)","plainCitation":"(Ajzen, 1991a)","noteIndex":0},"citationItems":[{"id":"2CuUpbOP/S6SjJ0V7","uris":["http://zotero.org/users/33339/items/V8M7U785"],"uri":["http://zotero.org/users/33339/items/V8M7U785"],"itemData":{"id":"2CuUpbOP/S6SjJ0V7","type":"article-journal","title":"The theory of planned behavior","container-title":"Organizational Behavior and Human Decision Processes","page":"179-211","volume":"50","issue":"2","source":"CrossRef","URL":"http://linkinghub.elsevier.com/retrieve/pii/074959789190020T","DOI":"10.1016/0749-5978(91)90020-T","ISSN":"07495978","language":"en","author":[{"family":"Ajzen","given":"Icek"}],"issued":{"date-parts":[["1991",12]]},"accessed":{"date-parts":[["2017",11,13]]}}}],"schema":"https://github.com/citation-style-language/schema/raw/master/csl-citation.json"}

    And here are the codes for the "b" entry:

    ADDIN ZOTERO_ITEM CSL_CITATION {"citationID":"avum47qc99","properties":{"formattedCitation":"(Ajzen, 1991b)","plainCitation":"(Ajzen, 1991b)","noteIndex":0},"citationItems":[{"id":8264,"uris":["http://zotero.org/users/33339/items/6D5Y5RQP"],"uri":["http://zotero.org/users/33339/items/6D5Y5RQP"],"itemData":{"id":8264,"type":"article-journal","title":"The theory of planned behavior","container-title":"Organizational Behavior and Human Decision Processes","page":"179-211","volume":"50","issue":"2","source":"Crossref","abstract":"Research dealing with various aspects of the theory of planned behavior (Ajzen, 1985, Ajzen, 1987) is reviewed, and some unresolved issues are discussed. In broad terms, the theory is found to be well supported by empirical evidence. Intentions to perform behaviors of different kinds can be predicted with high accuracy from attitudes toward the behavior, subjective norms, and perceived behavioral control; and these intentions, together with perceptions of behavioral control, account for considerable variance in actual behavior. Attitudes, subjective norms, and perceived behavioral control are shown to be related to appropriate sets of salient behavioral, normative, and control beliefs about the behavior, but the exact nature of these relations is still uncertain. Expectancy-value formulations are found to be only partly successful in dealing with these relations. Optimal rescaling of expectancy and value measures is offered as a means of dealing with measurement limitations. Finally, inclusion of past behavior in the prediction equation is shown to provide a means of testing the theory's sufficiency, another issue that remains unresolved. The limited available evidence concerning this question shows that the theory is predicting behavior quite well in comparison to the ceiling imposed by behavioral reliability.","URL":"http://linkinghub.elsevier.com/retrieve/pii/074959789190020T","DOI":"10.1016/0749-5978(91)90020-T","ISSN":"07495978","language":"en","author":[{"family":"Ajzen","given":"Icek"}],"issued":{"date-parts":[["1991",12]]},"accessed":{"date-parts":[["2018",8,12]]}}}],"schema":"https://github.com/citation-style-language/schema/raw/master/csl-citation.json"}

  • OK, so those are duplicates in your document. The first one, which you added in 2017, no longer exists in your library, and you appear to have deleted it in August 2018, about a week before adding the second item, so it isn't properly marked as being merged with the other item. So as far as Zotero is concerned, those are just two distinct items, one of which no longer exists in your library. You can tell whether an item is linked by clicking on it, clicking Add/Edit Citation, clicking on the blue bubble, and then looking in the popup for the "Open in My Library" button, which will appear if the item exists in the library and won't appear if it doesn't.

    At this point, the only way to fix this is by replacing the first item with the existing item. You can do that by deleting it from the document and then inserting it again and choosing the item from the library section — rather than the Cited section — of the results in the citation bar. (Or, if you're using the classic citation dialog, you can just select the item from the library.)

    So this will take some manual work to recover from, but that's only because you 1) deleted some items in Zotero that you used in documents rather than merging duplicates, 2) added duplicates of those items, and 3) then cited those duplicates from your library rather than selecting from the "Cited" section at the top of the search results in the citation bar. You have to do all three of those things for this to happen.
  • dstillman, thanks for your help. I will follow the steps you outlined and report back.
Sign In or Register to comment.