dfalster/RZotero - 0 views
-
Chris Fung on 04 Nov 14"RZotero This is a set or routines for interacting with my Zotero library. I love Zotero, but it lacks some key features. Hence I was interested to see if these could achieve some of the things I was after in R. Note, this material is in development and not currently working, so I do not recommend using it, at this stage. My Zotero Wish List Here are some of the features I would like: Find and replace function Ability to automatically clean journal names, according to a list of journal name substitutions Ability to modify the author list Ability to retrieve missing abstracts based on DOI Ability to find missing DOIs Ability to delete many (all) tags (i had hundreds) Ability to analyse data from my library in R. The best thing about Zotero is that it's open source and free. The software is maintained by a community of developers who give their time for free, and are actively working on improving it. However, there is also limited resources and a long queue of feature requests: @adaptive_plant @_inundata one thing @zotero does not lack is requests for features... much more helpful would be patches to 100+ tickets - adam.smith (@adam42smith) April 20, 2013 Accessing Zotero via the Sql database The best way of interacting with your Zotero library is to write some code which connects to Zotero's server or Javascript API. Unfortunately I don't have the requisite skills to do this. Another option is to access Zotero the local copy of Zotero's sqlite database. That is the approach I have taken here. Working with the sql database is fine for read-only actions. Writing to the sql database is not recommended as any updates may not be passed on to server, meaning you have to reset the server data to get the update processed. To get started, I followed the example code here , which uses the "RSQLite" package. Database structure The database structure is described here. An easy way to familiairse yourself with the structure is to download sqlitebrowser and poke aro