I've done a certain amount with MarcEdit, but I haven't seen this capability yet. I see that the =001 field of your bibliographic record equals the =004 field of your item record, so some matching would have to take place. (i.e. if =004 equals =001 then delete ..., replace 842 with 942, etc.) Do you have a possibility to export in MARCXML, which might give you some additional options. I'm sure there's various ways to solve your problem, but it seems to need to be programmed in some way. James Weinheimer j.weinheimer@aur.edu Director of Library and Information Services The American University of Rome via Pietro Roselli, 4 00153 Rome, Italy voice- 011 39 06 58330919 ext. 258 fax-011 39 06 58330992 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-migrati... 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 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha