200 likes | 321 Views
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. The process Isolate records in the catalogue Export in MARC exchange
E N D
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
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
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
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
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
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
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
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
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)
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
More complex changes • Delete fields / subfields • Modify fields /subfields • Add fields / subfields • Dependent on criteria • XSLT • eXtensible Stylesheet Language Transformations • Language to manipulate XML
Examples of XSLT Thank you to • William W. Jones of New York University Libraries
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>
<!--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>
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.
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.
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 ?
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
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
Thanks ! Gill Hamilton g.hamilton@nls.uk