[Koha] Importing biblio fields from CSV

Steven F.Baljkas baljkas at mts.net
Mon Feb 20 05:35:11 NZDT 2006


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 at skemotah.com>
> Date: 2006/02/18 Sat AM 05:26:27 CST
> To: "Marty Jongepier" <bluejaydesign at sympatico.ca>
> CC: koha at 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 at skemotah.com

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



More information about the Koha mailing list