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
I suppose that an alternative solution would be to modify the inventory.pl script so that it depends on biblioitems.classification instead of items.itemcallnumber. However, I'm guessing that this solution would be bad form as it modifies the program, which would then break every time Koha was upgraded. your thoughts? -Matthew Matthew Metzger wrote:
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
Hiya Matthew, See answers below :-) ----- "Matthew Metzger" <news@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@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
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@liblime.com> wrote: | Hiya Matthew, | | See answers below :-) | | ----- "Matthew Metzger" <news@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@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS | | _______________________________________________ | Koha mailing list | Koha@lists.katipo.co.nz | http://lists.katipo.co.nz/mailman/listinfo/koha
Joshua M. Ferraro wrote:
Hiya Matthew,
See answers below :-)
----- "Matthew Metzger" <news@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,
First, thanks Joshua for the script. It seemed to work perfectly. I completed steps 1 and 3 from the directions you gave me. I am not sure how to map items.itemcallnumber and Ryan said that he might commit a plugin that would do just this, so I'd thought I'd wait on that. I had assumed that once items.itemcallnumber had values, that I'd be able to get some type of result from the inventory.pl script. However, I still got nothing. I am also not able to get a result from the "Not seen since:" field. I thought that this would not depend at all on items.itemcallnumber so it might work. As it stands, I'm not able to get any result from any entry field using inventory.pl. Is this normal behavior for 2.2.9? thanks all for your time and your help. -Matthew
Hiya Matthew, See below: ----- "Matthew Metzger" <news@metzger.cc> wrote:
First, thanks Joshua for the script. It seemed to work perfectly. Excellent, glad to hear it.
I completed steps 1 and 3 from the directions you gave me. I am not sure how to map items.itemcallnumber and Ryan said that he might commit a plugin that would do just this, so I'd thought I'd wait on that. You can map items.itemcallnumber to a items tag/subfield from either the Links - Koha MARC DB section (easy) or the Bibliographic Framework section(hard) of the Admin module. Note that the plugin is something you can add later to the Bibliographic Framework, but you still have to set up the mapping or the itemcallnumber field won't show up in your items add/edit screen.
I had assumed that once items.itemcallnumber had values, that I'd be able to get some type of result from the inventory.pl script. However, I still got nothing. I am also not able to get a result from the "Not seen since:" field. I thought that this would not depend at all on items.itemcallnumber so it might work. As it stands, I'm not able to get any result from any entry field using inventory.pl. Is this normal behavior for 2.2.9? It could very well be. There were quite a few updates that didn't make it into the release. Try grabbing the latest inventory script/template from CVS and replacing your current ones:
script: http://cvs.savannah.nongnu.org/viewvc/koha/reports/inventory.pl?view=log&root=koha&pathrev=rel_2_2 template: http://cvs.savannah.nongnu.org/viewvc/koha/koha-tmpl/intranet-tmpl/npl/en/reports/inventory.tmpl?view=log&root=koha&pathrev=rel_2_2 Let us know how it goes. Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
Joshua M. Ferraro wrote:
Hiya Matthew,
See below:
----- "Matthew Metzger" <news@metzger.cc> wrote:
First, thanks Joshua for the script. It seemed to work perfectly. Excellent, glad to hear it.
I completed steps 1 and 3 from the directions you gave me. I am not sure how to map items.itemcallnumber and Ryan said that he might commit a plugin that would do just this, so I'd thought I'd wait on that. You can map items.itemcallnumber to a items tag/subfield from either the Links - Koha MARC DB section (easy) or the Bibliographic Framework section(hard) of the Admin module. Note that the plugin is something you can add later to the Bibliographic Framework, but you still have to set up the mapping or the itemcallnumber field won't show up in your items add/edit screen.
I had assumed that once items.itemcallnumber had values, that I'd be able to get some type of result from the inventory.pl script. However, I still got nothing. I am also not able to get a result from the "Not seen since:" field. I thought that this would not depend at all on items.itemcallnumber so it might work. As it stands, I'm not able to get any result from any entry field using inventory.pl. Is this normal behavior for 2.2.9? It could very well be. There were quite a few updates that didn't make it into the release. Try grabbing the latest inventory script/template from CVS and replacing your current ones:
script: http://cvs.savannah.nongnu.org/viewvc/koha/reports/inventory.pl?view=log&root=koha&pathrev=rel_2_2
Let us know how it goes.
Cheers,
Hello, I believe it is operational. It returns books now when both the "Item location" and "Not seen since" fields have values. None of the books have a seen value, but I think we can work with that. Our librarian will be scanning in each section to a saved text file and then we will use those to mark the books on the shelves as seen with the "use a barcode file" feature. It will take her a while to get all of the books scanned to the text files, but it looks like everything will work now. thanks so much for your help. -Matthew
participants (3)
-
Joshua M. Ferraro -
Matthew Metzger -
Ryan Higgins