Upgrade StorageErroneous 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
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
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"}
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.