<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=utf-8">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Gill Sans MT";
panose-1:2 11 5 2 2 1 4 2 2 3;}
/* 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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Gill Sans MT","sans-serif";
color:#5F497A;
font-weight:normal;
font-style:normal;}
.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-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">Yesterday I tried to update a few item records so that the OPAC would show item availability. With library set, I edited the item’s homebranch, 952$a
(and b just for good measure) and saved changes in the staff client. Interestingly, the items already display Boise campus as a location. However reselecting the option and saving the item did not change how the records appear in the OPAC. When my IT person
ran Joe’s query and she had the following result:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">query okay, zero affected (0.00 sec)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">rows match: 0 changed: 0 warnings: 0<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">When she looks in the database, the items table shows no null values in homebranch. What can we do differently to get to the place we want; how can I
get homebranch to show in the OPAC? <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">Rachel Hollis, librarian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A">Stevens-Henager College, Boise Campus<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Gill Sans MT","sans-serif";
color:#5F497A"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Joe Atzberger [mailto:ohiocore@gmail.com]
<br>
<b>Sent:</b> Tuesday, January 20, 2009 2:13 PM<br>
<b>To:</b> Rachel Hollis<br>
<b>Cc:</b> koha@lists.katipo.co.nz<br>
<b>Subject:</b> Re: [Koha] availability display<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">No need to delete, just edit the item, set the branch and save.
<br>
<br>
Or using SQL you could also do:<o:p></o:p></p>
<div style="margin-left:30.0pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">update items set homebranch="MY_BRANCH" where homebranch IS NULL;</span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
Of course using your branchcode instead of MY_BRANCH.<br>
<br>
--Joe<o:p></o:p></p>
<div>
<p class="MsoNormal">On Tue, Jan 20, 2009 at 2:22 PM, Rachel Hollis <<a href="mailto:Rachel.Hollis@stevenshenager.edu">Rachel.Hollis@stevenshenager.edu</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p><span style="font-size:10.0pt;color:#5F497A">Not only is it possible that the home branch was not set, it is probable. I think the items are shadowed; that is to say the word "availability" sometimes has green location information after the colon and sometimes
there is nothing following the colon. The location information is available by looking at the specific record, just not in OPAC search results. So figuring that we forgot to set branch location, what do we need to do to fix the situation? Hopefully the answer
is not to delete and re-input.</span><o:p></o:p></p>
<div>
<p><span style="font-size:10.0pt;color:#5F497A">Rachel Hollis, librarian<br>
Stevens-Henager College, Boise Idaho Campus</span><o:p></o:p></p>
</div>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color">
<p><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:
10.0pt"> Joe Atzberger [mailto:<a href="mailto:ohiocore@gmail.com" target="_blank">ohiocore@gmail.com</a>]
<br>
<b>Sent:</b> Tuesday, January 20, 2009 12:06 PM<br>
<b>To:</b> Rachel Hollis<br>
<b>Cc:</b> <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a><br>
<b>Subject:</b> Re: [Koha] availability display</span> <o:p></o:p></p>
</div>
<div>
<div>
<p style="margin-bottom:12.0pt">Rachel --<br>
<br>
Is it possible the home branch is not set for the no-availability item? Is the item shadowed or notforloan?<br>
<br>
--joe<o:p></o:p></p>
<div>
<p>On Mon, Jan 19, 2009 at 1:04 PM, Rachel Hollis <<a href="mailto:Rachel.Hollis@stevenshenager.edu" target="_blank">Rachel.Hollis@stevenshenager.edu</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">Greetings colleagues, I entered the following two items Friday. One displays its availability, the other does not; see below.
<br>
</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">1. Affluenza : the all-consuming epidemic.</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">by De Graaf, John; Wann, David; Naylor, Thomas H. Redefining Progress (Organization).</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">Type: Book; Format: print ; Literary form: not fiction</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">Availability: Copies available at: Stevens-Henager College, Boise Campus (1).</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">2. Basic economics : a common sense guide to the economy.</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">by Sowell, Thomas.</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">Type: Book; Format: print ; Literary form: not fiction</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">Availability: </span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">I checked the items for each and they are the same except for price, call number and barcode. What do I need to do differently?</span><span style="font-size:10.0pt;color:black">
</span><span style="font-size:10.0pt;color:#17365D">We're on Koha 3.</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;color:#17365D">Rachel Hollis, librarian<br>
Stevens-Henager College, Boise Idaho Campus</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<hr>
<font face="Verdana" color="Gray" size="1">This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original.
Any other use of the email by you is prohibited.<br>
</font>
</body>
</html>