[Koha] Issue with importing MARC records and their related items

Jeremy McGinniss jmcginniss at davisny.edu
Sat May 22 07:51:19 NZST 2010


Good afternoon! 

Our library has been running Koha 2.2.5 and I am in the process of
upgrading to 3.00.04.  The whole process has gone smoothly up to this
point. I have attempted to thoroughly detail the problem below. If you
need more information, please let me know. In advance, thanks for any
input.

 

Got to the point in Koha 3.0 where I was ready to import records.  Thus
exported MARC records from our old version of Koha 2.2.5 using the staff
client. Prior to the export, I ran a quick query on the 2.2.5 database
to capture the ending biblionumber and using 1 to that ending number
dropped these values into the from/to biblio number fields in the MARC
exporter (i.e 1-69,784). This generated a 52.3 MB file.

 

Following the staging steps in the online Koha 3.0 reference manual I
was able to import these records into my installation of Koa 3.00.04.
Once this had completed I ran the reindex of Zebra which ran through the
records. Zebra is working nicely and I can search the catalog and find
records.  However I'm missing most of the item information for just
about all of the records.  Accordingly, I checked the 3.0 db and
bibiliotems table has been populated successfully but the items table
only has 25 items listed in it.



In the interest of scientific reasoning, I selected a book that is not
included in the list of 25 items.  In the holdings section of the staff
client the message is given that there are "No physical record available
for this item. Which makes sense because this item is not listed in the
items table of the db. 

However when I go through the process of adding the item, using the old
catalog as a reference for the barcode info, number of copies, etc. and
save/add the item info,
 the record is then populated with two items. I've taken/attached a
screenshot to avoid an arduous explanation.  

 

I have two basic questions: 1) what would be the best way to
specifically export the items information from the old db into the new
one? I would prefer

 to do this enmass as to avoid doing this item by item. 

Secondly I am wondering why I'm getting two iterations to the items I'm
adding. This is probably less important but I am interested to why this
is happening. 

 

Additional info:

Koha version: 3.00.04
MySql Database
Linux 8.04 (Hardy Heron)
Pentium 4 
3.00 GHz CPU



I have done a bit of googling and looking at a bunch of Koha writing
about this but wasn't finding the answer based upon how I was wording my
search queries. If this was specifically addressed on the koha list and
I've missed it, I do apologize and beg the list's kindness.

 

Thank you,

Jeremy McGinniss

Librarian

Alice E. Chatlos Library

Davis College

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100521/46f6842d/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot-Koha 3.0 Cataloging  McGinniss.png
Type: image/png
Size: 107984 bytes
Desc: Screenshot-Koha 3.0 Cataloging  McGinniss.png
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20100521/46f6842d/attachment-0001.png 


More information about the Koha mailing list