Dear Mr. Vimal, We have developed the code level multiple /fine slab system for Koha. Please feel free to contact the undersign for any clarifications. Thanks and Regards R Sunil Kumar Library Technologist 9686576695 -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: 20 September 2012 18:34 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 83, Issue 42 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Browse by hierarchy - Links not working (Manos PETRIDIS) 2. Re: Fwd: Re: Barcode info and maybe SQL/MARCXML help needed (Manos PETRIDIS) 3. Koha Version 3.9 (jackymasibo) 4. Re: Question about getting information for statistical reports (BWS Johnson) 5. Re: Browse by hierarchy - Links not working (Jared Camins-Esakov) 6. Incremental fine system in Koha (Vimal Kumar V.) ---------------------------------------------------------------------- Message: 1 Date: Thu, 20 Sep 2012 11:01:20 +0300 From: "Manos PETRIDIS" <egpetridis@yahoo.com> To: <koha@lists.katipo.co.nz> Subject: Re: [Koha] Browse by hierarchy - Links not working Message-ID: <053601cd9706$1f3b2460$5db16d20$@com> Content-Type: text/plain; charset="UTF-8" Thank you Mark for the warning and suggestions. The truth is I've had some unix experience in the distant past; instead of copying anything, I'd link so that I could easily revert to the original state. As I've mentioned before, I use a ready-made VM, the reason that I don't ask the provider of that image directly is that his (and your) replies will be available to us all, for all current and future users of his appliance. /etc/environment is empty in my installation, I've updated /home/koha/.bashrc instead, as per Ian's instructions. Kind regards, Manos P.S. I do miss the good old unix days when all I had to check was a .profile -----Original Message----- From: Mark Tompsett [mailto:mtompset@hotmail.com] Sent: Thursday, September 20, 2012 8:30 AM To: Manos PETRIDIS; 'anjoze' Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Browse by hierarchy - Links not working Greetings, DISCLAIMER: THIS FEEDBACK DOES NOT APPLY TO EVERYONE, PLEASE DON'T JUST TRY THIS BECAUSE YOU HAVE A PROBLEM.
About your problem *Can't locate C4/Context.pm in @INC* Someone in this forum found this solution: Copying C4 directory to /etc/perl/ should solve your problem: cp -a /usr/share/koha/lib/C4/ /etc/perl/
This is the WRONG solution. Yes, it works, but upgrading your koha in the future becomes a nightmare! There are supposed to be two environment variables defined: $KOHA_CONF $PERL5LIB If you do not have these defined, you will encounter problems running Koha scripts. (WARNING! WARNING! WARNING! I AM NOT RESPONSIBLE IF YOU DO NOT READING CAREFULLY.) *IF* (IF, IF, IF, IF, IF) PERL5LIB is not (I repeat NOT, NOT, NOT, NOT) defined at all, and given the results of your search: (DO NOT DO THIS IF PERL5LIB IS DEFINED, BECAUSE YOU COULD BREAK SOMETHING ELSE!) $ export PERL5LIB=/home/koha/kohaclone Follow up questions: If you have a kohaclone directory, how did you answer the build questions? If you didn't build this, and it is a virtual machine image, ask the provider of that image. One potential workaround, if your system is a koha only system: Under Ubuntu, and perhaps other debian-based OSes (though I haven't tested them) you can add to the bottom of /etc/environment (as root): PERL5LIB=/home/koha/kohaclone Log out, and log back in, and this will be set for EVERY user on the system. This is only a good solution if the system is a koha only system. Otherwise, you will need to modify appropriate rc shell scripts in particular users home directories to set it. GPML, Mark Tompsett ------------------------------ Message: 2 Date: Thu, 20 Sep 2012 11:06:21 +0300 From: "Manos PETRIDIS" <egpetridis@yahoo.com> To: "'Doug Dearden'" <dearden@sarsf.org> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed Message-ID: <053701cd9706$d2f34a50$78d9def0$@com> Content-Type: text/plain; charset="us-ascii" Very interesting and helpful update, thank you Doug! MP -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Doug Dearden Sent: Tuesday, September 18, 2012 6:04 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed Hi all, No issues here, just following up in case someone is looking at this thread in the future. I updated the database using the sql statement below, and it deleted most of the 852 datafields. I thought all was well but a week or so later found a record that still had some 852 datafields in it. Upon investigation I found a number of records - around 400, and all of them had multiple 852 datafields - at least two per record. I did some experimentation and the sql statement below only works on those records where there is a single 852 datafield. I tried some variations and found that if I ran this one it would remove the first 852 datafield: update biblioitems set marcxml = UpdateXML(marcxml, '//datafield[@tag="852"][1]', ''); I did a backup, ran the sql statement above several times until it returned 0 records changed (17 in fact, as I had one record with 16 852 datafields). Each time it ran it stripped off the leading 852 datafield. I then ran this one to check for any leftovers: SELECT ExtractValue (marcxml ,'//datafield[@tag="852"]/*') FROM biblioitems WHERE marcxml RLIKE '<datafield tag="852"'; It returned zero results. Ran touch_all_biblios.pl Zebra indexes rebuilt that night as part of our regular cron job. All looks good. - Doug -----Original Message----- From: Galen Charlton [mailto:gmc@esilibrary.com] Sent: Tuesday, August 28, 2012 3:42 PM To: Doug Dearden Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed Hi, No, whitespace between datafield elements is irrelevant as far as Koha's parsing of the MARCXML records is concerned. Regards, Galen On 08/28/2012 04:27 PM, Doug Dearden wrote:
Hi Galen,
I ran the sql command against my test DB to delete the 852 tag limiting it to one record. It takes out the 852 datafield but leaves behind some blank space - example below. Is this going to matter? - Thanks, Doug
<datafield tag="700" ind1=" " ind2=" "> <subfield code="a">Hymes, Dell, editor.</subfield> </datafield>
<datafield tag="942" ind1=" " ind2=" "> <subfield code="c">BK</subfield> </datafield>
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Galen Charlton Sent: Tuesday, August 28, 2012 12:59 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed
Hi,
On 08/28/2012 02:56 PM, Galen Charlton wrote:
Unless you had changed your MARC frameworks to use the 852 field for item data rather than the 952, if the 852s are from your previous system, I'd suggest that you actually *delete* them. A bib export from Koha will include the item data in 952 fields if you need them for record interchange or union catalog purposes, and getting rid of the legacy 852s avoids the risk of confusing staff about the state of an item record.
And you can delete the 852 fields in two steps (or three, counting the backup you should make first :) ). First, run the following SQL update:
update biblioitems set marcxml = UpdateXML(marcxml, '//datafield[@tag="852"]', '');
Then run touch_all_biblios.pl, which will (in addition to signalling that the bibs should be reindexed) synchronize biblioitems.marc with biblioitems.marcxml.
Regards,
Galen
-- Galen Charlton Director of Support and Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 3 Date: Thu, 20 Sep 2012 11:48:01 +0300 From: jackymasibo <jmasibo@gmail.com> To: koha <koha@lists.katipo.co.nz> Subject: [Koha] Koha Version 3.9 Message-ID: <CAOWzCzsONT+ixrAf+hWm2UV1unRJm4n3PK8hGig7NWXX6xcSYg@mail.gmail.com> Content-Type: text/plain; charset=windows-1252 Hi guys, My Koha system is up and running but am just wondering which Koha version am I running is it a stable release or development because after clicking on about Koha button I got the following information: About Koha Server information Koha version: 3.09.00.022 OS version ('uname -a'): Linux LIBRARY 2.6.32-5-686 #1 SMP Sun May 6 04:01:19 UTC 2012 i686 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU Please advise me if this version is the best for a production environment or if it?s not the best what should I do to change it to the current stable release? Thanks in advance ------------------------------ Message: 4 Date: Thu, 20 Sep 2012 03:21:02 -0700 (PDT) From: BWS Johnson <abesottedphoenix@yahoo.com> To: Diedre Conkling <diedre08@gmail.com>, koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Question about getting information for statistical reports Message-ID: <1348136462.4971.YahooMailNeo@web140805.mail.bf1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Salve! ??? I had to rub me eyes and wonder if I were conflating listservs. :D Welcome to Koha.
Every year we need to fill out statistical reports for the state libraries and, ultimately, the IMLS (Institute of Museum and Library Services).? I am sure other libraries have had to do the same thing.?
??? A long time ago when animals could talk, there were no statistics whatsoever with Koha. Don't worry, there are now. I believe that you have Paul Poulain to thank for this very simple breakdown, or perhaps Chris Cormack. Or perhaps I'm mortally offending whoever it actually was a jillion years ago. The thing is, I asked for it, and the nice developers made it like RIGHT AWAY with a smile. ??? Your needs should be close to the initial thingy that I asked for, since we essentially needed the same thing at my tiny olde Library in Western Massachusetts. If it is in fact what you want, the good news is that you don't have to screw about with SQL. :D ??? You can get to the bespoke thingy by logging into the Staff side and clicking Reports (this has a nifty pie chart on the Bywater Demo, dunno about your jobby) Catalogue by itemtype
We also are interested in finding out the best way to create reports of daily circulation that would include checking out items at the library for that library's patrons and the items we send on intralibrary loan to other libraries in our network.
Thanks for any information you can send our way.
??? I would recommend that you boot about one of the demo sites and click lots of buttons. That way you can get comfy with reports in general. It'll help you familiarise yourself with what Koha will already run. It also will make you feel as though you can't possibly break anything, since you can't. ??? That said, I don't think there's a Librarian alive that has all of their statistical nerdy needs satiated by the little array of preconstructed ones at hand. That level of nerdiness is a 2 part process. The first thing you ought do is head to: http://wiki.koha-community.org/wiki/SQL_Reports_Library ??? to see if someone has already slapped one together. They prolly have. There are a mind boggling number of them. ??? if not, then you head on over to the Staff side then Reports then Guided Reports Create from SQL ??? If mah babbling didn't help, there's always the manual. http://manual.koha-community.org/3.8/en/reports.html ??? Nicole did a preso on this, but it was way back at Plano. Perhaps she's done summat newer lately that the pigeons have buried deep in the Google results pages. Cheers, Brooke ------------------------------ Message: 5 Date: Thu, 20 Sep 2012 07:27:58 -0400 From: Jared Camins-Esakov <jcamins@cpbibliography.com> To: Manos PETRIDIS <egpetridis@yahoo.com> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Browse by hierarchy - Links not working Message-ID: <CALVDfQzoa+cPDVZLDjH6vXaBDXS3WZLwJhroivJKLK6JofBnhg@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Manos, P.S. I do miss the good old unix days when all I had to check was a .profile I'm not entirely sure what has changed. ~/.profile is still an excellent place to store your environment variables if you use a Bourne shell derivative. Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/ ------------------------------ Message: 6 Date: Thu, 20 Sep 2012 18:34:05 +0530 From: "Vimal Kumar V." <vimal0212@gmail.com> To: Koha-List <koha@lists.katipo.co.nz> Subject: [Koha] Incremental fine system in Koha Message-ID: <CAEaJrwXSXdVNoL8esHcqvJK=gst9181Pi3rVMnHhZAGOeLj9_Q@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Dear Friends, In our library, move to Koha from SOUL ILS is in progress. Library staff alone are doing the migration process. We have no technical support from outside. We successfully transfered bibliographical details and patron details to Koha. One problem is with incremental fine system. Our fine system is that, first ten days .50 paise per day. After that Rs. 1 per day. Anybody made customization to run incremental fine system? Pls. share how it solved and help us to work out it. Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White ------------------------------ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 83, Issue 42 ************************************