Upgrade StorageDatabase names in journal article citations
Hello - I've just noticed that the Create Bibliography with APA 7th edition generates citations containing the database name, which I think is incorrect.
Example:
Azaron, A., Venkatadri, U., & Farhang Doost, A. (2021). Designing profitable and responsive supply chains under uncertainty. International Journal of Production Research, 59(1), 213–225. Business Source Complete. https://doi.org/10.1080/00207543.2020.1785036
However, according to the APA style website, the names of academic databases are generally not included:
• “If the journal article does not have a DOI and is from an academic research database, end the reference after the page range (for an explanation of why, see the database information page). The reference in this case is the same as for a print journal article.”
• “Do not include database information in the reference unless the journal article comes from a database that publishes works of limited circulation or original, proprietary content, such as UpToDate.”
https://apastyle.apa.org/style-grammar-guidelines/references/examples/journal-article-references
The information on this webpage indicates that it is pretty rare to cite a database in APA 7 style:
https://apastyle.apa.org/style-grammar-guidelines/references/database-information
The database information is stored in the Archive field. I had a look at the code, and it looked like the code that needs changing is in line 1676-1678.
At first, I changed it to not include the Archive field if it's a journal article:
Then I realized it might be better to only include the Archive field if it's a thesis:
However, this seems crude compared to what might be done if I could also check whether the type="thesis" and the content of the Archive field contained both the word ProQuest and the word Dissertations.
Likewise, it would be cool to check if the Archive field contained any of the words: UpToDate, Best Practice, or Dynamed.
Lastly, if the Archive field contained the word ERIC or its full name and the URL contained the text https://files.eric.ed.gov/fulltext/ED or perhaps ED#####.pdf (but that's getting into Regex territory).
I'm new to Zotero coding. I can keep reading through the documentation and trying to write this code, but I figured I'd first report the situation and see if I've somehow misinterpreted the APA 7 instructions, and/or if anyone with more Zotero coding experience wants to have a try.
Example:
Azaron, A., Venkatadri, U., & Farhang Doost, A. (2021). Designing profitable and responsive supply chains under uncertainty. International Journal of Production Research, 59(1), 213–225. Business Source Complete. https://doi.org/10.1080/00207543.2020.1785036
However, according to the APA style website, the names of academic databases are generally not included:
• “If the journal article does not have a DOI and is from an academic research database, end the reference after the page range (for an explanation of why, see the database information page). The reference in this case is the same as for a print journal article.”
• “Do not include database information in the reference unless the journal article comes from a database that publishes works of limited circulation or original, proprietary content, such as UpToDate.”
https://apastyle.apa.org/style-grammar-guidelines/references/examples/journal-article-references
The information on this webpage indicates that it is pretty rare to cite a database in APA 7 style:
https://apastyle.apa.org/style-grammar-guidelines/references/database-information
The database information is stored in the Archive field. I had a look at the code, and it looked like the code that needs changing is in line 1676-1678.
At first, I changed it to not include the Archive field if it's a journal article:
<else>
<choose>
<if type="article-journal" match="none">
<text variable="archive"/>
</if>
</choose>
</else>Then I realized it might be better to only include the Archive field if it's a thesis:
<else>
<choose>
<if type="thesis" match="any">
<text variable="archive"/>
</if>
</choose>
</else>However, this seems crude compared to what might be done if I could also check whether the type="thesis" and the content of the Archive field contained both the word ProQuest and the word Dissertations.
Likewise, it would be cool to check if the Archive field contained any of the words: UpToDate, Best Practice, or Dynamed.
Lastly, if the Archive field contained the word ERIC or its full name and the URL contained the text https://files.eric.ed.gov/fulltext/ED or perhaps ED#####.pdf (but that's getting into Regex territory).
I'm new to Zotero coding. I can keep reading through the documentation and trying to write this code, but I figured I'd first report the situation and see if I've somehow misinterpreted the APA 7 instructions, and/or if anyone with more Zotero coding experience wants to have a try.
You should only use the Archive field for intonation that should appear because it is necessary for retrieval (like limited access databases or physical archives).
I'll check out the code for the RIS import filter.
Whichever way the problem is addressed, the difficulty is that 99% of publications, you don't want the database listed in the citation. The exceptions are limited access databases, such as Best Practice, Dynamed, and UpToDate, ProQuest Dissertations and its variants, certain ERIC documents, and certain physical archives.
Since there isn't a specific Item Type for limited access databases, nor the other special cases, there are three possibilities to deal with this:
1. Have the RIS filter put the contents of the DB filter into Library Catalogue, then users can manually copy and paste the database name out of Library Catalogue into Archive as needed. This makes sense because Best Practice, Dynamed, and UpToDate don't have direct export options (or at least, they didn't a year ago), so users would only have to copy and paste for documents from ProQuest Dissertations and ERIC monographs, both of which usually require some editing anyway.
2. Have the code automatically make decisions based on the content of the DP field or Archive field. I haven't yet confirmed whether this is possible, but I'm assuming it is, just have to find out how. The only problem with this is, there must be limited access databases other than Best Practice, Dynamed, and UpToDate, especially in other disciplines, but collecting all the names of the relevant databases might be a bit daunting.
3. A third option would be to create a new Item Type, something like Proprietary Database Entry, and it would cover all of these special cases. This would be of additional benefit, but would be a lot of work.
The current situation, where one would have to copy and paste the contents of the Archives field into the Library Catalogue by hand, is not a feasible solution given that there is no global edit option. In any export of more than, say, 30 articles, this would be too time-consuming for practicality.
2 isn't possible because CSL can't change behavior based on field content and 3 is way too specific for a Zotero item type.
At first, I thought it might be a change due to the new interface. However, I just tried exporting some random articles directly out of ProQuest, and the same thing happened - it says ProQuest Central in the Archive field.