This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
scholarworks_instructions_for_batch_revision_of_one_year_campus_access_etds_to_open_access [2015/11/05 21:24] mbanach |
scholarworks_instructions_for_batch_revision_of_one_year_campus_access_etds_to_open_access [2016/05/24 20:09] mbanach |
||
---|---|---|---|
Line 14: | Line 14: | ||
Click on the Generate button to get a spreadsheet of all of the current data from the Masters Theses May 2014 - current series | 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 | Under spreadsheet history click Download spreadsheet | ||
- | Sort by publication date | + | 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 | ||
- | Copy and paste all newer dissertations and theses into another spreadsheet | + | Save and name spreadsheet February 2015 campusone to open access (in Feb 2016) or May 2015 in May 2016 |
- | Delete all newer dissertations and theses from the batch revise spreadsheet | + | Go back to ScholarWorks and upload revised spreadsheet |
- | Use control F to find and replace all campusone document types and change to openaccess | + | |
Change schedule: | Change schedule: |