Differences

This shows you the differences between two versions of the page.

--- scholarworks_instructions_for_batch_revision_of_one_year_campus_access_etds_to_open_access [2015/11/05 21:00]
mbanach
+++ scholarworks_instructions_for_batch_revision_of_one_year_campus_access_etds_to_open_access [2016/05/24 20:09]
mbanach
@@ Line 7: / Line 7: @@
 Click on Dissertations and Theses
-Click on Doctoral Dissertations May 2014 - current or
+Click on Doctoral Dissertations May 2014 - current or Masters Theses May 2014 - current
-Click on Manage dissertations at top of page
+Click on Manage Dissertations or Manage Theses at top of page
-Click on batch revise Excel
+Click on Batch Revise Excel
-Download spreadsheet
+Click on the Generate button to get a spreadsheet of all of the current data from the Masters Theses May 2014 - current series
-Sort by publication date then document type
+Wait for it to download
-Use control F to find all campusone document types for the for disserations that were published one year ago or more and change document type from campusone to openaccess
+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: