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.
Strauss, Barbara and Miles, Marsha, "Automating Workflow: From a Trickle to a Stream" (2014). Michael Schwartz Library Publications. 105.
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