This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
batch_uploading_etds_to_scholarworks [2019/01/07 17:20] 127.0.0.1 external edit |
batch_uploading_etds_to_scholarworks [2020/05/04 22:11] ldegozzaldi |
||
---|---|---|---|
Line 46: | Line 46: | ||
- PhD’s: All other entries will have “dissertation” in this column. | - PhD’s: All other entries will have “dissertation” in this column. | ||
- Masters: Correct the Department column heading to degree_prog | - Masters: Correct the Department column heading to degree_prog | ||
- | - Keyword fix: Go to scholmasters or scolphd file in MarcEdit and download 600's, 610's, 650’s and 651’s with all subheadings to an Excel spreadsheet. Combine lines per record, remove periods, $x, $y, $z. Remove comma between Subject headings and Subdivisions, retain commas between separate entries only. Remove parentheses. Run Compare line differences using the 776 value to be sure MarcEdit/bpimport matches, then paste new Keyword entries into the bpimport spreadsheet. | + | - Keyword fix: Go to scholmasters or scolphd file in MarcEdit and download 600's, 610's, 650’s and 651’s with all subheadings to an Excel spreadsheet. Combine lines per record, remove periods, $x, $y, $z. Remove comma between Subject headings and Subdivisions, retain commas between separate entries only. Remove parentheses. Run Compare line differences using the 776 value to be sure MarcEdit/bpimport matches, then paste new Keyword entries into the bpimport spreadsheet. |
+ | - NOTE: The program name in the cataloging record must be that which is provided by the Graduate Office on the spreadsheet. Do not use any variant form or department listed on the title page. A copy of the Degree Programs and their codes can be found in [[Graduate Degree Program Codes]]. | ||
- **NOTE: The final file needs to be saved (and uploaded) as “Excel 97-2003 Worksheet”!!!!** | - **NOTE: The final file needs to be saved (and uploaded) as “Excel 97-2003 Worksheet”!!!!** | ||