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.) Stephen 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