Likewise Mendeley also has an API, which gives you a JSON array of the citation data (http://apidocs.mendeley.com/home/public-resources/search-details) There are some JSON -> CSV scripts around: http://stackoverflow.com/questions/4130849/convert-json-format-to-csv-format-for-ms-excel which I've used with varying degrees of success.
You could probably also use the SQLite trick on a local Mendeley DB, but ideally this is something that should work without the need for such hacks. We've done some work on a Mendeley -> Symplectic Elements -> IR workflow and hopefully can extend this to work for more IRs in the future. William Gunn +1 646 755 9862 http://synthesis.williamgunn.org/about/ Support free access to scientific journal articles arising from taxpayer-funded research: http://wh.gov/6TH On Mon, Oct 15, 2012 at 5:45 AM, Owen Stephens <o...@ostephens.com> wrote: > No idea if this is useful, but just to note that RefWorks also has an API in > case that offers any more options to you in terms of pushing the data around > http://rwt.refworks.com/rwapireference/ > > Owen > > Owen Stephens > Owen Stephens Consulting > Web: http://www.ostephens.com > Email: o...@ostephens.com > Telephone: 0121 288 6936 > > On 15 Oct 2012, at 13:37, Mita Williams <mita.willi...@gmail.com> wrote: > >> Here's the summary of the summary of what we've found out >> (the full summary is here: >> http://librarian.newjackalmanac.ca/2012/10/bibliographic-software-bepress.html >> ) >> >> Roy Tennant, some years ago, created a Perl script that collects the latest >> citations in Web of Science via their WSDL. Lisa Schiff kindly found this >> script and sent it my way. While the script is admittedly out of date (and >> Web of Science now provides an API for this sort of thing) it still will >> prove useful if and when we get to a point in which we want to automate and >> script our workflow. [Thank you Roy, Kirk Hastings, and Lisa Schiff!] >> >> And here are some things that we’ve figured out ourselves: >> >> Between Zotero and RefWorks, Zotero exports the cleanest results to excel >> format. RefWorks can easily export to Excel, while Zotero requires the use >> of an SQLite extension and this script ( >> https://github.com/RoyceKimmons/Zotero-to-Excel-SQLite-Export/blob/master/export.sql) >> kindly provided by Royce Kimmons. On this page ( >> http://royce.kimmons.me/node/24) Kimmons explains how one can select one or >> more Zotero collection/folder for export. >> >> No one that we know of has created an Excel macro to automate transferring >> the result of an export to Excel from RefWorks or Zotero to ease the >> cutting and pasting necessary to get the information into BePress’s Excel >> Spreadsheet. >> >> An alternative means of sharing citations is to avoid Excel exporting >> altogether and instead, have staff make their papers available on >> Zotero.org in a public library and have the IR coordinator use Zotero to >> download the citations using that are either tagged as appropriate (e.g. >> https://www.zotero.org/copystar/items/tag/publisherPDF) or those that have >> been placed in a given collection folder (e.g. >> https://www.zotero.org/copystar/items/collectionKey/THDEN26X). >> >> Papers on BePress can be added to Zotero on each item level page but not on >> a collection page. Improving this capability would require creating a >> special Zotero translator for BePress: >> https://github.com/zotero/translators/issues/212 >> >> Thank you everyone who has helped us work through this. I hope what we’ve >> learned proves useful to you as well. >> >> >> On Fri, Oct 5, 2012 at 3:20 PM, Mita Williams <mita.willi...@gmail.com>wrote: >> >>> Yes, a partner in crime has asked a similar question in the bepress list >>> and I've been talking to a Zotero developer as well. >>> >>> Once I get this pieces into context, I will definitely share back with the >>> rest of the list. It's the least I can do. Much thanks all >>> >>> >>> On Fri, Oct 5, 2012 at 12:43 PM, lindsey danis <danis....@gmail.com>wrote: >>> >>>> There is a discussion on this topic right now in the Digital Commons >>>> Google Group, fyi. >>>> >>>> On Fri, Oct 5, 2012 at 12:40 PM, Sam Kome <sam_k...@cuc.claremont.edu >>>>> wrote: >>>> >>>>> At some point bring it back to the list, please. Enquiring minds want to >>>>> know... >>>>> >>>>> Thanks, >>>>> >>>>> SK >>>>> >>>>> -----Original Message----- >>>>> From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of >>>>> Roy Tennant >>>>> Sent: Thursday, October 04, 2012 10:44 AM >>>>> To: CODE4LIB@LISTSERV.ND.EDU >>>>> Subject: Re: [CODE4LIB] Citation manager --> ??? --> BePress Bulk-upload >>>>> Excel spreadsheet >>>>> >>>>> Mita, >>>>> A while back (I mean at least six years ago) I wrote some code to take >>>>> citations downloaded from an index provider, reformat them into bepress >>>>> spreadsheet format, and bulk upload them. The purpose of the project >>>> was to >>>>> identify published articles by University of California faculty, email >>>> them >>>>> that we had citations of their work in our system, and wouldn't they >>>> like >>>>> to upload their copy of their article into the repository? I don't have >>>> the >>>>> numbers on that project, but I recall that it did boost submissions. >>>>> >>>>> Unfortunately, I think the code, which was likely crappy anyway, has >>>> long >>>>> since moldered to dust on a server somewhere that I no longer have >>>> access >>>>> to, but I can put you in touch with someone at UC who might be doing >>>>> something like this. I'll email you off-list. >>>>> Roy >>>>> >>>>> On Thu, Oct 4, 2012 at 9:32 AM, Mita Williams <mita.willi...@gmail.com >>>>>> wrote: >>>>> >>>>>> We're trying to figure out a workflow for our BePress IR and was >>>>>> curious if anyone in code4libland has developed "something" (an Excel >>>>>> macro? a Zotero export function?) that could take formatted citations >>>>>> and put them in the proper order so they could be bulk added to the >>>>>> BePress bulk upload Excel spreadsheet. Or perhaps there's an >>>>>> altogether different way of going about collecting, formatting, and >>>>> adding such things for BePress. >>>>>> >>>>>> Everything counts in large amounts. >>>>>> Mita >>>>>> >>>>> >>>> >>> >>>