<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>RE: [Koha] Migration from Follett to Koha 3</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>i believe I found why some of my holding are not getting imported. in field 952 subfield 4b Follett uses it specify it as a sublocation or collection but Koha wants it to be current location. if i delete the subfield from the record it imports correctly.<BR>
<BR>
Does anyone know of another subfield I can but the collection info/<BR>
<BR>
Edward Roche<BR>
Technology Support/Network Admin<BR>
Solanco School District<BR>
edward_roche@solanco.k12.pa.us<BR>
717.786.2151<BR>
<BR>
The greatest mistake you can make in life is to continually be afraid you will make one.<BR>
Elbert Hubbard<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: koha-bounces@lists.katipo.co.nz on behalf of Roche III, Edward<BR>
Sent: Wed 3/18/2009 9:45 AM<BR>
To: Wagner, Jane<BR>
Cc: koha@lists.katipo.co.nz<BR>
Subject: Re: [Koha] Migration from Follett to Koha 3<BR>
<BR>
Jane<BR>
<BR>
<BR>
<BR>
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.<BR>
<BR>
<BR>
<BR>
Thanks<BR>
<BR>
Ed<BR>
<BR>
<BR>
<BR>
Edward J. Roche<BR>
<BR>
Network Administrator<BR>
<BR>
Solanco School District<BR>
<BR>
717.786.2151 x2437<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
"At the End of the Day, Did You Play to Win or Not to Lose?"<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
From: koha-bounces@lists.katipo.co.nz [<A HREF="mailto:koha-bounces@lists.katipo.co.nz">mailto:koha-bounces@lists.katipo.co.nz</A>] On Behalf Of Wagner, Jane<BR>
Sent: Tuesday, March 17, 2009 12:13 PM<BR>
To: koha@lists.katipo.co.nz<BR>
Subject: Re: [Koha] Migration from Follett to Koha 3<BR>
<BR>
<BR>
<BR>
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.<BR>
<BR>
<BR>
<BR>
Jane Wagner<BR>
<BR>
Library Systems Analyst<BR>
<BR>
PTFS Inc.<BR>
<BR>
Content Management and Library Solutions<BR>
<BR>
6400 Goldsboro Road, Suite 200<BR>
<BR>
Bethesda, MD 20817<BR>
<BR>
(301) 654-8088 x 151<BR>
<BR>
jwagner@ptfs.com<BR>
<BR>
<BR>
<BR>
From: koha-bounces@lists.katipo.co.nz [<A HREF="mailto:koha-bounces@lists.katipo.co.nz">mailto:koha-bounces@lists.katipo.co.nz</A>] On Behalf Of Joe Atzberger<BR>
Sent: Tuesday, March 17, 2009 11:44 AM<BR>
To: Roche III, Edward<BR>
Cc: koha@lists.katipo.co.nz<BR>
Subject: Re: [Koha] Migration from Follett to Koha 3<BR>
<BR>
<BR>
<BR>
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.<BR>
<BR>
--Joe<BR>
<BR>
2009/3/17 Roche III, Edward <edward_roche@solanco.k12.pa.us><BR>
<BR>
Good Morning All<BR>
<BR>
<BR>
<BR>
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.<BR>
<BR>
<BR>
<BR>
Any ideas?<BR>
<BR>
<BR>
<BR>
Here is a sample of a record that is having this issue:<BR>
<BR>
<BR>
<BR>
=LDR 01365pam 2200325 a 4500<BR>
<BR>
=001 854153E690C34B779B07B5A7D53BDD9C<BR>
<BR>
=005 20081125124707.0<BR>
<BR>
=008 071231t20082007nyu\\\\c\\\\\\000\1\eng\\<BR>
<BR>
=010 \\$a 2007046493<BR>
<BR>
=020 \\$a9780545051637<BR>
<BR>
=035 \\$a(ICrlF)fol11914404<BR>
<BR>
=035 \\$a(ICrlF)12174W<BR>
<BR>
=040 \\$aDLC$cDLC$dDLC$dICrlF<BR>
<BR>
=042 \\$alcac<BR>
<BR>
=043 \\$ar------<BR>
<BR>
=050 00$aPZ7.D6475$bFe 2008<BR>
<BR>
=082 00$a[Fic]$222<BR>
<BR>
=100 1\$aD'Lacey, Chris.<BR>
<BR>
=245 14$aThe fire eternal /$cChris d'Lacey.<BR>
<BR>
=250 \\$a1st Scholastic ed.<BR>
<BR>
=260 \\$aNew York :$bOrchard Books,$c2008, c2007.<BR>
<BR>
=300 \\$a506 p. ;$c22 cm.<BR>
<BR>
=500 \\$aFour book series includes: The Fire Within, Icefire. Fire Star, The Fire Eternal.<BR>
<BR>
=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.<BR>
<BR>
=650 \7$aSupernatural$vFiction.$2sears<BR>
<BR>
=650 \7$aDragons$vFiction.$2sears<BR>
<BR>
=650 \7$aClimate$vFiction.$2sears<BR>
<BR>
=650 \7$aEnvironmental degradation$vFiction.$2sears<BR>
<BR>
=651 \7$aArctic Regions$vFiction.$2sears<BR>
<BR>
=952 \\$bFiction$hFIC DLA$pT0025982$t1$xFSC@aR@b148@c20081014@i1@jHardcover@fFollett$xFUND: District$aSHS<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
Thanks<BR>
<BR>
Ed<BR>
<BR>
<BR>
<BR>
Edward J. Roche<BR>
<BR>
Network Administrator<BR>
<BR>
Solanco School District<BR>
<BR>
717.786.2151 x2437<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
"At the End of the Day, Did You Play to Win or Not to Lose?"<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
_______________________________________________<BR>
Koha mailing list<BR>
Koha@lists.katipo.co.nz<BR>
<A HREF="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</A><BR>
<BR>
<BR>
<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>