Automating Your Way to Easy Faculty Scholarship Collection…

Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,*,*,AutomatingYourWaytoEasyFacultyScholarshipCollectionDevelopment,Margaret Heller,Loyola University Chicago,|margaret_heller,Introduction,The Problem,Faculty arent always motivated to participate in an institutional repository:success lies in being able to create a set of services with a an eye to quality and robust metadata.,Giesecke,Joan.“Institutional Repositories:Keys to Success.Journal of Library Administration 51,no.5/6(September 2021):529542.doi:10.1080/01930826.2021.589340.,Liaisons can provide a personal touch,but how to get them to add this to their already busy schedules?,Remove friction through automation.,Approach#1:Quarterly Reports,Thanks to,Flynn,Stephen X.,Catalina Oyler,and Marsha Miles.“Using XSLT and Google Scripts to Streamline Populating an Institutional Repository.The Code4Lib Journal,OpenRefine,Steps for quarterly reports,Search databases(Web of Science and Academic Search Complete).,Import into RefWorks.,Remove duplicates.,Export as CSV.,Import into Excel for data cleanup.,Import into OpenRefine and apply saved JSON.,Export into Excel and add some pretty colors and liaison names.,Save onto Box collaborative workspace and assign due date for contact.,Final product,Approach#2:The poor mans Kickstart,OpenRefine,Step by step at:Heller,Margaret.“A Librarians Guide to OpenRefine.ACRL TechConnect Blog,Steps for CV analysis,Copy CV into text editor and clean up text as much as you can.,Import into OpenRefine.,Attempt to run saved JSON.When this doesnt work,figure out why and repeat steps 1&2.,If saved recipes fail,create new one by isolating each bibliographic element.Favor journal title.Then run the JSON to get SHERPA/RoMEO data.,Export the report as Excel,and clean up data as necessary.,Rename column names so they make sense to faculty.,Email with requests for post-prints.,Example CV report(with some extra conditions filled in),Results:75+items of faculty scholarship,Quarterly report,March 2021:75 items identified,16%posted in repository;25%of the total items where faculty were definitely contacted.,Kickstart,5 faculty had CVs analyzed thanks to contacts from quarterly report.,3 additional faculty thanks to liaison outreach.,What worked,Student worker dedicated to the project.,Contact faculty at opportune times.,Help liaisons when the situation gets too complicated.,Manage rights and permissions yourself.,Verify all files and metadata for user submitted content.,What didnt work,Some liaisons will have a harder time following through.,Political issues can keep the project from moving forward.,Thank you!,Contact me at|margaret_heller,