Session Description: At the Marriott Library, the Digital Library Services Department has partnered with Special Collections to design new workflows to improve the efficiency of metadata creation and discovery for both physical and digital resources. This panel will present brief overviews of the workflows, as well as demonstrate free or low cost tools and technologies involved in improving discoverability for special collections items. Workflows described will include using XSLT and Excel to generate item descriptions from an EAD finding aid, using MarcEdit to create MARC records from finding aids, using XSLT to transform ProQuest XML metadata about theses and dissertations, and writing custom scripts for generating MARC records from an inventory spreadsheet.
ULA Schedule Link: https://ula2016.sched.org/event/5xvW/improving-access-to-special-collections-by-automating-descriptive-metadata-creation
EAD Resources
Help with tags and formatting - http://eadiva.com/
Finding Aids Introduction - http://aok.lib.umbc.edu/specoll/ead.php
Encoded Archival Description and Special Collections Reading list - http://aok.lib.umbc.edu/specoll/UMBC_EADresources2015.pdf
EAD3 tag library - https://www.loc.gov/ead/EAD3taglib/index.html
Official EAD Resources from LOC -- https://www.loc.gov/ead/
XSLT
XSLT Introduction: http://www.w3schools.com/xsl/xsl_intro.asp
XSLT Tutorial: http://www.w3schools.com/xsl/
Library Juice Academy: Transforming and Querying XML with XSLT and XQuery (Paid Course)
Version of Marriott Library XSLT for extracting descriptive information: https://github.com/aneatrour/EADExcelPostProcessing
Marriott Library XSLT for extracting subjects from EAD controlAccess fields: https://drive.google.com/file/d/0BwaUIIjcU-85Qm5kcVdTVldmSWs/view?usp=sharing
Excel Formulas
Sample spreadsheet with embedded formulas for Marriott Library Manuscripts EADs:
https://drive.google.com/file/d/0B9pCybH3k6ISUW40VmZHdGFyRjg/view?usp=sharing
Notepad ++ find and replace example for transforming Word Perfect Files:
https://docs.google.com/document/d/1CHlSU6A0ra_qEV3TWY1jPaNQZVXl1Jaz4AgSLiUX7uc/edit?usp=sharing
Notepad++: https://notepad-plus-plus.org/
Oxygen
Software site: http://www.oxygenxml.com/ ($99 academic license)
Documentation: https://www.oxygenxml.com/documentation.html
MarcEdit
Software site: http://marcedit.reeset.net/
MarcEdit101 Webinar series: http://marcedit.reeset.net/marcedit-101-workshop
Marriott Library version of XSLT for MarcEdit EAD to Marc Transform: https://drive.google.com/file/d/0B9pCybH3k6ISNnZmRFAwRWlzTlk/view?usp=sharing
OpenRefine
LCNAF Named Entity Reconciliation: https://github.com/mcarruthers/LCNAF-Named-Entity-Reconciliation
Regular Expressions Tutorial