Hello, sorry to deluge the list with so many posts. This is my time to work on our library system and I have to address a few different things all at the same time. When I go to Accounts and Reports > Inventory/Stocktaking > inventory.pl, enter in some values, and then press the "Generate Report" button, I get nothing. My template of choice is NPL, but I also tried it in the default template and it doesn't work there either. Here's my system stats: Koha version: 2.2.9 OS version (from 'uname -a'): Linux ubuntu-server1 2.6.15-28-powerpc #1 Thu May 10 09:50:21 UTC 2007 ppc GNU/Linux Perl version: 5.008007 MySQL version: mysql Ver 14.12 Distrib 5.0.22, for unknown-linux-gnu (powerpc) using readline 5.1 thanks for your time and any help you can give me. -Matthew
Hi Matthew The version of this script in cvs is fully operable. You should be able to drop-in replace inventory.pl and inventory.tmpl from the rel_2_2 branch. The LC sort and item count won't work unless you also update the Biblio.pm module. I would not recommend doing that unless you have experience with merging in code changes. (The report will work fine without those, but it will sort alphanumerically). Note that this report relies fully on the itemcallnumber koha field. So if you haven't been storing call numbers there, you'll not have much luck with it. Regards, Ryan Higgins ----LibLime---------------------------------- Providing Open-Source Solutions for Libraries Migration, Training, Maintenance and Support Featuring Koha ILS : http://liblime.com/koha --------------------------------------------- ----- "Matthew Metzger" <news@metzger.cc> wrote: | Hello, | | sorry to deluge the list with so many posts. This is my time to work | on | our library system and I have to address a few different things all at | | the same time. | | When I go to Accounts and Reports > Inventory/Stocktaking > | inventory.pl, enter in some values, and then press the "Generate | Report" | button, I get nothing. My template of choice is NPL, but I also tried | it | in the default template and it doesn't work there either. | | Here's my system stats: | | Koha version: 2.2.9 | OS version (from 'uname -a'): Linux ubuntu-server1 2.6.15-28-powerpc | #1 | Thu May 10 09:50:21 UTC 2007 ppc GNU/Linux | Perl version: 5.008007 | MySQL version: mysql Ver 14.12 Distrib 5.0.22, for unknown-linux-gnu | | (powerpc) using readline 5.1 | | thanks for your time and any help you can give me. | | -Matthew | | _______________________________________________ | Koha mailing list | Koha@lists.katipo.co.nz | http://lists.katipo.co.nz/mailman/listinfo/koha
Hello Ryan, thanks for the helpful details. I will check later today if we are using the itemcallnumber field (I sure hope we are). I'm the tech guy, not the librarian. If the script is fully operable in cvs, does that mean that it will work properly in Koha 2.2.10 and 3.0 when they are released? thanks again for your time, Matthew Metzger Ryan Higgins wrote:
Hi Matthew
The version of this script in cvs is fully operable. You should be able to drop-in replace inventory.pl and inventory.tmpl from the rel_2_2 branch. The LC sort and item count won't work unless you also update the Biblio.pm module. I would not recommend doing that unless you have experience with merging in code changes. (The report will work fine without those, but it will sort alphanumerically).
Note that this report relies fully on the itemcallnumber koha field. So if you haven't been storing call numbers there, you'll not have much luck with it.
Regards,
Ryan Higgins
----LibLime---------------------------------- Providing Open-Source Solutions for Libraries Migration, Training, Maintenance and Support Featuring Koha ILS : http://liblime.com/koha ---------------------------------------------
----- "Matthew Metzger" <news@metzger.cc> wrote: | Hello, | | sorry to deluge the list with so many posts. This is my time to work | on | our library system and I have to address a few different things all at | | the same time. | | When I go to Accounts and Reports > Inventory/Stocktaking > | inventory.pl, enter in some values, and then press the "Generate | Report" | button, I get nothing. My template of choice is NPL, but I also tried | it | in the default template and it doesn't work there either. | | Here's my system stats: | | Koha version: 2.2.9 | OS version (from 'uname -a'): Linux ubuntu-server1 2.6.15-28-powerpc | #1 | Thu May 10 09:50:21 UTC 2007 ppc GNU/Linux | Perl version: 5.008007 | MySQL version: mysql Ver 14.12 Distrib 5.0.22, for unknown-linux-gnu | | (powerpc) using readline 5.1 | | thanks for your time and any help you can give me. | | -Matthew | | _______________________________________________ | Koha mailing list | Koha@lists.katipo.co.nz | http://lists.katipo.co.nz/mailman/listinfo/koha
Hello, I checked our database and itemcallnumber is set to NULL on all records. Bad news for me. What needs to be done so that I can do inventory? I assume that the itemcallnumber for each record has to be manually entered. thanks for your time and help, Matthew Matthew Metzger wrote:
Hello Ryan,
thanks for the helpful details. I will check later today if we are using the itemcallnumber field (I sure hope we are). I'm the tech guy, not the librarian.
If the script is fully operable in cvs, does that mean that it will work properly in Koha 2.2.10 and 3.0 when they are released?
thanks again for your time,
Matthew Metzger
Ryan Higgins wrote:
Hi Matthew
The version of this script in cvs is fully operable. You should be able to drop-in replace inventory.pl and inventory.tmpl from the rel_2_2 branch. The LC sort and item count won't work unless you also update the Biblio.pm module. I would not recommend doing that unless you have experience with merging in code changes. (The report will work fine without those, but it will sort alphanumerically).
Note that this report relies fully on the itemcallnumber koha field. So if you haven't been storing call numbers there, you'll not have much luck with it.
Regards,
Ryan Higgins ----LibLime---------------------------------- Providing Open-Source Solutions for Libraries Migration, Training, Maintenance and Support Featuring Koha ILS : http://liblime.com/koha ---------------------------------------------
----- "Matthew Metzger" <news@metzger.cc> wrote: | Hello, | | sorry to deluge the list with so many posts. This is my time to work | on | our library system and I have to address a few different things all at | | the same time. | | When I go to Accounts and Reports > Inventory/Stocktaking > | inventory.pl, enter in some values, and then press the "Generate | Report" | button, I get nothing. My template of choice is NPL, but I also tried | it | in the default template and it doesn't work there either. | | Here's my system stats: | | Koha version: 2.2.9 | OS version (from 'uname -a'): Linux ubuntu-server1 2.6.15-28-powerpc | #1 | Thu May 10 09:50:21 UTC 2007 ppc GNU/Linux | Perl version: 5.008007 | MySQL version: mysql Ver 14.12 Distrib 5.0.22, for unknown-linux-gnu | | (powerpc) using readline 5.1 | | thanks for your time and any help you can give me. | | -Matthew | | _______________________________________________ | Koha mailing list | Koha@lists.katipo.co.nz | http://lists.katipo.co.nz/mailman/listinfo/koha
When I search the OPAC, I get a column in the results that is titled "call number". However, the value of this is not always unique. Of course this is a different field than itemcallnumber, but perhaps one field could be copied to the other. I'm guessing that itemcallnumber must be unique in order for the reports to work properly and so copying one field to the other would not solve my problem. Could anyone confirm if this is true or not. thanks, Matthew Metzger Matthew Metzger wrote:
Hello,
I checked our database and itemcallnumber is set to NULL on all records. Bad news for me. What needs to be done so that I can do inventory? I assume that the itemcallnumber for each record has to be manually entered.
thanks for your time and help,
Matthew
Matthew Metzger wrote:
Hello Ryan,
thanks for the helpful details. I will check later today if we are using the itemcallnumber field (I sure hope we are). I'm the tech guy, not the librarian.
If the script is fully operable in cvs, does that mean that it will work properly in Koha 2.2.10 and 3.0 when they are released?
thanks again for your time,
Matthew Metzger
Ryan Higgins wrote:
Hi Matthew
The version of this script in cvs is fully operable. You should be able to drop-in replace inventory.pl and inventory.tmpl from the rel_2_2 branch. The LC sort and item count won't work unless you also update the Biblio.pm module. I would not recommend doing that unless you have experience with merging in code changes. (The report will work fine without those, but it will sort alphanumerically).
Note that this report relies fully on the itemcallnumber koha field. So if you haven't been storing call numbers there, you'll not have much luck with it.
Regards,
Ryan Higgins ----LibLime---------------------------------- Providing Open-Source Solutions for Libraries Migration, Training, Maintenance and Support Featuring Koha ILS : http://liblime.com/koha ---------------------------------------------
----- "Matthew Metzger" <news@metzger.cc> wrote: | Hello, | | sorry to deluge the list with so many posts. This is my time to work | on | our library system and I have to address a few different things all at | | the same time. | | When I go to Accounts and Reports > Inventory/Stocktaking > | inventory.pl, enter in some values, and then press the "Generate | Report" | button, I get nothing. My template of choice is NPL, but I also tried | it | in the default template and it doesn't work there either. | | Here's my system stats: | | Koha version: 2.2.9 | OS version (from 'uname -a'): Linux ubuntu-server1 2.6.15-28-powerpc | #1 | Thu May 10 09:50:21 UTC 2007 ppc GNU/Linux | Perl version: 5.008007 | MySQL version: mysql Ver 14.12 Distrib 5.0.22, for unknown-linux-gnu | | (powerpc) using readline 5.1 | | thanks for your time and any help you can give me. | | -Matthew | | _______________________________________________ | Koha mailing list | Koha@lists.katipo.co.nz | http://lists.katipo.co.nz/mailman/listinfo/koha
----- "Matthew Metzger" <news@metzger.cc> wrote:
When I search the OPAC, I get a column in the results that is titled "call number". However, the value of this is not always unique. Of course this is a different field than itemcallnumber, but perhaps one field could be copied to the other. I'm guessing that itemcallnumber must be unique in order for the reports to work properly and so copying one field to the other would not solve my problem. Could anyone confirm if this is true or not. Hi Matthew,
OK, first ... itemcallnumber doesn't need to be unique, at least, that's not a database constraint, it's more of a policy decision. As far as the 'call number' column in the OPAC and Staff searches, this is an area of Koha that could be improved. The problem is that every library seems to handle the concept of 'call number' slightly differently. Right now, depending on which template you're using (npl vs default) the call number column will, by default, display a hard-coded value that is a mapping from the MARC record to koha's table values. A quick and dirty way to fix this for yourself is to decide which of the fields in the Koha Biblio Mapping section (in Admin) you want to display in the call number column, and go edit your template to reflect those fields (opac-searchresults.tmpl I believe). A more long-term solution could include a new management section of Koha allowing selection of what fields to display where ... this would be a fantastic project if someone has the time to work on it or the resources to hire a programmer to do it. 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
participants (3)
-
Joshua M. Ferraro -
Matthew Metzger -
Ryan Higgins