[Koha] Migrating from Spectrum

Thu Oct 9 07:12:40 NZDT 2014

Was able to resolve this on our own, many thanks for those that offered insight/assistance.

Through a combination of defining material types and additional modification of our MARC file records, we were able to get the items to import properly.

With our Spectrum MARC export we had to convert fields 852 and 961 to 952 and remap several subfields into suitable locations.

Marcedit was used for this conversion process.

We have 4 more buildings to convert, hopefully things continue to smooth out. I'm sure I'll have more questions.

--

Regards, 

Jeramey Valley
Network Manager, Bullock Creek Schools
valleyj at bcreek.org

On Oct 7, 2014, at 11:50 AM, Jeramey Valley <valleyj at bcreek.org> wrote:

> Thanks for the notes, Scott.
> 
> Here's some sample data. In testing, I've converted the 852 to 952 and also tried changing the $9 to $G (not represented below.
> 
> =852  1\$c    $hFIC Dra$p50057$9p10.84usd$820020103$a   
> 
> 
> $c - Shelving location (R)
> $c    
> 
> $h - Classification part
> $hFIC Dra
> 
> $p - Piece designation (barcode)
> $p50057
> 
> $9 not defined (book cost)
> $9p10.84usd
> 
> $8 - Sequence number
> $820020103
> 
> $a - Location
> $a  
> 
> 
> Two sample MARC Records:
> 
> 
> =LDR  01168nam  2200325 a 4500
> =001  pbb97290746\
> =003  IJPBB
> =005  20040817154649.0
> =008  040817t19991997nyu\\\\j\\\\\\000\1\eng\\
> =010  \\$a   97001402 
> =020  \\$a0440226724 :$c{dollar}10.84
> =040  \\$aDLC$cDLC$dDLC$dIJPBB
> =050  \4$aPZ7.M478418$bSw 1999
> =082  14$aFic$221
> =092  \\$aFIC McD
> =100  1\$aMcDonald, Joyce.
> =245  10$aSwallowing stones /$cJoyce McDonald.
> =260  \\$aNew York :$bBantam Doubleday Dell Books for Young Readers,$c1999, c1997.
> =300  \\$a245 p. ;$c18 cm.
> =520  \\$aDual perspectives reveal the aftermath of seventeen-year-old Michael MacKenzie's birthday celebration during which he discharges an antique Winchester rifle and unknowingly kills the father of high school classmate Jenna Ward.
> =650  \1$aGuilt$xFiction.
> =650  \1$aDeath$xFiction.
> =650  \1$aGrief$xFiction.
> =650  \1$aFamily life$xFiction.
> =650  \7$aGuilt$xFiction.$2sears
> =650  \7$aDeath$xFiction.$2sears
> =650  \7$aGrief$xFiction.$2sears
> =650  \7$aFamily life$xFiction.$2sears
> =852  1\$c    $hFIC McD$p50056$9p10.84usd$820020103$a    
> =961  wl$t2
> 
> =LDR  01141nam  2200325 a 4500
> =001  pbb94293193\
> =003  IJPBB
> =005  20040817154651.0
> =008  040817t19961994nyu\\\\\\\\\\\000\1\eng\\
> =010  \\$a   94010278 
> =020  \\$a0689806981 :$c{dollar}10.84
> =040  \\$aDLC$cDLC$dDLC$dIJPBB
> =050  00$aPZ7.D78325$bTe 1996
> =082  00$aFic$221
> =092  \\$aFIC Dra
> =100  1\$aDraper, Sharon M.$q(Sharon Mills)
> =245  10$aTears of a tiger /$cSharon M. Draper.
> =260  \\$aNew York :$bAladdin Paperbacks,$c1996, c1994.
> =300  \\$a180 p. ;$c18 cm.
> =520  \\$aThe death of high school basketball star Rob Washington in an automobile accident affects the lives of his close friend Andy, who was driving the car, and many others in the school.
> =650  \1$aDeath$xFiction.
> =650  \1$aHigh schools$xFiction.
> =650  \1$aSchools$xFiction.
> =650  \1$aAfrican Americans$xFiction.
> =650  \7$aDeath$xFiction.$2sears
> =650  \7$aHigh schools$xFiction.$2sears
> =650  \7$aSchool stories.$2sears
> =650  \7$aAfrican Americans$xFiction.$2sears
> =852  1\$c    $hFIC Dra$p50057$9p10.84usd$820020103$a    
> =961  wl$t2
> 
> --
> 
> Regards, 
> 
> Jeramey Valley
> Network Manager, Bullock Creek Schools
> valleyj at bcreek.org
> 
> 
> 
> 
> On Oct 6, 2014, at 4:01 PM, SCOTT OWEN <sowen at almaschools.net> wrote:
> 
>> Jeramy,
>> 
>> What does the holding info look like  ?
>> 
>> Here are some of my notes when we moved from Spectrum to Koha.
>> 
>> 
>> 
>> KOHA 3 EXPORT
>> 
>> =952  \\$70$kF HAN$p70262$r{dollar}13.99$40$00$911$bPINE$yBOOK$10$u263$dPINE$t2
>> 
>> KOHA3			KOHA3 CODE				Win-Spec
>> $7—- 0			Not for loan				--
>> $c-- F HAN		Shelving location code		--$h	Copy to $o and $c
>> $p—- 74255		barcode					--$p	SAME
>> $r—- 2010-8-7		Date last seen				--	fill w/date 
>> $4—- 0			Damaged status			--    fill w/ “0” 
>> $0—- 0			Withdrawn status			--    fill w/ “0”
>> $9—- 12			Koha itemnumber (autogenerated)		--    Auto
>> $b—- PINE		branchcode				--$a	HS
>> $y—- BOOK		Koha item type			--$t (22 choices - must match)		
>> $1—- 0			Lost status				--    fill w/ “0”
>> $u—- 4264		Uniform Resource Identifier	--  	
>> $d—2007-8-17		Date acquired			--    fill w/date
>> $t—- 6			Copy number                 		--    ???
>> $o-- F HAN 		Koha Full call number       	--    same as $h
>> $v–-              	cost replacement price      		--$9	copy to $v
>> 
>> 
>> 
>> 
>> 
>> IIRC we determined that they hadn't done a "good" inventory in quite some time, and so we inventoried the library, and adjusted the holding info by hand...
>> thus...I never bothered importing it....
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> On Mon, Oct 6, 2014 at 3:45 PM, Jeramey Valley <valleyj at bcreek.org> wrote:
>> We are in process of migrating from Winnebago Spectrum to Koha and hitting some snags migrating our data.
>> 
>> The MARC records for our collection will import, but does not include the holdings. I can see the holdings information in the 852 field in our original export file from Spectrum.
>> 
>> Research indicated we should modify the file to put the holdings information in the 952 field and map accordingly.
>> 
>> In testing trying this route, I am not seeing the 952 field importing into Koha (looking at the raw MARC file in Koha). Prior to modifying the import file to map the 852 info to 952 fields, I did see the 852 fields in Koha but they didn't appear to import or map to where they should be.
>> 
>> Using Marcedit to modify the file.
>> 
>> I have not created any material types or other setup information except to define the library and one "super user".
>> 
>> New install of Debian and Koha 3.16.04.000
>> 
>> In between tests I am removing the Koha install, deleting the database and running the zebra reset procedures to try and keep things "clean".
>> 
>> Any pointers or suggestions appreciated.
>> 
>> 
>> --
>> 
>> Regards,
>> 
>> Jeramey Valley
>> Network Manager, Bullock Creek Schools
>> valleyj at bcreek.org
>> 
>> 
>> 
>> 
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
> 