This is an old revision of the document!
Changing one year campus access titles to open access in ScholarWorks
Login to ScholarWorks http://scholarworks.umass.edu/cgi/login.cgi?return_to=http%3A%2F%2Fscholarworks.umass.edu%2Fcgi%2Fmyaccount.cgi%3Fcontext%3D&context=http://scholarworks.umass.edu
Go to SW home page http://scholarworks.umass.edu/
Click on Dissertations and Theses http://scholarworks.umass.edu/etds/
Click on Doctoral Dissertations May 2014 - current or Masters Theses May 2014 - current
Click on Manage Dissertations or Manage Theses at top of page
Click on Batch Revise Excel
Click on the Generate button to get a spreadsheet of all of the current data from the Masters Theses May 2014 - current series
Wait for it to download
Click refresh on your browser if it gets stuck and says pending for too long
Under spreadsheet history click Download spreadsheet
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
Use control F to find and replace all campusone document types and change to openaccess
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
Change schedule:
In February 2016: Change all February 2015 (or earlier) theses and dissertations from campusone to openaccess
In May 2016: Change all May 2015 (or earlier) theses and dissertations from campusone to openaccess
In September 2016: Change all September 2015 (or earlier) theses and dissertations from campusone to openaccess