[Koha] RE :Incremental fine system in Koha

Sunil Kumar sunil.kumar at ecoleglobal.com
Fri Sep 28 00:12:11 NZST 2012


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 at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
koha-request at lists.katipo.co.nz
Sent: 20 September 2012 18:34
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 83, Issue 42

Send Koha mailing list submissions to
	koha at 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 at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at 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 at yahoo.com>
To: <koha at 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 at hotmail.com]
Sent: Thursday, September 20, 2012 8:30 AM
To: Manos PETRIDIS; 'anjoze'
Cc: koha at 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 at yahoo.com>
To: "'Doug Dearden'" <dearden at sarsf.org>
Cc: koha at 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 at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Doug Dearden
Sent: Tuesday, September 18, 2012 6:04 PM
To: koha at 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 at 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 at lists.katipo.co.nz 
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Galen Charlton
> Sent: Tuesday, August 28, 2012 12:59 PM
> To: koha at 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 at 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 at 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 at gmail.com>
To: koha <koha at lists.katipo.co.nz>
Subject: [Koha] Koha Version 3.9
Message-ID:
	<CAOWzCzsONT+ixrAf+hWm2UV1unRJm4n3PK8hGig7NWXX6xcSYg at 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 at yahoo.com>
To: Diedre Conkling <diedre08 at gmail.com>, koha
	<koha at lists.katipo.co.nz>
Subject: Re: [Koha] Question about getting information for statistical
	reports
Message-ID:
	<1348136462.4971.YahooMailNeo at 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 at cpbibliography.com>
To: Manos PETRIDIS <egpetridis at yahoo.com>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Browse by hierarchy - Links not working
Message-ID:
	<CALVDfQzoa+cPDVZLDjH6vXaBDXS3WZLwJhroivJKLK6JofBnhg at 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 at cpbibliography.com
(web) http://www.cpbibliography.com/


------------------------------

Message: 6
Date: Thu, 20 Sep 2012 18:34:05 +0530
From: "Vimal Kumar V." <vimal0212 at gmail.com>
To: Koha-List <koha at lists.katipo.co.nz>
Subject: [Koha] Incremental fine system in Koha
Message-ID:
	<CAEaJrwXSXdVNoL8esHcqvJK=gst9181Pi3rVMnHhZAGOeLj9_Q at 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 at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


End of Koha Digest, Vol 83, Issue 42
************************************



More information about the Koha mailing list