Export library to WOS-like tab delimited format

eparimbelli
Hi all,
I'm looking for a way of exporting a zotero collection I have into a tab-delimited file with the same format that web of science outputs when you export result of a search to "other file format">>"tab delimited file" (exporting full record).
My purpose is to use this with the nails software (http://nailsproject.net/) to run some bibliographic analyses, and produce network files (nodes and edges) to create some nice visualization of my corpus using gephi.

has anyone tried this?
any suggestion on a way to achieve it?
  • eparimbelli
    From a visual inspection of the WOS output each referewnce in the tab-delimited file looks like this (is this any known reference format?):

    PT J
    AU Kularatne, D
    Hsieh, MA
    AF Kularatne, Dhanushka
    Hsieh, M. Ani
    TI Tracking attracting manifolds in flows
    SO AUTONOMOUS ROBOTS
    LA English
    DT Article
    DE Marine robotics; Manifold tracking; LCS; Distributed robot systems
    ID LAGRANGIAN COHERENT STRUCTURES; EFFICIENT NAVIGATION; TRAJECTORIES;
    ABSTRACTION; EXPLICIT; ROBOTS; SWARMS; MODEL
    AB This paper presents a collaborative control strategy designed to enable a team of robots to track attracting Lagrangian coherent structures (LCS) and unstable manifolds in two-dimensional flows. Tracking LCS in flows is important for many applications such as planning energy optimal paths in the ocean and for predicting the evolution of various physical and biological processes in the ocean. The proposed strategy which tracks attracting LCS and unstable manifolds in real-time through direct computation of the local finite time Lyapunov exponent field, does not require global information about the dynamics of the surrounding flow, and is based on local sensing, prediction, and correction. The collaborative control strategy is implemented on a team of robots and theoretical guarantees for the tracking and formation keeping strategies are presented. We demonstrate the performance of the tracking strategy in simulation using actual ocean flow data and experimental flow data generated in a tank. The strategy is validated experimentally using a team of micro autonomous surface vehicles in an actual fluid environment.
    C1 [Kularatne, Dhanushka; Hsieh, M. Ani] Drexel Univ, Scalable Autonomous Syst Lab, Philadelphia, PA 19104 USA.
    RP Kularatne, D (reprint author), Drexel Univ, Scalable Autonomous Syst Lab, Philadelphia, PA 19104 USA.
    EM dnk32@drexel.edu; mah349@drexel.edu
    FU Office of Naval Research (ONR) [N000141211019, N000141310731]; National
    Science Foundation (NSF) [IIS-1253917]
    FX This work was supported by the Office of Naval Research (ONR) Awards
    Nos. N000141211019 and N000141310731 and the National Science Foundation
    (NSF) Grant IIS-1253917.
    CR Belta C, 2005, SPRINGER TRAC ADV RO, V15, P224
    Belta C, 2004, IEEE T ROBOTIC AUTOM, V20, P865, DOI 10.1109/TRO.2004.829498
    Forgoston E, 2011, CHAOS, V21, DOI 10.1063/1.3539836
    Haller G, 2000, PHYSICA D, V147, P352, DOI 10.1016/S0167-2789(00)00142-1
    Haller G, 2011, PHYSICA D, V240, P574, DOI 10.1016/j.physd.2010.11.010
    Harrison CS, 2012, GEOPHYS ASTRO FLUID, V106, P22, DOI 10.1080/03091929.2010.532793
    Heckman CR, 2015, INT J ROBOT RES, V34, P1590, DOI 10.1177/0278364915585396
    Hsieh M. A., 2012, P IEEE INT C ROB AUT
    Hsieh M. A., 2014, P 2014 AM CONTR C PO
    Inanc T, 2005, P AMER CONTR CONF, P674, DOI 10.1109/ACC.2005.1470035
    Kularatne D, 2015, P ROB SCI SYST ROM I
    Larkin D., 2014, ASME INT DES ENG TEC
    Larkin D. J, 2015, THESIS
    Lermusiaux P, 2005, DYNAMICAL SYSTEM MET
    Mallory K, 2013, NONLINEAR PROC GEOPH, V20, P657, DOI 10.5194/npg-20-657-2013
    Michini M., 2014, P IEEE RSJ INT C INT
    Michini M., 2014, P AM CONTR C ACC 201
    Michini M, 2014, IEEE T ROBOT, V30, P593, DOI 10.1109/TRO.2013.2295655
    NUSSE HE, 1989, PHYSICA D, V36, P137, DOI 10.1016/0167-2789(89)90253-4
    Olascoaga MJ, 2008, J GEOPHYS RES-OCEANS, V113, DOI 10.1029/2007JC004533
    Olascoaga MJ, 2012, P NATL ACAD SCI USA, V109, P4738, DOI 10.1073/pnas.1118574109
    Oppenheim A, 2016, SIGNALS SYSTEMS INFE
    Raffel M, 2007, EXP FLUID MECH, P1, DOI 10.1007/978-3-540-72308-0
    SCRIPPS, 2014, NAT HF RADAR NETW SU
    Senatore C, 2008, P AMER CONTR CONF, P1244, DOI 10.1109/ACC.2008.4586663
    Shadden SC, 2005, PHYSICA D, V212, P271, DOI 10.1016/j.physd.2005.10.007
    Shchepetkin AF, 1998, MON WEATHER REV, V126, P1541, DOI 10.1175/1520-0493(1998)126<1541:QMASBO>2.0.CO;2
    Shchepetkin AF, 2005, OCEAN MODEL, V9, P347, DOI 10.1016/j.ocemod.2004.08.002
    Smith RN, 2010, INT J ROBOT RES, V29, P1475, DOI 10.1177/0278364910377243
    Wiggins S, 2005, ANNU REV FLUID MECH, V37, P295, DOI 10.1146/annurev.fluid.37.061903.175815
    Zhang FM, 2010, IEEE T AUTOMAT CONTR, V55, P800, DOI 10.1109/TAC.2010.2040508
    NR 31
    TC 0
    Z9 0
    U1 98
    U2 98
    PU SPRINGER
    PI DORDRECHT
    PA VAN GODEWIJCKSTRAAT 30, 3311 GZ DORDRECHT, NETHERLANDS
    SN 0929-5593
    EI 1573-7527
    J9 AUTON ROBOT
    JI Auton. Robot.
    PD DEC
    PY 2017
    VL 41
    IS 8
    BP 1575
    EP 1588
    DI 10.1007/s10514-017-9628-y
    PG 14
    WC Computer Science, Artificial Intelligence; Robotics
    SC Computer Science; Robotics
    GA FC7SA
    UT WOS:000407041200002
    OA No
    DA 2017-11-02
    ER
  • adamsmith
    Sorry, Zotero doesn't output that format. It's vaguely related to RIS, so if you do want to do this yourself, that's where you would likely want to start, but it's a very significant amount of effort to do this.
  • eparimbelli
    Mmmmm, I understand. I was kind of hoping it still was some known format that I could get out of zotero.
    Exporting a RIS and coming up with a script able to convert it into this is something I'm not really sure is worth the effort.

    Any other suggestion? Is this format handled/able to be exported by any other ref software? Zotero is what I rely on but if I need to first export to, say Endnote or Mendeley, and then be able to export this format it would be great.

    Disclosure note: I still would like zotero the best.... I just think that it's a pity that other nice open-source and free tools that are being developed out there (like this nails tool) are created to depend on a specific database (like WOS in this case, or PubMed as I saw in other cases) and not on well-established formats like RIS or similar
  • adamsmith
    definitely not Mendeley. I don't know about Endnote.
  • bwiernik
    Endnote can only import, not export ISI format. The ISI format is very lossy on import to many tools, so I would try to avoid it if at all possible.
  • DWL-SDCA
    edited November 2, 2017
    Allow me to echo and expand on what @bwiernik said. I’ll go further and say that I’ve found ISI-tagged format available from WoS to 1) omit some author names; 2) omit some of the references that are included in the WoS website record; and 3) truncate titles so to omit subtitles. I find 1 and 3 most troublesome. With #3 you can get for example: The importance of the literature when forming policy. Part 1: What databases to search. The importance of the literature when forming policy. Part 2: Properly constructing your search with database-specific index terms. The importance of the literature when forming policy. Part 3: Winnowing your search results. etc. The ISI format results will often give you 3 items titled, “The importance of the literature when forming policy” and not the full titles. If you click the Zotero download button from WoS you will get full titles. (I listed imaginary titles for my examples.) For your purposes my item 2 will probably present the greatest source of bias.

    Out of my own curiosity, please share the purpose of your desire for the ISI-tagged file. Is that the only format allowed with Nails? When I spent time looking at the format I was thinking about writing a manuscript about the purposes, strengths, and weaknesses of several metadata storage and transport formats. I learned a lot about metadata transport and realized that no one in their right mind would want to read my attempt to compare and contrast the various formats.
  • bwiernik
    Actually, it looks like the Publish or Perish program might be able to import this format and then export to various more useful ones.

    https://harzing.com/pophelp/importing.htm#wos
  • DWL-SDCA
    Off topic:

    When calculating authorship stats, it is clear that Publish or Perish makes multiple calls to Google Scholar. Does it use some mechanism that could be used by Zotero to reduce the risk of being labeled a robot?
  • adamsmith
    they have the same captcha problem Zotero has (there's an FAQ about that on the site) -- Since they don't need the bibtex they make a couple fewer calls and Google seems particularly concerned about bibtex scraping so it may take a bit longer to kick in.
  • sir_ussy
    @eparimbelli Hi i wondering if you find a way around this problem. I currently in the same situation as u are
  • bwiernik
    No, this format is not widely used and is lossy, so an export translator has not been written for it. I recommend using CSL-JSON, RIS, or BibTeX.
Sign In or Register to comment.