Changing one year campus access titles to open access in ScholarWorks

Login to ScholarWorks

Go to SW home page

Click on Dissertations and Theses

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 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

In February 2017: Change all February 2016 (or earlier) theses and dissertations from campusone to openaccess

In May 2017: Change all May 2016 (or earlier) theses and dissertations from campusone to openaccess

In September 2017: Change all September 2016 (or earlier) theses and dissertations from campusone to openaccess

changing_one_year_campus_access_titles_to_open_access.txt · Last modified: 2016/05/24 16:19 by mbanach
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0