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. Does anyone know of another subfield I can but the collection info/ Edward Roche Technology Support/Network Admin Solanco School District edward_roche@solanco.k12.pa.us 717.786.2151 The greatest mistake you can make in life is to continually be afraid you will make one. Elbert Hubbard -----Original Message----- From: koha-bounces@lists.katipo.co.nz on behalf of Roche III, Edward Sent: Wed 3/18/2009 9:45 AM To: Wagner, Jane Cc: koha@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@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Wagner, Jane Sent: Tuesday, March 17, 2009 12:13 PM To: koha@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@ptfs.com From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Joe Atzberger Sent: Tuesday, March 17, 2009 11:44 AM To: Roche III, Edward Cc: koha@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@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@aR@b148@c20081014@i1@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha