<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>Good afternoon!
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>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.<br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>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. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>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,<br>
the record is then populated with two items. I've taken/attached a
screenshot to avoid an arduous explanation. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>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<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'> to do
this enmass as to avoid doing this item by item. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>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. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>Additional
info:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>Koha
version: 3.00.04<br>
MySql Database<br>
Linux 8.04 (Hardy Heron)<br>
Pentium 4 <br>
3.00 GHz CPU<br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>Thank you,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>Jeremy
McGinniss<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>Librarian<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>Alice E.
Chatlos Library<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'>Davis
College</span><span style='font-family:"Cambria Math","serif"'><o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='font-family:"Cambria Math","serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>