<html>
<head>
<style type="text/css">
<!--
body { line-height: normal; margin-right: 4px; font-variant: normal; margin-bottom: 1px; margin-top: 4px; margin-left: 4px }
p { margin-bottom: 0; margin-top: 0 }
-->
</style>
</head>
<body text="#000000" bgcolor="#ffffff">
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">Boy, if only that script had been named less cryptically I could have found it myself :-) [1]</font><br><font size="3" face="Lucida Grande"></font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">Thanks for the push in the right direction. In reviewing that script I realized that all of my items got imported with an onloan date of '0000-00-00'. Replacing those with NULLs solved my problem. </font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">Chris</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">[1] I'm new here, so let me point out that this is intended to be self-deprecating humor :-)</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
>>> Ian Bays <ian.bays@ptfs-europe.com> 04/19/10 1:52 PM >>><br>Hi Chris,<br>I discovered that after populating the issues table I need to run the following script:<br>misc/migration_tools/fix_onloan.pl<br>I hope that helps.  Others might know more.<br>Ian<br>On 19/04/2010 21:21, Chris Hobbs wrote: </p>
<blockquote type="cite" cite="mid:4BCC58BF.82F1.0073.0@nhusd.k12.ca.us">
<p style="margin-bottom: 0; margin-top: 0">
<!--
body { line-height: normal; font-variant: normal; margin-top: 4px; margin-bottom: 1px; margin-right: 4px; margin-left: 4px }
p { margin-top: 0; margin-bottom: 0 }
-->
</p>
<p style="margin-bottom: 0; margin-top: 0" type="text/css">
<font size="3" face="Lucida Grande">Hi all,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">Working on our conversion project. I can successfully import MARC records from our existing ILS, and populate the issues table based on lists derived from our existing system.</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">When searching for biblios in the staff client, search.pl correctly displays the number of items available and on loan. However, in OPAC, the same search shows "No copies available" in opac-search.pl for every title. Clicking through on a title (opac-detail.pl) correctly shows the number available and on loan.</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">See here </font><i><u><a moz-do-not-send="true" href="http://koha.nhusd.k12.ca.us/cgi-bin/koha/opac-search.pl?q=html&limit=branch%3AES"><font size="3" color="#0000ff" face="Lucida Grande">http://koha.nhusd.k12.ca.us/cgi-bin/koha/opac-search.pl?q=html&limit=branch%3AES</font></a></u></i><font size="3" face="Lucida Grande"> and follow the first title for an example.</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">Any ideas on where to start looking? I assume there's a field somewhere that isn't getting updated when I do my import, but I've no idea what to go after.</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Lucida Grande">Thanks for any advice,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<br>
<br>
Chris Hobbs<br>Director, Technology<br>New Haven Unified School District<br><br><br>-- This message has been checked by ESVA and is believed to be clean. </p>
<pre wrap=""><p style="margin-bottom: 0; margin-top: 0; white-space: pre" wrap="">
<fieldset class="mimeAttachmentHeader">
</fieldset>
</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
_______________________________________________</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
Koha mailing list</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
<a class="moz-txt-link-abbreviated" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a></p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
<a class="moz-txt-link-freetext" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a></p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
</p>
</pre>
</blockquote>
<p style="margin-bottom: 0; margin-top: 0">
<br>
<br>
</p>
<pre cols="72" class="moz-signature"><p cols="72" style="margin-bottom: 0; margin-top: 0; white-space: pre" class="moz-signature">
-- </p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
Ian Bays</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
Director of Projects</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
PTFS Europe.com</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
mobile: +44 (0) 7774995297</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
phone: +44 (0) 800 756 6803</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
skype: ian.bays</p>
<p style="margin-bottom: 0; margin-top: 0; white-space: pre">
email: <a class="moz-txt-link-abbreviated" href="mailto:ian.bays@ptfs-europe.com">ian.bays@ptfs-europe.com</a></p>
</pre>
<p style="margin-bottom: 0; margin-top: 0">
<br>
--<br>This message was scanned by ESVA and is believed to be clean.<br><a href="
http://mx.nhusd.k12.ca.us/cgi-bin/learn-msg.cgi?id=B3D9B1171DD.ADF97
">Click here to report this message as spam.</a>
</p>
--
This message has been checked by ESVA and is believed to be clean.
</body>
</html>