[Koha] Inventory & items.itemcallnumber

[Ryan Higgins]

I have a plugin for marc21 to autopopulate the itemcallnumber field during cataloging.  It has a couple of hardcoded elements specific to the frameworks we use, but I can generalize it and commit in the next couple days.


Ryan Higgins  

----LibLime----------------------------------
Providing Open-Source Solutions for Libraries
Migration, Training, Maintenance and Support
Featuring Koha ILS : http://liblime.com/koha
---------------------------------------------

----- "Joshua M. Ferraro" <jmf at liblime.com> wrote:
| Hiya Matthew,
| 
| See answers below :-)
| 
| ----- "Matthew Metzger" <news at metzger.cc> wrote:
| > 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.
| OK, so there are few steps here:
| 
| 1. run some SQL to copy the contents of biblioitems.classification
| into items.itemcallnumber
| 
| Here's a script I whipped up that should take care of that issue:
| 
| http://kados.org/stuff/update_itemcallnum.pl
| 
| NOTE: I haven't tested this script, if it destroys your database
| or pilfers your wife's jewelry, don't blame me ;-) Seriously, I'd
| recommend trying this out on a test database first to make sure
| it works.
| 
| When you've got that test db set up, you should be able to run:
| 
| $ wget http://kados.org/stuff/update_itemcallnum.pl
| $ export KOHA_CONF=/path/to/koha.conf (the test db one)
| $ perl -I /path/to/koha update_itemcallnumber.pl
| 
| 2. map items.itemcallnumber, set it up as an items field, and write
| a plugin to populate it automatically to save your cataloger the
| grief of having to copy/paste it from the biblio level.
| 
| This one is slightly trickier, because I haven't written the plugin
| yet ;-). I'll see if I have some time later today. If I don't
| get back to you in a day or two be sure to ping me ;-)
| 
| 3. I'd recommend looking at the newer versions of the inventory
| scripts in CVS, I know Ryan's patched them up lately and they
| (I think) have some better handling of the callnumber strings
| and more functions ...
| 
| Hope that helps.
| 
| Cheers,
| 
| -- 
| Joshua Ferraro                       SUPPORT FOR OPEN-SOURCE SOFTWARE
| President, Technology       migration, training, maintenance, support
| LibLime                                Featuring Koha Open-Source ILS
| jmf at liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
| 
| _______________________________________________
| Koha mailing list
| Koha at lists.katipo.co.nz
| http://lists.katipo.co.nz/mailman/listinfo/koha