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
Hi,
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
Is your Koha correctly configured to use MARC 21 ?
4. Found there were no more items in the database than before.
Did you configure Koha to use the Zebra tool ? If you did so, you have to run a command (I don't know which one but you will probably find it in the README or INSTALL files) so that Zebra indexes the freshly imported data. Then only they will appear in your koha OPAC.
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.
Yoou may try the MARC::Lint perl module to check your records. Read the synopsis of the documentation, it will certainly help. hth, Sébastien.
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
Is your Koha correctly configured to use MARC 21 ?
They were imported with the type flag of MARC 21
4. Found there were no more items in the database than before.
Did you configure Koha to use the Zebra tool ? If you did so, you have to run a command (I don't know which one but you will probably find it in the README or INSTALL files) so that Zebra indexes the freshly imported data. Then only they will appear in your koha OPAC.
No idea as I'm using the sample virtualised version to trial it. However it appears Zebra is there. In the migration_tools folder there is a rebuildzebra.pl and rebuildnozebra.pl file. I've now run rebuildzebra.pl and it took a while to run but didn't make any records appear. I'll try the nozebra one next. I'm guessing they didn't import properly because of the MARC errors. I'm going to try other formats that Alice for Windows can export in and see if any of them are compatible. I've just noticed that the SCIS sample records that work with the MARC import in Koha are actually USMARC format which I can also export in.
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.
Yoou may try the MARC::Lint perl module to check your records. Read the synopsis of the documentation, it will certainly help.
Ok. I'll have to go find the info on that...missed that somewhere.
hth, Sébastien. _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi,
Is your Koha correctly configured to use MARC 21 ?
They were imported with the type flag of MARC 21
Okay but I didn't talk about your data. Koha can be configured to use either UNIMARC or MARC21 internally. I was referring to that.
4. Found there were no more items in the database than before.
Did you configure Koha to use the Zebra tool ? If you did so, you have to run a command (I don't know which one but you will probably find it in the README or INSTALL files) so that Zebra indexes the freshly imported data. Then only they will appear in your koha OPAC.
No idea as I'm using the sample virtualised version to trial it. However it appears Zebra is there. In the migration_tools folder there is a rebuildzebra.pl and rebuildnozebra.pl file. I've now run rebuildzebra.pl and it took a while to run but didn't make any records appear.
Did you pass command-line options ? If you did no, perhaps you should, something like -z and/or -b ...
I'll try the nozebra one next. I'm guessing they didn't import properly because of the MARC errors. I'm going to try other formats that Alice for Windows can export in and see if any of them are compatible. I've just noticed that the SCIS sample records that work with the MARC import in Koha are actually USMARC format which I can also export in.
I think it's a good idea. Good luck ! Sébastien.
Hi, On Tue, Jun 16, 2009 at 10:54 PM, Seth Mayo<smayo@stpeters.nsw.edu.au> wrote:
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.
You can try using the command-line tool yaz-marcdump to see if the Alice export is in fact a valid MARC file. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt
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>
participants (4)
-
Emrys Minnig -
Galen Charlton -
Seth Mayo -
Sébastien Hinderer