This is an old revision of the document!
Changing one year campus access titles to open access in ScholarWorks
Login to ScholarWorks
Click on Doctoral Dissertations May 2014 – current
Click on manage dissertations
Click on batch revise excel
Generate a spreadsheet of current data from Doctoral Dissertations May 2014 – current
Wait for it to download
Click refresh on your browser if it gets stuck and says pending for too long
Click on download
click filter
click arrow at top of the document type column
Select campusone
Sort spreadsheet by publication date oldest to newest
Delete all of the titles that have a publication date of less than 1 year ago
Highlight whole spreadsheet
Change all values campusone to openaccess using find and replace
Save and name spreadsheet February 2015 campusone to open access (in Feb 2016) or May 2015 in May 2016
Go back to ScholarWorks and upload revised spreadsheet