Endnote XML Import
Hello,
Hoping someone can help - and hoping it's an easy fix...
I am returning to an old reference database last I used with the now-defunct Sente, and before that Reference Manager, and before that doubtless something else.
Having had my fingers burned, I want to move to open source (Zotero) and have got the Sente data temporarily into Bookends and from that exported into an Endnote XML file.
For me personally, this has been the best way to retain as much of the data as I can, in as meaningful a way as possible (ie, retaining keywords properly, date details, and so on). I have spent a week trying different approaches including Bibtex and different export/import routes.
But, there are four data items I held in RefMan/Sente which I don't have appropriate homes for in Zotero (, , , ). So I am thinking of using some of the Zotero fields to hold this data, as follows:
- Endnote XML field to Zotero field "Archive"
- to "Extra"
- to "Call Number"
- to "Loc. in Archive"
My question is: is it easier to find/replace the field names in XML and then import? If so, what labels do I replace the XML names with to get them into the desired Zotero fields?
Or, is it easier to edit a Zotero translator to achieve the same thing?
Any help would be most gratefully appreciated.
Many thanks,
Jonathan
Hoping someone can help - and hoping it's an easy fix...
I am returning to an old reference database last I used with the now-defunct Sente, and before that Reference Manager, and before that doubtless something else.
Having had my fingers burned, I want to move to open source (Zotero) and have got the Sente data temporarily into Bookends and from that exported into an Endnote XML file.
For me personally, this has been the best way to retain as much of the data as I can, in as meaningful a way as possible (ie, retaining keywords properly, date details, and so on). I have spent a week trying different approaches including Bibtex and different export/import routes.
But, there are four data items I held in RefMan/Sente which I don't have appropriate homes for in Zotero (, , , ). So I am thinking of using some of the Zotero fields to hold this data, as follows:
- Endnote XML field to Zotero field "Archive"
- to "Extra"
- to "Call Number"
- to "Loc. in Archive"
My question is: is it easier to find/replace the field names in XML and then import? If so, what labels do I replace the XML names with to get them into the desired Zotero fields?
Or, is it easier to edit a Zotero translator to achieve the same thing?
Any help would be most gratefully appreciated.
Many thanks,
Jonathan
<code>
block?Many thanks for your response - for some reason, I see the query has been edited. and so probably doesn't make much sense. The key part should have read:
----
I am thinking of using some of the Zotero fields to hold this data, as follows:
- Endnote XML field *user16* to Zotero field "Archive"
- *user15* to "Extra"
- *user18* to "Call Number"
- *notes* to "Loc. in Archive"
----
All of the field names in the Endnote XML export file (including the four above) have enclosing angled brackets (I'm guessing these are being edited out in the post so I'm not using them again here). The bracketed field name is repeated before and after the field text, with an additional "/" when terminating it.
I hope this makes it clearer! Any help much appreciated.
Many thanks,
Jonathan
I guess that it might be easier to adapt your EndNote XML translator file than to search and replace text in the XML file. It might be enough to change the mapping in fieldMap a little.
However, note that the extra field is used in the translator for PMCID as well and your information there could be overwritten by that. Are you sure you don't have PMCID in your database? Or would maybe libraryCatalog be a better field to use for you? Moreover, the notes are already exported into a note but I think that a mapping from fieldMap would overrule that. Iust try it out to be sure.
Anyways, there should always been a note created in Zotero with all the information from the fields which could not been maped, i.e. your information will already now (without any changes of your translator) been imported in Zotero.
I don't use PubMed at all so I think I can repurpose that field safely.
So I've tried adding lines for the four fields to the fieldMap section in the translator (Endnote XML.js), in the format:
"Endnote Field Name": "Zotero Field Name",
I'm taking the Endnote field name as the ones in the XML file (user16, user18, etc).
However, the import fails wth the message "The selected file is not in a supported format."
Any suggestions as to where I'm going wrong would be greatly appreciated.
Thanks,
Jonathan
The same (default) translator works fine for my Endnote XML file exported from Bookends, I just can't make the edit to work to import the four extra fields...
The translator works fine with my base export file; it's when I try and change the fieldMap section it stops working. I'm wondering if I need to amend other sections as well?
Thanks.
var fieldMap = {
//same for all itemTypes
abstract: "abstractNote",
//"call-num": "callNumber",
"electronic-resource-num": "DOI",
"remote-database-name": "libraryCatalog",
"abbr-1": "journalAbbreviation",
"short-title": "shortTitle",
"full-title": "publicationTitle",
language: "language",
"access-date": "accessDate",
//These two are in the RIS - not sure what they'd be in Endnote XML
user15: "extra",
user16: "archive",
notes: "archiveLocation",
user18: "callNumber",
Don't forget to update the translators (or restart Zotero) after the changes. Moreover, it might help to look for some further error message (in the report error box, or when you activate loging and then have a look).
That's worked perfectly - thank you so much! Not quite sure which bit solved the problem, but I hadn't realised about updating the translators, or the error logging, which is good to know.
I'm delighted not to have lost anything!
Best wishes,
Jonathan
If importing the XML file doesn’t bring the PDF, can you post the xml file to Dropbox or similar and link here?