1 / 20

Transforming MARC Records to MARCXML: Case Studies from the National Library of Scotland

This document outlines the processes and challenges encountered during the conversion of MARC records to MARCXML as presented at the "Introduction to MARCXML" seminar in Edinburgh, 2006. It includes case studies addressing common cataloguing problems, such as user-unfriendly coded data in OPACs and forgotten donation notes in records. Employing MARCEdit for transformation and metadata harvesting with OAI-PMH, the presentation details practical solutions and complex changes needed to improve cataloguing efficiency and data accessibility.

summer
Télécharger la présentation

Transforming MARC Records to MARCXML: Case Studies from the National Library of Scotland

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MARCXML Case studies Presented to the seminar “Introduction to MARCXML”, National Library of Scotland, Edinburgh, 5 May 2006, organised by the Cataloguing and Indexing Group in Scotland Gill Hamilton, 5 May 2006

  2. The process • Isolate records in the catalogue • Export in MARC exchange • Convert to MARCXML with MARCEdit • Transform the data • If necessary • Convert back to MARC exchange • Import into the catalogue

  3. Case study 1: the problem • Some catalogue records have coded data in them that is not user friendly when displayed in the OPAC • 591 _ _ $h C1SAZSERIAL • We don’t want to convert this by hand coz it is time consuming and boring

  4. Case study 1: the process • MARC exchange to MARCXML • Globally replace the text string • C1SAZSERIAL to • Serials retroconversion project • Convert back to MARC • Reload into catalogue overwriting the original records

  5. 00446cas a22001815a 4500001000800000005001700008008004100025035000600066035001100072040000800083245002600091260005000117300000700167362001100174500004500185591001600230969001800246348592620060427152905.0010215u19669999enkuu p 0 a0eng d bB a527574 aNLS00aAether science paper. aSouthampton ;bSabberton Publications,c1966- av.0 aNo. 1- aEach issue also has a distinctive title. gC1SAZSERIAL aNo. 1-no. 12.00593cas a22002055a 4500001000800000005001700008008004100025035001400066035001100080040000800091245005300099246002700152246002300179246004400202260003900246300002700285362002200312591001600334969003700350347953120060427150202.0010215u19589999enk x 0 a0eng d aSER-00114 a527497 aNLS00aABC British bus fleets.n1,pSouth Eastern area.10a1,pSouth Eastern area10aSouth Eastern area13aABC British bus fleets.n1,pSouth East aLondon :bIan Allan Ltd.,c[1958]- av. :bill ;c16-19 cm.0 a[1st ed.] [1958]- gC1SAZSERIAL a[1st ed.] [1958]-7th ed. [1966].00440cas a22001815a 4500001000800000005001700008008004100025035001400066035001100080040000800091245004800099260003600147300000700183310001100190362001600201591001600217969002500233347593920060427152551.0010215d19469999enkar 0 a0eng d aSER-00059 a527435 aNLS00aAdventure and discovery for boys and girls. aLondon :bJonathan Cape,c1946- av. aAnnual0 a[1] (1946)- gC1SAZSERIAL a[1] (1946)-6 (1951).00513cas a22001935 450000100080000000500170000800800410002503500140006603500110008004000080009111000610009924500310016026000380019130000070022936200

  6. Case study 2: the problem • We’ve catalogued books received as a donation but forgot to add a note indicating that they were donated • 509 _ _ $a Donated by Gill Hamilton • We don’t want to do this by hand coz it is time consuming and boring

  7. Case study 2: the process • MARC exchange to MARC XML • Search for end of record marker • </marc:record> • Insert 509 field and data before the marker • MARCXML to MARC exchange • Resort MARC fields if necessary with MARCEdit editor • Reload into catalogue overwriting original records

  8. Case study 3 • A university library routinely catalogues theses and dissertations by staff and students in the main catalogue • Metadata is in MARC21 format • The university deposits electronic versions of institutional output in a repository

  9. Case study 3 continued … • Metadata for the repository is made available for harvesting via the Open Archives Initiative Protocol for Metadata Harvesting (OAI-PMH) • Metadata is in OAI DC format (as a common format; MARC could also be harvested)

  10. Case study 3: the process • MARC exchange to MARCXML • MARCXML to OAI DC using MARCEdit transformations • Load OAI DC records into institutional repository metadata store

  11. More complex changes • Delete fields / subfields • Modify fields /subfields • Add fields / subfields • Dependent on criteria • XSLT • eXtensible Stylesheet Language Transformations • Language to manipulate XML

  12. Examples of XSLT Thank you to • William W. Jones of New York University Libraries

  13. Examples of XSLT<!--Add 040 $dNNU--> <xsl:templatematch="datafield[@tag='040']"> <datafieldtag="040" ind1=" " ind2=" "> <xsl:copy-of select="subfield"/> <subfield code="d">NNU</subfield> </datafield> </xsl:template>

  14. <!--Copy field 050 data and add 852 field --> <xsl:templatematch="datafield[@tag='050']"> <xsl:copy-of select="."/> <xsl:variablename="sbf1" select="subfield[@code='a']/text()"/> <xsl:variablename="sbf2" select="subfield[@code='b']/text()"/> <datafieldtag="852" ind1="0" ind2="1"> <subfield code="a">NNU</subfield> <subfield code="b">NYU</subfield> <subfield code="b">NewYorkU</subfield> <subfield code="b">Internet</subfield> <subfield code="h"><xsl:value-of select="$sbf1"/></subfield> <subfield code="i"><xsl:value-of select="$sbf2"/></subfield> <subfield code="m">Electronic access</subfield> </datafield> </xsl:template>

  15. BEFORE 040 $aZCU$cZCU 043 $an-us--- 050 4 $aE748.W442$bO88 2003 100 1 $aO'Sullivan, Christopher D. 245 10 $aSumnerWelles, postwar planning, and the quest for a new world order, 1937-1943$h[electronic resource] /$cChristopherD. O'Sullivan. 256 $aElectronicdata.

  16. After 040 $aZCU$cZCU$dNNU 043 $an-us--- 050 4 $aE748.W442$bO88 2003 852 01 $aNNU$bNYU$bNewYorkU$bInternet $hE748.W442$iO882003$mElectronicaccess 100 1 $aO'Sullivan, Christopher D. 245 10 $aSumnerWelles, postwar planning, and the quest for a new world order, 1937-943$h[electronic resource] /$cChristopherD. O'Sullivan. 256 $aElectronicdata.

  17. Practicalities … • Can your LMS …. • export MARC exchange ? • import MARC exchange ? • import / export without reference to your systems supplier ? • isolate records for export ? • control the import ?

  18. Task requirements • For basic global changes • Text editor like NotePad to make global changes • Transforming MARC to another metadata format • MARCEdit and corresponding XSLTs to convert to MARCXML and other formats • More complex manipulation • A programmer

  19. References • MARCXML at Library of Congress • http://www.loc.gov/standards/marcxml/ • IFLA 2005 papers • http://www.ifla.org/IV/ifla71/Programme.htm • See Session 121 (MARC/XML derivates: the state of the art ) • Using XSLT to modify bibliographic records • http://www.idpf.org/events/presentations/ebookpreso%20-%20pdf/wjones2.pdf • Beginning XSLT / ISBN 1861005946 • XML for dummies / ISBN 0764588451 • XSLT for dummies / ISBN 0764536516

  20. Thanks ! Gill Hamilton g.hamilton@nls.uk

More Related