From there, it is fairly straightforward to use the 'Swap field data'
Ian, I looked into doing that in MarcEdit, but it didn't solve the problem of the field being in a separate record. After much hair pulling and researching via Google, I figured out a way to do it using MarcEdit, tac and sed. If anybody is interested in the gory details, I can post them on the listserv. Thanks for the suggestion. //SIGNED// PERRY OTIS Systems Librarian Muir S. Fairchild Research Information Center DSN 493-6498 Comm 334-953-8081 -----Original Message----- From: Emrys Minnig [mailto:emrysminnig@varndean.co.uk] Sent: Wednesday, March 10, 2010 6:35 AM To: Otis, Perry W Civ USAF AETC AUL/LTIA; Ian Walls Cc: koha@lists.katipo.co.nz Subject: RE: [Koha] Trying to import bibs with holdings Judging from the format of your MARC file, I assume it displays properly in MarcEdit's MarcEditor utility (.mrk file?) option from the 'Tools' menu to move about your field/subfield data. Check the MarcEdit help documentation for more information on 'Swap field data', as there are a few syntax options that allow additional control. Emrys ________________________________ From: koha-bounces@lists.katipo.co.nz on behalf of Otis, Perry W Civ USAF AETC AUL/LTIA Sent: Tue 09/03/2010 22:37 To: Ian Walls Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Trying to import bibs with holdings I've looked at MarcEdit, but I'm not familiar with it. I couldn't see any options that looked as though they would do what I needed to do. //SIGNED// PERRY OTIS Systems Librarian Muir S. Fairchild Research Information Center DSN 493-6498 Comm 334-953-8081 From: Ian Walls [mailto:ian.walls@bywatersolutions.com] Sent: Tuesday, March 09, 2010 3:27 PM To: Otis, Perry W Civ USAF AETC AUL/LTIA Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Trying to import bibs with holdings Perry, Have you tried MarcEdit? It's designed to let you massage MARC data in batches, so you can preprocess your exported records before importing them into Koha. http://people.oregonstate.edu/~reeset/marcedit/html/index.php For multiple item records, you can map each 852 to a 952 for Koha to ingest (one 952 per holding). You may need to scrub out those extra leaders and 00X's, and map your subfields differently. See the 3.0 manual for details: http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-mig ration Hope this helps! -Ian 2010/3/9 Otis, Perry W Civ USAF AETC AUL/LTIA <perry.otis@maxwell.af.mil> In Koha 3.0.02, I am trying to import a batch of bib records exported from a Voyager system. I want to include the holdings, but Voyager exports the holdings separate from the bib record. Here's an example from the MARC file: =LDR 02399cgm a2200601 a 4500 =001 484802 =005 20100107105024.0 =007 vd\cvaizq =008 080516s2007\\\\cau116\e\\\\\\\\\\vleng\d =020 \\$a9781419818004 =024 1\$a012569736627 =028 42$a73662$bWarner Home Video =035 \\$a(MnBnMLM)MLM02151328 =035 \\$a484802 =040 \\$aMnBnMLM$cMnBnMLM =041 1\$aeng$afre$aspa$beng$bfre$bspa =050 14$aPN1997.2.A175$bA175 2007 =082 04$a791.43/72$222 =099 \\$aDVD 791.43 Thr =245 00$a300$h[videorecording (DVD)] /$cWarner Bros. Pictures in association with Legendary Pictures and Virtual Studios ; produced by Mark Canton ... [et al.] ; directed by Zack Snyder ; screenplay by Zack Snyder, Kurt Johnstad, Michael B. Gordon. =246 3\$aThree hundred =250 \\$aWidescreen version. =260 \\$aBurbank, Calif. :$bWarner Home Video,$cc2007. =300 \\$a1 videodisc (116 min.) :$bsd., col. ;$c4 3/4 in. =500 \\$aBased on the graphic novel by Frank Miller. =546 \\$aClosed-captioned. =600 10$aMiller, Frank,$d1957-$vFilm and video adaptations. =650 \0$aThermopylae, Battle of, Greece, 480 B.C.$vDrama. =700 1\$aMiller, Frank,$d1957- =710 2\$aWarner Bros. Pictures (1969- ) =LDR 00188cx a22000851 4500 =001 623872 =004 484802 =005 20100128113958.0 =008 1001030u||||8|||4001uu|||0000000 =852 8\$aAMAU$bGUNTER VID$hDVD 791.43$iThr Each bib record is followed by its associated holdings records. It appears that Koha doesn't work like that but looks for the holdings data in (I think) a 942 field in the bib record. Does anybody know of a way for me to move the data in from the 852 in the holding record into a 942 in the bib record? I've been tearing my hair out over this and thought that I had come up with a solution using sed, but can't figure out how to deal with multiple holdings. Thanks. //SIGNED// PERRY OTIS Systems Librarian Muir S. Fairchild Research Information Center DSN 493-6498 Comm 334-953-8081 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha