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?"
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
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 <mailto: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
Not sure if this matters but looking at your example in the 952: @aR@b148@c20081014@i1@jHardcover@fFollett the subfield delimeter is not $... which all the others are... Wagner, Jane wrote:
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 <mailto: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
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Migration-from-Follett-to-Koha-3-tp22561620p22579147.h... Sent from the Koha - Discuss mailing list archive at Nabble.com.
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
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/Ca... 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@ptfs.com <mailto:jwagner@ptfs.com> From: Roche III, Edward [mailto:edward_roche@solanco.k12.pa.us] Sent: Wednesday, March 18, 2009 9:46 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
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
The original records didn’t have a location/branch code because this branch was the only library in the DB. So, I added subfield $a to field 852 and swapped 852 with 952 through MarcEdit. The weird thing is it isn’t all of the books but is about half that are having this issue. When I do a search on say Sports it list for me all the records that have the word sports attached to it. In the Location column the ones that are missing the info give me the following info: 1 item 1 available: * (1) But the ones that have the info look like this: 2 items 2 available: * Solanco High School (1) I have confirm in the DB that field 952 $a has the correct info for the records that are missing the info. 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: Joe Atzberger [mailto:ohiocore@gmail.com] 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
participants (4)
-
David Schuster -
Joe Atzberger -
Roche III, Edward -
Wagner, Jane