Finding Aids Cataloging

  • Using Google Sheets and XPATH, harvesting HTML from our Collections List in order to transform them into MARC records.
  • The following sheet has sample data, including the XPATH expressions used to harvest the data (in Sheet 1): https://docs.google.com/spreadsheets/d/1Lh_Iu7lPs09zZEJtgQIjY7HarCVA-JETld30UTjaj00/edit?usp=sharing
  • [Example expression: =IMPORTHTML(“http://library.humboldt.edu/humco/holdings/CollectionList.htm”,“//dl/dt//a”)]
  • The data is then exported as a tab delimited spreadsheet (TSV), imported into MARCedit, and translated into MARC. Here is the delimited text translator template:

010245$a00
140856$u00
2\9099$a00
3\\546$a00
41\100$a00
5\\264$c00
6\\300$a00
73\520$a00
8\\506$a00
9\\500$a00
100\650$a00
11\0650$a00
12\0650$a00
13\0650$a00
14\0650$a00
15\0650$a00
16\0650$a00

  • After data munging, the MARC record looks like this and will be batch loaded to OCLC. The final step involves batch importing these records into our ILS (Alma) using an import profile:
LDR 01627npcaa2200277Ii 4500
001 999649651302909
005 20180530094021.0
008 171020i19681980cau o 000 0 mul d
041 __ |a eng |a nno
/infra/images/icon_institution_active.png 099 __ |a 1999.28 |A 01CALS_HUL
100 1_ |a Herbelin, Margaret.
245 10 |a Alternative Waste Disposal Collection : |b Finding Aid, |f 1968-1980 |g (bulk 1975-1979).
264 _1 |a Arcata, California : |b Publisher not identified, |c 1968-1980.
300 __ |a 0.5 linear feet
500 __ |a Accession number: 1999.28
546 __ |a In English and Norwegian.
520 __ |a This collection contains documents regarding alternative waste water disposal in the Northern California area, specifically within Humboldt County, and focuses on the issues and research concerning the topic of dry toilet use. The collection contains a variety of documents such as: public records, private and public correspondence, legal documents, journal articles and newspaper clippings. The records span the dates 1968-1980, with the bulk of the material falling between 1975-1979.
506 __ |a Open for research by appointment. Contact HSU Special Collections Librarian for access.
650 _0 |a House construction |z California |z Humboldt County
650 _0 |a Housing |z Law and legislation |z California
650 _0 |a Housing, Rural |z California |z Humboldt County
650 _0 |a Self-reliant living |z California |z Humboldt County
650 _0 |a Sewage disposal in the ground |z California
650 _0 |a Sewage |x Purification
650 _0 |a Waste disposal in the ground |z California
856 40 |u http://library.humboldt.edu/humco/holdings/AltWasteAid.html |z Finding aid