You need to run MarcEdit's MarcBreaker utility on the .dat file and then use MarcEdit's MarcEditor to read it. It should have a nice intuitive layout. Next, from the Tools menu, use the Edit Field Data and Swap Field Data tools to manipulate your fields and subfields. Finally, from the File menu, select 'Compile to MARC' to put it back into a .dat format. Unfortunately, I don't have my notes on the exact Alice-to-Koha subfield mapping handy (as it's been quite a while) but if you look at Koha's 952 subfield numbers/letters on Koha's 'Add Item' screen and then look at the 995 (I think) subfields of your exported record, you should be able to tell which subfields correspond. Emrys ________________________________ From: Seth Mayo [mailto:smayo@stpeters.nsw.edu.au] Sent: Thu 18/06/2009 03:16 To: Emrys Minnig Subject: Re: [Koha] Migrate Alice for Windows Ok, now I'm confused... I exported a USMARC file from Alice and then opened it in MARCEdit. In MARCEdit it turned up as lots of continuous lines like the following...that wasn't exactly what I expected. What did I do wrong? Alice exports in 'dat' files, did I need to convert it first? If so, what do I need to do? 00476nam 22001691a 4500020002400000040004300024082001100067100002100078245003500099250000800134260004200142300002400184600001300208600001200221850003100233852004200264 a9780192721167 c0.00 aSt. Peter's Anglican Primary - Library aJ bWIL aWILDSMITH, Brian a1 2 3 cBrian Wildsmith h[Text] as/c aOxford bOxford University Press c1965 a[30] p. : col. ill. aCounting aNumbers aSt Peter's Anglican School kLIBRARY hJ iWIL pR013782560 910.00 t0 00487nam 22001691a 4500020002400000040004300024082000800067100001800075245003900093250000800132260004600140500003400186600001300220600001200233850003100245852004100276 a9780867700336 c0.00 aSt. Peter's Anglican Primary - Library bBRE aBRENNAN, John a1 2 3 AND WHAT DO YOU SEE? h[Text] ah/c aBoronia, VIC bJ.M. Dent Pty Limited c1985 aJohn Brennan;; Photography by aCounting aNumbers aSt Peter's Anglican School kLIBRARY hJ iBRE pR054732560 98.50 t0 00558nam 22002171a 4500020002400000040004300024082000800067100002100075245002200096250000800118260004900126300000900175440001400184500001700198600001300215600001100228600001800239600001100257850003100268852004100299 a9780732944988 c0.00 aSt. Peter's Anglican Primary - Library bBAR aBARNARD, Neville a1 BY FOUR h[Text] ap/b aSouth Yarra, Vic. bMacmillan Education c1997 a5-80 aCrackers! aTrish Hill;; aBullying aHumour aRelationships aSchool aSt Peter's Anglican School kLIBRARY hF iBAR pR207562560 96.00 t0 00483nam 22001811a 4500020002400000040004300024082000800067100001800075245002100093250000800114260004300122440002000165500001900185600001300204600001200217850003100229852004100260 a9780140503999 c0.00 aSt. Peter's Anglican Primary - Library bHUT aHUTCHINS, Pat a1 HUNTER h[Text] as/c aHarmondsworth bPenguin Books Ltd c1984 aPicture Puffins aPat Hutchins;; aCounting aNumbers aSt Peter's Anglican School kLIBRARY hJ iHUT pR020642560 90.00 t0 00617nam 22001931a 4500020000900000040004300009082001600052100002000068245004800088260004600136300001300182440002700195500003800222600001000260658001000270850003100280852005600311852005600367 c0.00 aSt. Peter's Anglican Primary - Library a782.25 bBUC aBuchanan, Colin a10. 9, 8... God is great h[Sound Recording] aEngadine, NSW bWanaaring Road Music c2002 a1 CD-ROM aAussie Praise for kids aSheet music and colouring in book aMusic aMusic aSt Peter's Anglican School kTEACHER RESOURCE h782.25 iBUC pR272502560 922.68 t0 kTEACHER RESOURCE h782.25 iBUC pR272512560 922.68 t0 00690nam 22002171a 4500001001100000010001500011020002400026040004300050082001100093100002300104245010200127260003100229300002400260500002100284600002100305600003000326600002100356700002300377850003100400852004100431 2003009780 a2003009780 a9780439577694 c0.00 aSt. Peter's Anglican Primary - Library aJ bLOO aLoomis, Christine. aThe 10 best things about my Dad / cby Christine Loomis ; illustrated by Jackie Urbanovic. h[Text] aNew York bScholastic c2004 a[30] p. : col. ill. aCartwheel Books. aFathers xPoetry. aParent and child xPoetry. aStories in rhyme aUrbanovic, Jackie. aSt Peter's Anglican School kLIBRARY hJ iLOO pR337172560 96.00 t0 00155nam 22000611a 4500020000900000040004300009245004100052 c0.00 aSt. Peter's Anglican Primary - Library aTen best things about my Dad h[Text] 00632nam 22001931a 4500020002400000040004300024082001100067100002100078245007600099250000800175260007400183300002200257500001800279600002400297600002300321600002200344850003100366852004100397 a9780590719490 c0.00 aSt. Peter's Anglican Primary - Library aJ bBOG aBOGART, Jo Ellen a10 for Dinner cJo Ellen Bogart ; illustrations by Carlos Freire h[Text] as/c aRichmond Hill, io, Canada bScholastic-TAB Publications Ltd c1989 a20 p. : col. ill. aCarlos Freire aBirthdays - Fiction aCounting xFiction. aFriends - Fiction aSt Peter's Anglican School kLIBRARY hJ iBOG pR335882560 98.00 t0 00551nam 22001811a 4500020002400000040004300024082000800067100001800075245004600093250000800139260006500147300000900212600003100221600001000252700001900262850003100281852005700312 a9780958715775 c0.00 aSt. Peter's Anglican Primary - Library bTAY aTAYLOR, Steve a10 IN ONE : A COLLECTION OF PLAYS h[Text] as/c aSt Kilda South, VIC bEducation Resources Group Pty Ltd c1997 a1-60 aTeacher's resource - Plays aPlays aDENSLEY, Kevin aSt Peter's Anglican School kTEACHER RESOURCE h822.008 iTAY pR206182560 974.00 t0 00412nam 22001571a 4500020002400000040004300024082000800067100001800075245002700093250000800120260003200128600001300160600000900173850003100182852004100213 a9780861124381 c0.00 aSt. Peter's Anglican Primary - Library bBRI aBRIMAX, BOOKS a10 LITTLE MICE h[Text] as/c aEngland bBrimax Books c1987 aCounting aMice aSt Peter's Anglican School kLIBRARY hJ iBRI pR148342560 98.00 t0 00602nam 22001931a Seth Mayo IT Technical Manager Email: smayo@stpeters.nsw.edu.au ------------------------------------------------------- St Peter's Anglican Primary School Howe Street Campbelltown NSW 2560 PH: 02 4627 2990 Website: http://www.stpeters.nsw.edu.au <http://www.stpeters.nsw.edu.au/> 2009/6/18 Seth Mayo <smayo@stpeters.nsw.edu.au>:
What process did you follow to migrate? In other words, what did you migrate, when and how?
My biggest concern was the compatibility and obviously that is possible as you have done it. I tried again yesterday to import and managed to get resources into the system in much the way you described. However, the fields didn't match. What you mentioned about MarcEdit should fix that and I'll work on that now. Next the thing to work out are the following:
Did your copies information import correctly? How did you transfer the loan information (eg. the status of particular books having been loaned out currently)?
Thanks for your help. I'm sure I'll have more questions for you but I'll try not to take up too much of your time.
Seth Mayo IT Technical Manager Email: smayo@stpeters.nsw.edu.au ------------------------------------------------------- St Peter's Anglican Primary School Howe Street Campbelltown NSW 2560 PH: 02 4627 2990 Website: http://www.stpeters.nsw.edu.au <http://www.stpeters.nsw.edu.au/>
2009/6/17 Emrys Minnig <emrysminnig@varndean.co.uk>:
I successfully migrated from Alice to Koha 3. I used Alice's 'Export to USMARC' utility to dump all the records into a .dat file.
Next, using MarcEdit (free from oregonstate.edu/~reeset/marcedit/html/), I moved item information from Alice's 999 subfields to Koha's 952 subfields (if I remember right).
Then, I used Koha's 'Stage MARC records' utility to populate the catalogue.
If you have any other questions, feel free to email me.
Emrys Minnig Varndean School
________________________________
From: koha-bounces@lists.katipo.co.nz on behalf of Seth Mayo Sent: Wed 17/06/2009 03:54 To: koha@lists.katipo.co.nz Subject: [Koha] Migrate Alice for Windows
Has anyone migrated Alice for Windows to Koha?
Alice for Windows hasn't been working right in our school for while and I'm looking to change to Koha. However I haven't been able to get the exported MARC file to import. Unfortunately I don't know much about MARC but basically what I've done is the following.
1. Used the Alice for Windows 'Export to MARC' function to dump a MARC 21 .dat file 2. Set up the environment variables for bulkmarcimport.pl 3. Run bulkmarcimport.pl to import the data which returned that 21000 odd items were imported 4. Found there were no more items in the database than before. 5. Tried uploading it to import through the 'reservior' method and it gave me a report that there were the same number of records but that there were MARC errors on each one.
Any help would be greatly appreciated.
Regards,
Seth Mayo IT Technical Manager Email: smayo@stpeters.nsw.edu.au ------------------------------------------------------- St Peter's Anglican Primary School Howe Street Campbelltown NSW 2560 PH: 02 4627 2990 Website: http://www.stpeters.nsw.edu.au <http://www.stpeters.nsw.edu.au/> <http://www.stpeters.nsw.edu.au/> _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha <http://lists.katipo.co.nz/mailman/listinfo/koha>