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@bcreek.org
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@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@bcreek.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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@bcreek.org On Oct 6, 2014, at 4:01 PM, SCOTT OWEN <sowen@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@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@bcreek.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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@bcreek.org On Oct 7, 2014, at 11:50 AM, Jeramey Valley <valleyj@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@bcreek.org
On Oct 6, 2014, at 4:01 PM, SCOTT OWEN <sowen@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@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@bcreek.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hello, You have to define one library and item type than add that field in 952 concern sub field along with other information in your original marc like accession number, call number etc. On Tue, 07 Oct 2014 01:14:24 +0530 Jeramey Valley 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@bcreek.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian@rediffmail.com : mishravk79@gmail.com
Do you get text or csv data file for biblio data from Spectrum ? On 07-Oct-2014 1:15 AM, "Jeramey Valley" <valleyj@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@bcreek.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Text file in marc record format. Sample below from original file: 4500001001300000003000600013005001700019008004100036010001700077020002500094040002500119050002400144082001200168092001200180100003800192245004200230260005000272300002100322520018600343650002000529650002700549650002200576650003200598650002700630650003400657650002700691650003900718852005200757961000600809 pbb94293193 IJPBB 20040817154651.0 040817t19961994nyu 000 1 eng a 94010278 a0689806981 : c$10.84 aDLC cDLC dDLC dIJPBB 00 aPZ7.D78325 bTe 1996 00 aFic 221 aFIC Dra 1 aDraper, Sharon M. q(Sharon Mills) 10 aTears of a tiger / cSharon M. Draper. aNew York : bAladdin Paperbacks, c1996, c1994. a180 p. ; c18 cm. 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. 1 aDeath xFiction. 1 aHigh schools xFiction. 1 aSchools xFiction. 1 aAfrican Americans xFiction. 7 aDeath xFiction. 2sears 7 aHigh schools xFiction. 2sears 7 aSchool stories. 2sears 7 aAfrican Americans xFiction. 2sears 1 c hFIC Dra p50057 9p10.84usd 820020103 a wl t2 01033nam 2200301 a -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools valleyj@bcreek.org On Oct 7, 2014, at 12:13 PM, vikram zadgaonkar <vikramczadgaonkar@gmail.com> wrote:
Do you get text or csv data file for biblio data from Spectrum ?
On 07-Oct-2014 1:15 AM, "Jeramey Valley" <valleyj@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@bcreek.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Jeramey Valley -
SCOTT OWEN -
vikram zadgaonkar -
Vinod Kumar Mishra