Sunday, February 19, 2006 10:32 CST Hi, Marty, Just an ultra-quick addendum to Stephen Hedge's good advice, to wit ...

From: "Stephen Hedges" <shedges@skemotah.com> Date: 2006/02/18 Sat AM 05:26:27 CST To: "Marty Jongepier" <bluejaydesign@sympatico.ca> CC: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing biblio fields from CSV

Marty -

The problem is that you have only done a "half" import.

Koha bibliographic records are stored both in MARC tables (mostly marc_subfield_table) and the "original" Koha tables (mostly biblio, biblioitems, and items). To import records into Koha so they are saved appropriately in all the appropriate tables, you should convert your data to MARC and use the MARC import tools. LoC has links to some tools that will help with the conversion, http://www.loc.gov/marc/marctools.html (I'm guessing MARCMaker might work well for you.)

MARCMaker would indeed work, but you would probably find MARCEditor (which integrates the MARCMaker and MARCBreaker tools) much easier to work with, and well worthwhile in terms of all the field checking and editing capacities it affords additionally. For example, it would allow you to insert a 942 tag to each record (which you would then have to customise appropriately), a necessity if you decide to use the nifty NPL template for Koha. Best of luck with your Koha install. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ================================================================================ Marty Jongepier said:

Hi all,

I am trying to import biblio items (biblionumber, author and title is all I have) into Koha. It is in .dbf format and I can play around with it in Excel and change it into a CSV format. So far, so good. I imported 800 borrowers straight into MySql this way without a hitch, using LOAD DATA INFILE. All information shows up nicely in Koha.

Now I tried the same thing with the only 3 fields I have for books, (biblionumber, author and title) but absolutely nothing shows up in Koha. It is present in MySql, I entered it into the biblio table. Did I miss something?

I appreciate any help, I do not want to enter 6200 records by hand...

Thanks,

Marty Jongepier

Blue Jay Design and Drafting

-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ============================================================