Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

RIS import from Zotero

Help
PeterG
2013-02-01
2013-05-28
  • PeterG
    PeterG
    2013-02-01

    Hi all,
    I am trying to import references from Zotero into Refbase using the RIS format. This in general works, but some fields are confused.
    For both journal article and book chapter, the publication title is T2 and this is imported as 'Abbreviated Journal Title'.
    For book chapters, the editors of the book (A3), publisher, place, series are not imported/shown.
    For an edited book, the editors (A3) are not shown and imported as series editors.

    I've included some examples from the Zotero export below.
    It seems that the Zotero's RIS format is different from the one used in refbase. I would be grateful, if somebody could give me some hints how to solve this.

    Thank you very much,
    Peter

    TY  - JOUR
    TI  - Woher kommt das x in Luxemburg?
    AU  - Kollmann, Cristian
    T2  - Beiträge zur Namenforschung
    CN  - LB 72053 |4 Bibliothèque nat. Luxembourg |5 Luxemburgensia
    DA  - 2011///
    PY  - 2011
    DP  - catalog.bibnet.lu Library Catalog
    VL  - 46
    IS  - 2
    SP  - 165
    EP  - 209
    N1  - <p>Sonderdruck aus: Beiträge zur zur Namensforschung, Bd. 46 - Heft 2(2011)</p>
    KW  - Luxembourg
    KW  - Onomastique
    ER  - 
    TY  - JOUR
    TI  - Auf der Suche nach Mahowald
    AU  - Kollmann, Christian
    T2  - Hémecht. Zeitschrift für Luxemburger Geschichte
    CN  - L11.HEM |4 Lycée Hubert Clément |5 Salle de lecture 2
    DA  - 2011///
    PY  - 2011
    DP  - catalog.bibnet.lu Library Catalog
    VL  - 63
    IS  - 3
    SP  - 351
    EP  - 262
    KW  - Mahowald
    ER  - 
    TY  - CHAP
    TI  - Die Luxemburger Verwaltungssprache des Spätmittelalters aus regionalsprachlicher Perspektive
    AU  - Ravida, Fausto
    T2  - Linguistische und soziolinguistische Bausteine der Luxemburgistik
    A2  - Gilles, Peter
    A2  - Wagner, Melanie
    T3  - Mikroglottika. Minority language studies
    CN  - 0000
    CY  - Frankfurt a.M. [et al]
    DA  - 2011///
    PY  - 2011
    DP  - Amazon.com
    ET  - 1., Aufl.
    SP  - 83
    EP  - 99
    PB  - Peter Lang
    SN  - 3631630646
    ER  - 
    TY  - BOOK
    TI  - Linguistische und soziolinguistische Bausteine der Luxemburgistik
    T2  - Mikroglottika. Minority language studies
    A3  - Gilles, Peter
    A3  - Wagner, Melanie
    CN  - 0000
    CY  - Frankfurt a.M. [et al]
    DA  - 2011///
    PY  - 2011
    DP  - Amazon.com
    ET  - 1., Aufl.
    SP  - 347
    PB  - Peter Lang
    SN  - 3631630646
    ER  -
    
     
  • Hi Peter,

    sorry to hear you're facing trouble on import. Unfortunately, the RIS format specification has always been very vague (and recently has been changed substantially). This leads to different applications implementing RIS differently.

    As an alternative to exporting RIS files from Zotero, have you tried exporting as MODS XML from Zotero and importing the resulting MODS file into refbase? Does this work any better?

    W.r.t. import of RIS records into refbase, here's how refbase handles the fields you were having trouble with::

    For journal articles (JOUR):

    * Use JO or JF for the publication title (= periodical name)
    * Use AD for the author address(es)

    For book chapters (CHAP):

    * Use BT for the publication title (= book title)
    * Use ED or A2 for the book editors

    For books (BOOK):

    * Use ED or A2 for the book editors
    * Use A3 for the series editors
    * Use BT or T3 for the full series title

    Other notes:

    The database provider (DP) field is currently not imported. refbase-0.9.5 does also ignore the edition (ET) field on import, but this has been corrected in the development version.

    Given your CHAP & BOOK examples, refbase should correctly import the publisher, place & series title. Have you cross-checked with the result when importing your sample records at http://demo.refbase.net ?

    If you have full control over your refbase server you could also adopt the RIS <-> refbase field mappings in order to improve import from Zotero RIS files. To do so, open file 'includes/import.inc.php', go to function 'risToRefbase()' and find the '$tagsToRefbaseFieldsArray'. This array contains all the RIS <-> refbase field mappings. You can change the two-letter RIS field labels there so that they match Zotero's RIS output.

    You could also try whether the Bibutils RIS importer works better than the native refbase RIS import function. To do so, you'd need to execute following MySQL command on your refbase MySQL database:

    UPDATE formats SET format_spec = 'bibutils/import_ris2refbase.php', depends_id = 2 WHERE format_name = 'RIS' AND format_type = "import";
    

    However, since refbase has tried to closely match the Bibutils output, this may not make for any big differences.

    HTH, Matthias

     
  • PeterG
    PeterG
    2013-02-01

    Lieber Matthias,
    I modified the field mapping in \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'includes/import.inc.php\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\' and was then able to import the records in the way I wanted them.

    Importing a MODS XML file, however, fails with an unspecific error (There were validation errors regarding the data you entered:).

    Thank you!
    Peter