This document puts in place the basics for harvesting the University's ETD dissertations, masters theses, MFA theses and LARP terminal projects in Scholarworks via an OAI-PMH crosswalk using an XML and XSLT script.
Copy the OAIDCtoMARCXMLmodified.xsl file and Marc21slimUtils file from the R: drive (Theses → OAI MarcEdit Crosswalk) to your own computer C: drive
Open MarcEdit. Make sure it is set to the SAXON.NET XSLT Engine due to XSLT 2.0 being used in the XML file. (Go to Tools –> Preferences –> MarcEngine)
Click on 'Harvest OAI Records'. In the popup Metadata Harvester window, input:
englmfa_theses OR larp_ms_projects
Note: this metadata type the Qualifed Dublin Core records. Simple Dublin Core will not allow us to extract degree names nor departments.
Click on Advanced Settings.
Add the Start and End date. Must follow the format of yyyy-mm-dd - for example, 2015-02-01 / 2015-05-31. This will harvest any new files uploaded to Scholarworks in that time period (i.e., February ETDs). You may have to tinker with the dates to capture all the files desired.
Click on OK. Harvesting will commence and filter through the C: drive .xsl file. The results will be displayed a MarcEditor window.
Compare the list of names against the 'packing list' spreadsheet provided by the Graduate School. (This is easier to do if you alphabetically sort the MarcEditor list via Tools → Sort by.) There may be eTDs with earlier publication dates which already have in-house cataloged records in OCLC and Aleph. Delete any records which would generate duplicate bib records. There may also be Master of Fine Arts eTDs in the packing list. These will be in the englmfa_masters set and will need to be harvested separately. Occasionally there are names on the packing list which are not harvested at all. The cause of these will need to be investigated separately.
Important! The Task List will not pick up the appropriate date needed for the Fixed Field. This will have to be changed by hand. Example: if the harvested records are all from a 2016 packing list, then change the Task List (Example: 008, 151111s2015 to 151111s2016). Otherwise, change by hand in MarcEditor after running the Task List.
In the menu bar of the MarcEditor file, click on Tools –> Assigned Tasks –> then click on one of the following as appropriate:
This will run the harvested records through the MarcEdit task list. Save the results to your hard drive as a .mrk file (ex: C:\Crosswalk\Converted\OAIMastersFeb2015.mrk)
A breakdown of each task run in the Task List can be found in MarcEdit Task List for Dissertations and Theses
There are times an author's name is in all lower case or CAPS, and/or a title is in ALL CAP. The easiest way to rectify this is in MarcEditor via Edit –> Edit Shortcuts –> Change Case –> Capitalize Initial character.
The Task List unfortunately cannot catch every single error produced in a personal name after it has been inverted. In particular, watch out for names with qualifiers (William, $q(Bill)) and names already inverted in Scholarworks (Morgan, Michael becomes MichaelMorgan).
The XSLT crosswalk script will automatically convert up any non-comforming punctuation (single left and right quotation marks, left and right double quotation marks, En dash, Em dash) and for the most part can also handle diatritics. But for the odd stray, the following instructions are for correcting each record by hand in Connexion.
Open the MRK_BadCharRdr application on your desktop (available from Systems). This will open the directory in your C: drive to which you previously saved the above .mrk file.
Select and open the file. (The file folder type is Mnemonic MarcEditor File). The script will then run through the file and save the results in an Exel file under the same filename in the same C: directory.
Each record with a bad character is listed by number and shows the MARC field involved as well as the codes for each bad character. Set this list aside.
Click on the Marc Tools button and input:
Input file: .mrk filename as above (C:\Crosswalk\Converted\MastersFeb2015.mrk) Output file: change file type to .mm (C:\Crosswalk\Converted\MastersFeb2015.mm)
Select MarcMaker Click on Execute
The results will show the number of records imported. Close window.
Open File –> Local File Manager. Create a directory for the file to import into (i.e., Theses\February2015Masters) and set this as the default.
Open Import Records and input the .mm file to import from your C: drive. Make sure the button for Import to Local Save File is selected.
Check that the Bibliographic destination is correct (i.e., Theses\February2015Masters.bib.db)
Click on OK. Open the file. If necessary, do a spot check and any needed corrections.
The original MarcEdit OAIDCtoMarcXML file can be found on your hard drive under C:\Program Files\MarcEdit 6\xslt\OAIDCtoMARCXML.xsl or wherever your MarcEdit application version is. This is the XML generic version .. don't change this; use the modified version, a copy of which can be found in the R drive under Theses\MarcEdit_Crosswalk\XML1\OAIDCtoMARCXMLmodified.xsl. Note that you must also have the Marc21slimUtils in the same folder in order for the .xsl file to run properly.
The XSLT script is based on that generously shared by Ken Robinson (kjr106@psu.edu), Cataloging and Metadata Services, the Pennsylvania State University. This file can be found online at https://scholarsphere.psu.edu/collections/x346dj68d along with a detailed description of their eTD Dublin Core-to-MARCXML Crosswalk.
Our personalized XML script version does the following:
Our personalized MarcEdit Task List does the following:
in the author's name.
|e contributor with |e advisor.
ADDENDUM
The following URL brings up an XML document tree from BePress which shows the Dublin Core metadata used and the name for each element used (i.e., dc:creator) for each. You can check on other mappings by substituting dissertations_2, englmfa_theses, or larp_ms_projects for masters_theses_2 at the end of the URL.
– Contact person: Kay Dion or Meghan Bergin