EndnoteX4 to Zotero

I try to export from EndnoteX4 (RIS style added, and exported in RIS format as .txt, as told by tutorial) into Zotero2.1.1 with ZotFile and OpenOffice integration 3.5a1 installed on a windows7 64bit system.

I get an error to please check if the file is correct and try again ("Ein Fehler ist aufgetreten beim Importieren der ausgewählten Datei. Bitte überprüfen Sie, ob die Datei korrekt ist und versuchen Sie es erneut."). Nevertheless, it does import the very first entry into Zotero.

I tried export files as small as one entry total, same result.

RIS.txt File looks like this and is UTF-8 encoded:
TY - JOUR
AB - Axonal steering reactions depend on the transformation of environmental information into internal, directed structures, which is achieved by differential modulation of the growth cone cytoskeleton; key elements are the microtubules, which are regulated in their dynamics by microtubule-associated proteins (MAPs). We investigated a potential role of the MAP adenomatous polyposis coli (APC) for growing axons, employing embryonic visual system as a model system. APC is concentrated in the distalmost (i.e., growing) region of retinal ganglion cell axons in vivo and in vitro. Within the growth cone, APC is enriched in the central domain; it only partially colocalizes with microtubules. When axons are induced to turn toward a cell or away from a substrate border, APC is present in the protruding and absent from the collapsing growth cone regions, thus indicating the future growth direction of the axon. To assess the functional role of the differential distribution of APC in navigating growth cones, the protein was inactivated via micro-scale chromophore-assisted laser inactivation in one half of the growth cone. If the N-terminal APC region (crucial for its oligomerization) is locally inactivated, the treated growth cone side collapses and the axon turns away. In contrast, if the 20 aa repeats in the middle region of APC (which can negatively regulate its microtubule association) are inactivated, protrusions are formed and the growth cone turns toward. Our data thus demonstrate a crucial role of APC for axon steering attributable to its multifunctional domain structure and differential distribution in the growth cone.
AD - Department of Developmental Neurobiology, Institute of Zoology, University of Heidelberg, D-69120 Heidelberg, Germany.
AN - 18003838
AU - Koester, M. P.
AU - Muller, O.
AU - Pollerberg, G. E.
DA - Nov 14
DO - 27/46/12590 [pii]
10.1523/JNEUROSCI.2250-07.2007
ET - 2007/11/16
KW - Adenomatous Polyposis Coli Protein/*metabolism
Animals
Body Patterning/physiology/radiation effects
Cell Communication/physiology
Cell Differentiation/*physiology/radiation effects
Central Nervous System/cytology/*embryology/*metabolism
Chick Embryo
Chickens
Growth Cones/*metabolism/radiation effects/ultrastructure
Humans
Lasers
Microtubules/metabolism/ultrastructure
Protein Structure, Tertiary/physiology/radiation effects
Retinal Ganglion Cells/cytology/metabolism/radiation effects
Visual Pathways/cytology/embryology/metabolism
L1 - http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=PubMed&dopt=Citation&list_uids=18003838
LA - eng
IS - 46
N1 - Koester, Michael P
Muller, Oliver
Pollerberg, G Elisabeth
Research Support, Non-U.S. Gov't
United States
The Journal of neuroscience : the official journal of the Society for Neuroscience
J Neurosci. 2007 Nov 14;27(46):12590-600.
PY - 2007
SN - 1529-2401 (Electronic)
SP - 12590-600
ST - Adenomatous polyposis coli is differentially distributed in growth cones and modulates their steering
T2 - J Neurosci
TI - Adenomatous polyposis coli is differentially distributed in growth cones and modulates their steering
UR - http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=PubMed&dopt=Citation&list_uids=18003838
VL - 27
ID - 330
ER -
  • I don't know if Zotero is designed to work around this (it probably does), but note that this RIS illustrates a really old bug in Endnote (that I can't believe they still haven't fixed!); those keywords should be:

    KW - Adenomatous Polyposis Coli Protein/*metabolism
    KW - Animals
    KW - Body Patterning/physiology/radiation effects
    KW - Cell Communication/physiology

    So you could see what happens with a single record if you either remove the keywords entirely, or edit as I suggest.
  • I would suspect Endnote's buggy RIS output is a feature, not a bug. It makes it harder for people to leave and many of the ones who try experience all types of issues in their first interaction with their new reference management software....
  • Your example record imports just fine for me from the clipboard. There are character encoding issues in some versions of zotero on some platforms & I can't test on yours (don't have win 7), but you might try to change the character encoding. Does the real file you're trying to import have more than just the single record?

    Zotero does work around the keyword issue. The reason it exists is most likely not malicious, but from long-standing limitations of their export framework (that probably don't really impact other formats):
    https://groups.google.com/group/zotero-dev/msg/079cb3b86bc60bcc?dmode=source
  • I tried this very file, just one record included. Will try to put the whol file (or maybe 2, 3 records) into the clipboard tomorrow and I will also try to re-format the entry as suggested - which I will not be able to do for 1200 articles :(

    And yes, the buggy RIS seems like a "feature" to me, too.
  • edited March 22, 2011
    When I try to import the citation above using a fresh install of Zotero 2.1.1 on Firefox 4 under Linux, I get an empty "Webpage" item.

    I've worked on the translator some and can get back to saving a real entry; to try it, go to http://github.com/ajlyon/zotero-bits/raw/master/RIS.js and save the file to the translators directory of your Zotero data directory (http://www.zotero.org/support/zotero_data).

    With this version, the entry saves correctly, but I the import tells me it has failed, with the error:
    (1)(+0000000): Invalid item type undefined
    (3)(+0000000): Translate: Discarded field url for item: field not valid for type undefined
    (1)(+0000000): Invalid item type false
    (2)(+0000002): Translate: Translation using RIS failed:
    thrown exception => Invalid item type 'false' in ItemFields.getFieldIDFromTypeAndBase()
    url => /home/ajlyon/Desktop/ris-in
    downloadAssociatedFiles => true
    automaticSnapshots => true

    This is very odd. I first thought that this was happening because I was using the multilingual branch, but now I'm using a fresh, vanilla install of Zotero 2.1.1.

    As I said, this error occurs after the imported entry has saved, so the new item is in the database, Zotero just doesn't create a collection for the import, and the item is therefore not filed away. If anyone can reproduce this or fail to reproduce this with other setups (Firefox versions, operating systems), please let me know.
  • I was able to reproduce this, and it's now fixed on the trunk and 2.1 branch. We will probably push 2.1.2 with this fix relatively soon. Alternatively, we could modify existing import translators to set itemType:"attachment" on each attachment, which should fix import in 2.1.1.
  • It occurs to me that removing L1 fields (which is redundant in the RIS above) should also fix import.
  • We've pushed an updated RIS translator that should take care of this. You will receive it automatically within the next 24 hours, or you can click the "Update now" button in the General section of the Zotero Preferences to get it now.
This discussion has been closed.