It seems folks are having problems getting their data clean. Here are some free tools that might help get it in better shape before importing. Showmarc is a DOS program that will show all the MARC fields used and how many times each is used. http://www.auto-graphics.com/download/SHOWMARC.EXE MarcEdit (Windows) can change records into human readable format and back again. It includes an editor, ability to mass add or delete fields, a field counter, and find and replace. A nice tool, should be a part of every cataloging dept. http://oregonstate.edu/~reeset/marcedit/html/index.html MARC RTP (DOS) has the ability to report the subfields as well as the fields used. It also gives how long the longest instance is. http://marc.ise.canberra.edu.au/ MARC/Perl is a powerful tool with functions only limited by your coding ability. http://marcpm.sourceforge.net/ Hope this helps some folks clean up their records. Sincerely, David Bigwood bigwood@lpi.usra.edu Lunar & Planetary Institute Cataloging News http://www.catalogablog.blogspot.com -----Original Message----- From: Larry Stamm [mailto:larry@larrystamm.com] Sent: Monday, July 21, 2003 11:14 PM To: koha Subject: Re:[Koha] data import question Hi Derek, I find the bulkmarcimport script to be interminably slow, entering only about 6000 items per hour on our 950 MHz CPU server running Mandrake 9.0. It is not much slower on my 266 MHZ home machine that I am using as a test machine. Because I have to enter all 15,000 items from our collection to really test for errors in my MARC "munging", it means another 2 1/2 hr wait to load up all the items again after fixing a mistake before testing. I might get frustrated enough to try my hand at writing a faster upload script... -- Larry Stamm, Chair McBride and District Public Library McBride, BC V0J 2E0 Canada http://www.mcbridebc.org/library