Document Type


Publication Date



Ideally, bulking up an institutional repository with a full listing of faculty publications is a worthy goal, but how can that be accomplished within a reasonable time period? Cleveland State University implemented Digital Commons in March 2012 with the KickStart program. Since then, faculty publications have been added at a steady, but slow pace. Through a collaborative effort, our Digital Initiatives Librarian worked with others to refine batch processing to increase the flow of record creation and document loading into EngagedScholarship@CSU. With the use of Excel, scripts, faculty CVs and Google Drive, the staff is finding new ways to automate the process of populating our IR. This presentation will discuss the technical components that move the process along and the personnel components that make this process work. CSU is also exploring the use of bibliographic information reported from Faculty Annual Activity Reports (FAAR) to capture current faculty scholarly activities.

ESworkflow_in-depth.pdf (2056 kB)
Flexible workflow for IR work

workflow_customization.docx (12 kB)
Notes on customizing the workflow

CustomCitationMacroV2.bas (11 kB)
Custom Citation Macro v.2 by Jeff Beuck, Cleveland State University

macro_instructions.pdf (32 kB)
Instructions to add the custom citation macro to a spreadsheet

batch_upload_setup.pdf (408 kB)
Documentation for Google Drive batch upload setup

getURLs_apps_script.txt (1 kB)
getURLs Apps Script

fulltext_URLs_instructions.pdf (125 kB)
Instructions for using the getURLS Apps Script