[Koha] Migration from Follett to Koha 3

Thu Mar 19 02:58:20 NZDT 2009

It’s defined as subfield 8 – it comes from an authorized value list.  Item type does seem to handle case differences OK, but collection code was definitely a problem.  I was doing some sample data imports, and had to script a case conversion for subfield 8.

If you haven’t found it already, the online manual page is very useful:

https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/Cataloging/item-fields-data-migration 

Making a rather large leap of reasoning here, maybe anything that’s an authorized value has to match the case?  Does anyone know for sure?

Jane Wagner

Library Systems Analyst

PTFS Inc.

Content Management and Library Solutions

6400 Goldsboro Road, Suite 200

Bethesda, MD  20817

(301) 654-8088 x 151

jwagner at ptfs.com <mailto:jwagner at ptfs.com> 

From: Roche III, Edward [mailto:edward_roche at solanco.k12.pa.us] 
Sent: Wednesday, March 18, 2009 9:46 AM
To: Wagner, Jane
Cc: koha at lists.katipo.co.nz
Subject: RE: [Koha] Migration from Follett to Koha 3

Jane

Which field is the collection code and where in Koha do you define it? This could be a possibility. I noticed that when you add a item type even if you put it as all lower case it switches it to upper.

Thanks

Ed

Edward J. Roche

Network Administrator

Solanco School District

717.786.2151 x2437

"At the End of the Day, Did You Play to Win or Not to Lose?" 

From: koha-bounces at lists.katipo.co.nz [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Wagner, Jane
Sent: Tuesday, March 17, 2009 12:13 PM
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Migration from Follett to Koha 3

Another thing to check – I’ve found that the codes can be case sensitive.  Collection code for instance – I had a code in lower case in the item import, and it didn’t work until I made it upper case to match how it was defined on the server.  I haven’t done extensive testing yet on the other fields, but it’s worth investigating.

Jane Wagner

Library Systems Analyst

PTFS Inc.

Content Management and Library Solutions

6400 Goldsboro Road, Suite 200

Bethesda, MD  20817

(301) 654-8088 x 151

jwagner at ptfs.com

From: koha-bounces at lists.katipo.co.nz [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Joe Atzberger
Sent: Tuesday, March 17, 2009 11:44 AM
To: Roche III, Edward
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Migration from Follett to Koha 3

Did you define the branch with a branchcode that matches the itemdata?  If not the result is predictable, since the foreign key relationship on branchcode would be violated.

--Joe

2009/3/17 Roche III, Edward <edward_roche at solanco.k12.pa.us>

Good Morning All

Has anyone come across an issue when you import your Follett catalog export in Koha 3 a large number of your holdings info doesn’t get imported? I double checked Follett and the info is there and there is a bibliography record in Koha just no entry in the items table.

Any ideas?

Here is a sample of a record that is having this issue:

=LDR  01365pam  2200325 a 4500

=001  854153E690C34B779B07B5A7D53BDD9C

=005  20081125124707.0

=008  071231t20082007nyu\\\\c\\\\\\000\1\eng\\

=010  \\$a  2007046493

=020  \\$a9780545051637

=035  \\$a(ICrlF)fol11914404 

=035  \\$a(ICrlF)12174W

=040  \\$aDLC$cDLC$dDLC$dICrlF

=042  \\$alcac

=043  \\$ar------

=050  00$aPZ7.D6475$bFe 2008

=082  00$a[Fic]$222

=100  1\$aD'Lacey, Chris.

=245  14$aThe fire eternal /$cChris d'Lacey.

=250  \\$a1st Scholastic ed.

=260  \\$aNew York :$bOrchard Books,$c2008, c2007.

=300  \\$a506 p. ;$c22 cm.

=500  \\$aFour book series includes: The Fire Within, Icefire. Fire Star, The Fire Eternal.

=520  \\$aAs the weather grows wilder and the ice caps melt, Arctic bears starve, dragons awake, the earth goddess Gaia becomes restless, and Alexa, the daughter of best-selling author David Rain, uses her special abilities in an attempt to save the world from the forces of evil.

=650  \7$aSupernatural$vFiction.$2sears

=650  \7$aDragons$vFiction.$2sears

=650  \7$aClimate$vFiction.$2sears

=650  \7$aEnvironmental degradation$vFiction.$2sears

=651  \7$aArctic Regions$vFiction.$2sears

=952  \\$bFiction$hFIC DLA$pT0025982$t1$xFSC at aR@b148 at c20081014@i1 at jHardcover@fFollett$xFUND: District$aSHS

Thanks

Ed

Edward J. Roche

Network Administrator

Solanco School District

717.786.2151 x2437

"At the End of the Day, Did You Play to Win or Not to Lose?" 

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090318/404f90d6/attachment-0001.htm 