[Koha] availability display

[Rachel Hollis]

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:

query okay, zero affected (0.00 sec)
rows match: 0 changed: 0 warnings: 0

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?

Rachel Hollis, librarian
Stevens-Henager College, Boise Campus

From: Joe Atzberger [mailto:ohiocore at gmail.com]
Sent: Tuesday, January 20, 2009 2:13 PM
To: Rachel Hollis
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] availability display

No need to delete, just edit the item, set the branch and save.

Or using SQL you could also do:
update items set homebranch="MY_BRANCH" where homebranch IS NULL;

Of course using your branchcode instead of MY_BRANCH.

--Joe
On Tue, Jan 20, 2009 at 2:22 PM, Rachel Hollis <Rachel.Hollis at stevenshenager.edu<mailto:Rachel.Hollis at stevenshenager.edu>> wrote:

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.

Rachel Hollis, librarian
Stevens-Henager College, Boise Idaho Campus

From: Joe Atzberger [mailto:ohiocore at gmail.com<mailto:ohiocore at gmail.com>]
Sent: Tuesday, January 20, 2009 12:06 PM
To: Rachel Hollis
Cc: koha at lists.katipo.co.nz<mailto:koha at lists.katipo.co.nz>
Subject: Re: [Koha] availability display

Rachel --

Is it possible the home branch is not set for the no-availability item?  Is the item shadowed or notforloan?

--joe

On Mon, Jan 19, 2009 at 1:04 PM, Rachel Hollis <Rachel.Hollis at stevenshenager.edu<mailto:Rachel.Hollis at stevenshenager.edu>> wrote:

Greetings colleagues, I entered the following two items Friday. One displays its availability, the other does not; see below.


1. Affluenza : the all-consuming epidemic.

by De Graaf, John; Wann, David; Naylor, Thomas H. Redefining Progress (Organization).

Type:  Book; Format: print  ; Literary form: not fiction

Availability: Copies available at: Stevens-Henager College, Boise Campus (1).

2. Basic economics : a common sense guide to the economy.

by Sowell, Thomas.

Type:  Book; Format: print  ; Literary form: not fiction

Availability:

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?  We're on Koha 3.

Rachel Hollis, librarian
Stevens-Henager College, Boise Idaho Campus

________________________________
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090122/213a46f3/attachment.htm