[Koha] Inventory & items.itemcallnumber
Matthew Metzger
news at metzger.cc
Sun Jul 8 08:10:16 NZST 2007
Hello,
thanks to Joshua Ferraro and Ryan Higgins for helping me understand this
problem more. See the thread "inventory.pl not working for me" for the
history of this discussion.
My problem is that our librarian cannot currently do inventory because
we have not been entering in a value for items.itemcallnumber (which I
believe to be MARC 082b).
Our call number is, however, recorded in the database field
biblioitems.classification. What seems to be the solution is for the
value of biblioitems.classification to be copied to, or synced with, the
value of items.itemcallnumber.
I'm sure that if I knew SQL decently that I could invoke some command to
do just that. I don't know SQL. Could anyone give me a way to copy
biblioitems.classification to items.itemcallnumber?
I'm assuming that this syncing of fields would solve my problem and that
then our librarian could begin working on inventory.
Thanks in advance to any help you can give me in this area.
-Matthew
More information about the Koha
mailing list