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 <[log in to unmask]> 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: [log in to unmask]
> Telephone: 0121 288 6936
>
> On 15 Oct 2012, at 13:37, Mita Williams <[log in to unmask]> 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 <[log in to unmask]>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 <[log in to unmask]>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 <[log in to unmask]
>>>>> 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:[log in to unmask]] On Behalf Of
>>>>> Roy Tennant
>>>>> Sent: Thursday, October 04, 2012 10:44 AM
>>>>> To: [log in to unmask]
>>>>> 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 <[log in to unmask]
>>>>>> 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
>>>>>>
>>>>>
>>>>
>>>
>>>