Hello, One thing i've found useful when migrating data is to do a full manual cataloging of a sample biblio/item in the koha, then search for this record in OPAC and save as a marc record. I then use marcedit on this record to see koha marc tags and use that as a reference when mapping from other ILS or excel. My 2 cents Olugbenga Adara Mobile: 234-803-3220288 --- On Wed, 6/17/09, Emrys Minnig <emrysminnig@varndean.co.uk> wrote:

From: Emrys Minnig <emrysminnig@varndean.co.uk> Subject: Re: [Koha] Migrate Alice for Windows To: "Seth Mayo" <smayo@stpeters.nsw.edu.au>, koha@lists.katipo.co.nz Date: Wednesday, June 17, 2009, 5:15 AM 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/> _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha <http://lists.katipo.co.nz/mailman/listinfo/koha>

_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha