Upgrade StorageImporting the "Accession Number" field from RefWorks into Zotero
Hi all,
My institution's RefWorks subscription is terminating this month, and after a comparison of other reference management software out there, I'd like to recommend we use Zotero going forward. Some of our field staff use the Accession Number as a reference ID, and thus it is a particularly important field to keep. I'm brand-new to Zotero, so I don't know all the tricks that might be out there to make it work best for my team.
I have searched for a while for this question, and cannot find the answer on these forums or elsewhere. I did locate an extensive discussion about PubMed IDs, which appear to be identical to the Accession Numbers; however, it's not useful because I want to simply get this data into a field on the Info tab.
Currently, if I export in the RefWorks tagged format, then this info is preserved with an acronym of 'AN.' Zotero will import them into the Notes section as part of the group for which
"The following values have no corresponding Zotero field:
AN 47156629"
What I would really like to have happen is for these to be imported into a field, preferably named 'Accession Number' although it could be something else, but within that Info tab. It would be okay if this was a post-processing step after importing into Zotero, as long as it could be automated.
I looked at the Zotero preferences and didn't see anything jump out as setting up something customized. I'm not sure if I'm missing something obvious. I'm willing to do some work and teach field staff the steps to get their data ported over.
If I put the references into EndNote and then export in RIS format, the Accession Number is preserved and converted to a field called "Loc. in Archive." I'm hesitant to put everything from Refworks into EndNote, then back out and into Zotero - I don't know what else might get lost in that transition. When I do that I don't get the note with values that didn't fit into Zotero, so some data is simply lost. This implies to me that it should be possible to keep the data currently in the Accession Number slot, but I'm stuck on how. Any help would be greatly appreciated! Happy to answer further questions to clarify.
My institution's RefWorks subscription is terminating this month, and after a comparison of other reference management software out there, I'd like to recommend we use Zotero going forward. Some of our field staff use the Accession Number as a reference ID, and thus it is a particularly important field to keep. I'm brand-new to Zotero, so I don't know all the tricks that might be out there to make it work best for my team.
I have searched for a while for this question, and cannot find the answer on these forums or elsewhere. I did locate an extensive discussion about PubMed IDs, which appear to be identical to the Accession Numbers; however, it's not useful because I want to simply get this data into a field on the Info tab.
Currently, if I export in the RefWorks tagged format, then this info is preserved with an acronym of 'AN.' Zotero will import them into the Notes section as part of the group for which
"The following values have no corresponding Zotero field:
AN 47156629"
What I would really like to have happen is for these to be imported into a field, preferably named 'Accession Number' although it could be something else, but within that Info tab. It would be okay if this was a post-processing step after importing into Zotero, as long as it could be automated.
I looked at the Zotero preferences and didn't see anything jump out as setting up something customized. I'm not sure if I'm missing something obvious. I'm willing to do some work and teach field staff the steps to get their data ported over.
If I put the references into EndNote and then export in RIS format, the Accession Number is preserved and converted to a field called "Loc. in Archive." I'm hesitant to put everything from Refworks into EndNote, then back out and into Zotero - I don't know what else might get lost in that transition. When I do that I don't get the note with values that didn't fit into Zotero, so some data is simply lost. This implies to me that it should be possible to keep the data currently in the Accession Number slot, but I'm stuck on how. Any help would be greatly appreciated! Happy to answer further questions to clarify.
https://www.zotero.org/support/zotero_data
You don't have to understand the whole javascript code, but simply add the mapping to the generic mapping table:
https://github.com/zotero/translators/blob/master/RefWorks Tagged.js#L141
See http://aurimasv.github.io/z2csl/typeMap.xml for the names of Zotero fields.
Note that you cannot create custom fields in Zotero at this time, so you'll have to choose an existing field.