====== PAGE OUTDATED ARCHIVED ======

====== ScholarWorks instructions for batch revision of one year campus access ETDs to open access ======



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