[Koha] Migrating from Spectrum

[Jeramey Valley]

Text file in marc record format. Sample below from original file:

4500001001300000003000600013005001700019008004100036010001700077020002500094040002500119050002400144082001200168092001200180100003800192245004200230260005000272300002100322520018600343650002000529650002700549650002200576650003200598650002700630650003400657650002700691650003900718852005200757961000600809pbb94293193 IJPBB20040817154651.0040817t19961994nyu           000 1 eng    a   94010278   a0689806981 :c$10.84  aDLCcDLCdDLCdIJPBB00aPZ7.D78325bTe 199600aFic221  aFIC Dra1 aDraper, Sharon M.q(Sharon Mills)10aTears 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. 1aDeathxFiction. 1aHigh schoolsxFiction. 1aSchoolsxFiction. 1aAfrican AmericansxFiction. 7aDeathxFiction.2sears 7aHigh schoolsxFiction.2sears 7aSchool stories.2sears 7aAfrican AmericansxFiction.2sears1 c    hFIC Drap500579p10.84usd820020103a    wlt201033nam  2200301 a 

--

Regards, 

Jeramey Valley
Network Manager, Bullock Creek Schools
valleyj at bcreek.org




On Oct 7, 2014, at 12:13 PM, vikram zadgaonkar <vikramczadgaonkar at 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 at 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 at bcreek.org
> 
> 
> 
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha