Document Type

Conference Proceeding

Publication Date



This is a PDF of the slide presentation given by the authors at the 2012 CALI Conference for Law School Computing, held June 21-23, 2012 at the Thomas Jefferson School of Law in San Diego, CA.

The CALI session discussed the trend among law schools towards an open access publishing model for both faculty scholarship and student law reviews. Included was a brief overview of the Durham Statement on open access legal publishing and the advantages for law schools that move to this publishing model (including improved accessibility and access and even increased citation rates). Additionally, the session focused on ways to promote an institutional repository within a law school and how to develop relationships with faculty and other stakeholders to acquire content.

Once a journal has been moved to an open access publishing model, metadata for all of the articles in the journal’s backfile must be gathered and uploaded to the journal’s online site. Before it can be uploaded, the metadata must be parsed to match the structure of the journal’s web site. The last part of the session described how Santa Clara Law, which recently moved all three of its student law reviews to an open access publishing model using Digital Commons from BePress, automated the process of gathering, parsing and uploading metadata for the backfiles of its law reviews via spreadsheets, thus saving a tremendous amount of time and human effort.


Additional files include:

BigKahuna workbook, containing all functions used to create a finished spreadsheet ready to be uploaded to the digital commons.

Instruction document for gathering metadata and using the BigKahuna workbook.

Workbook with sample functions for performing specific parsing tasks

BigKahuna.xls (2816 kB)
The spreadsheet with all functions needed to parse metadata into a usable form for uploading into Digital Commons

Instructions for Creating Data Sets in Excel for Journals in Bepress Digital Commons.pdf (1359 kB)
Instructions for gathering metadata for your journals and using the BigKahuna spreadsheet

Formula samples.xls (71 kB)
Sample formulas for parsing specific metadata

Included in

Law Commons



To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.