MARCXMLCase studies

Gill Hamilton, 5 May 2006

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

The process

Isolate records in the catalogueExport in MARC exchangeConvert to MARCXML with MARCEditTransform the dataIf necessary

Convert back to MARC exchangeImport 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 MARCXMLGlobally replace the text string

C1SAZSERIALto

Serials retroconversion project

Convert back to MARCReload 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 donated509 _ _ $a Donated by Gill HamiltonWe don’t want to do this by hand coz it is time consuming and boring

Case study 2: the processMARC exchange to MARC XMLSearch for end of record marker

</marc:record>

Insert 509 field and data before the markerMARCXML to MARC exchangeResort MARC fields if necessary with MARCEdit editorReload 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 MARCXMLMARCXML to OAI DC using MARCEdit transformationsLoad OAI DC records into institutional repository metadata store

More complex changesDelete fields / subfieldsModify fields /subfieldsAdd fields / subfields

Dependent on criteria

XSLTeXtensible Stylesheet Language TransformationsLanguage 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.

After040 $aZCU$cZCU$dNNU043 $an-us--- 050 4 $aE748.W442$bO88 2003 852 01 $aNNU$bNYU$bNewYorkU$bInternet $hE748.W442$iO88 2003$mElectronic

access 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 requirementsFor 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 manipulationA programmer

ReferencesMARCXML at Library of Congress

http://www.loc.gov/standards/marcxml/IFLA 2005 papers

http://www.ifla.org/IV/ifla71/Programme.htmSee Session 121 (MARC/XML derivates: the state of the art )

Using XSLT to modify bibliographic recordshttp://www.idpf.org/events/presentations/ebookpreso%20-%20pdf/wjones2.pdf

Beginning XSLT / ISBN 1861005946XML for dummies / ISBN 0764588451 XSLT for dummies / ISBN 0764536516

Thanks !

Gill Hamiltong.hamilton@nls.uk