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
>> > >
>> >
>>
>
>