Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
batch_uploading_etds_to_scholarworks [2017/02/01 13:37]
ldegozzaldi [Adding “OPT-OUTS” TO Scholarworks Metadata Spreadsheets]
batch_uploading_etds_to_scholarworks [2018/01/23 16:02]
mbanach [Transform MARC.XML file of short-version bibs.+IA URLs to Bepress XML:]
Line 35: Line 35:
  
 This should enter a spreadsheet into the metadata 2 folder: ​ bpimport_date. ​ RENAME with the date and Masters/​PhD,​ and save to personal folder. This should enter a spreadsheet into the metadata 2 folder: ​ bpimport_date. ​ RENAME with the date and Masters/​PhD,​ and save to personal folder.
 +
 +Aaron'​s script is written in Python (Compiled in windows binary so you can't edit that file.  Need to go back to original source, edit, and recompile. ​ Use active python - packaged open source.)  ​
  
 ===== Make adjustments to Bepress spreadsheet ===== ===== Make adjustments to Bepress spreadsheet =====
Line 118: Line 120:
   - Make a new copy of the Master File Sheet 2 (all titles) of the ETD Master File, retaining only columns R (Opt-ins/​Opt-outs),​ A or J (Author), B (Department),​ C (Year), D (Masters/​PhDs) and title (F).  Make sure all data is connected, with no blank columns between, and sort on column R.   - Make a new copy of the Master File Sheet 2 (all titles) of the ETD Master File, retaining only columns R (Opt-ins/​Opt-outs),​ A or J (Author), B (Department),​ C (Year), D (Masters/​PhDs) and title (F).  Make sure all data is connected, with no blank columns between, and sort on column R.
   - Retain only the rows with Opt-out in Column R.    - Retain only the rows with Opt-out in Column R. 
-  - After sorting on R, delete all rows which do not contain "​Opt-out."​ **Transfer any __new__ Opt-out information to ETD Opt-out Tracking sheet.xlsx, also present in the W: Drive in the same location as the Master File.** ​ (Hint: Sort by Department to isolate the new Opt-outs, as reported to us. Run a duplicate check on the ETD Out-out Tracking sheet, to be sure we don't already have any of this added information.)+  - After sorting on R, delete all rows which do not contain "​Opt-out."​ **Transfer any __new__ Opt-out information to ETD Opt-out Tracking sheet.xlsx, also present in the W: Drive in the same location as the Master File.** ​ (Hint: Sort by Department to isolate the new Opt-outs, as reported to us.  Run a duplicate check on the ETD Out-out Tracking sheet, to be sure we don't already have any of this added information.)
   - When the ETD's on the Opt-out list are in process, enter this information on the ETD Opt-out Tracking sheet, together with date.   - When the ETD's on the Opt-out list are in process, enter this information on the ETD Opt-out Tracking sheet, together with date.
   - When the ETD's have been uploaded to ScholarWorks and uploaded and downloaded to Connexion and Aleph, enter DONE on the ETD Opt-out Tracking sheet, together with date.   - When the ETD's have been uploaded to ScholarWorks and uploaded and downloaded to Connexion and Aleph, enter DONE on the ETD Opt-out Tracking sheet, together with date.
batch_uploading_etds_to_scholarworks.txt · Last modified: 2019/01/07 12:20 (external edit)
[unknown link type]Back to top
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