- Koha - lists.katipo.co.nz

Re: [Koha] Koha Digest, Vol 41, Issue 80
by jksamyal 01 Apr '09

01 Apr '09

hello nicole, thanks for fine reply. its running but the problem is that it is showing only one page of fine, but there are too many defaulters. thanks jatinder kumar On Sun, Mar 29, 2009 at 4:30 AM, <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)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(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)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: fines list is not generated (jatinder.KUMAR) > 2. Re: {Possible SPAM} RE: [Koha-devel] Barcode Don't Found > (Roche III, Edward) > 3. Re: Video camera at Kohacon (Darrell Ulm) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 27 Mar 2009 23:47:11 -0700 (PDT) > From: "jatinder.KUMAR" <jksamyal(a)gmail.com> > Subject: Re: [Koha] fines list is not generated > To: koha(a)lists.katipo.co.nz > Message-ID: <22754215.post(a)talk.nabble.com> > Content-Type: text/plain; charset=UTF-8 > > > Thankyou very much nicole > > Nicole Engard wrote: >> >> Sounds like you need a custom report - I have one that gives me all >> the patrons with fines and the amount of the fine: >> >> SELECT >> borrowers.cardnumber,borrowers.surname,borrowers.firstname,FORMAT(SUM(accountlines.amountoutstanding),2) >> as due FROM borrowers LEFT JOIN accountlines on >> (borrowers.borrowernumber=accountlines.borrowernumber) WHERE >> accountlines.amountoutstanding > 0 GROUP BY borrowers.cardnumber ORDER >> BY borrowers.surname asc >> >> >> --- >> >> Nicole C. Engard >> Open Source Evangelist, LibLime >> (888) Koha ILS (564-2457) ext. 714 >> nce(a)liblime.com >> AIM/Y!/Skype: nengard >> >> http://liblime.com >> http://blogs.liblime.com/open-sesame/ >> >> >> >> On Thu, Mar 26, 2009 at 11:51 PM, jksamyal <jksamyal(a)gmail.com> wrote: >>> We are using Koha 3.0 version. Now we are closing the semester and >>> ? exam are on. we want to generate a list of fines of defaulted >>> ? students. >>> ? Please guide me for this. >>> ? jatinder kumar >>> _______________________________________________ >>> Koha mailing list >>> Koha(a)lists.katipo.co.nz >>> http://lists.katipo.co.nz/mailman/listinfo/koha >>> >> _______________________________________________ >> Koha mailing list >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> > > -- > View this message in context: http://www.nabble.com/fines-list-is-not-generated-tp22735709p22754215.html > Sent from the Koha - Discuss mailing list archive at Nabble.com. > > > > ------------------------------ > > Message: 2 > Date: Sat, 28 Mar 2009 08:41:06 -0400 > From: "Roche III, Edward" <edward_roche(a)solanco.k12.pa.us> > Subject: Re: [Koha] {Possible SPAM} RE: [Koha-devel] Barcode Don't > Found > To: <koha-devel(a)lists.koha.org>, <koha(a)lists.katipo.co.nz> > Message-ID: > <ACFB645515A2A143A2066BE75BF6D87A01D155B6(a)exchange.solanco.local> > Content-Type: text/plain; charset="utf-8" > > I missed replying to the groups..... > > I am being dumb but where does this patch go? I found what I need to do for the sys.pref but not sure where to put the patch. > > Thanks! > Ed > > Edward J. Roche > Network Administrator > Solanco School District > 717.786.2151 x2437 > > "At the End of the Day, Did You Play to Win or Not to Lose?" > > > > -----Original Message----- > From: Michael Hafen [mailto:mdhafen@tech.washk12.org] > Sent: Friday, March 27, 2009 12:00 PM > To: Roche III, Edward > Cc: koha-devel(a)lists.koha.org; koha(a)lists.katipo.co.nz > Subject: {Possible SPAM} RE: [Koha-devel] [Koha] Barcode Don't Found > Importance: Low > > I'll attach a modified patch to do it. You'll still have to update the sys. pref. options to enable this feature. Look at the changes to installer/data/mysql/en/mandatory/sysprefs.sql for an idea of what to set the sys. pref. to. > > Good luck. > > On Fri, 2009-03-27 at 11:42 -0400, Roche III, Edward wrote: >> How do you create the filter? >> >> Thanks! >> Ed >> >> Edward J. Roche >> Network Administrator >> Solanco School District >> 717.786.2151 x2437 >> >> "At the End of the Day, Did You Play to Win or Not to Lose?" >> >> >> >> -----Original Message----- >> From: Michael Hafen [mailto:mdhafen@tech.washk12.org] >> Sent: Friday, March 27, 2009 11:29 AM >> To: Roche III, Edward >> Cc: koha-devel(a)lists.koha.org >> Subject: Re: [Koha-devel] [Koha] Barcode Don't Found >> >> I have in my libraries several copies with a "T " before the number >> part of the barcode. Koha works with it fine. I find the trick is to >> make sure what's in the Koha database and what's encoded in the >> barcode are the same. It is possible with itemInputBarcodeFilter >> processing. I've used that sys. pref. to strip leading spaces ( which >> I put in ) from some barcodes. >> >> If what you want is to be able to enter just the number, or the "T " >> and the number ( like from a barcode scanner ), then I think making a >> custom itemInputBarcodeFilter ( like I did to trim leading spaces ) >> would be a good solution. >> >> On Fri, 2009-03-27 at 10:00 -0400, Roche III, Edward wrote: >> > That is an idea but I would think there was a way to have Koha >> > except the T+space. >> > >> > Thanks! >> > Ed >> > >> > Edward J. Roche >> > Network Administrator >> > Solanco School District >> > 717.786.2151 x2437 >> > >> > "At the End of the Day, Did You Play to Win or Not to Lose?" >> > >> > >> > >> > -----Original Message----- >> > From: koha-bounces(a)lists.katipo.co.nz >> > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard >> > Sent: Friday, March 27, 2009 9:52 AM >> > To: koha(a)lists.katipo.co.nz >> > Subject: Re: [Koha] [Koha-devel] Barcode Don't Found >> > >> > > Currently doing it by hand but have tried with the scanner with no >> > luck. >> > >> > I asked because sometimes scanners are configured to add characters >> > where you might not expect them. I did a quick test in my 3.0 >> > installation and didn't have any problem typing in the barcode.. I >> > don't have any prefix options specified. >> > >> > What I wonder is if you couldn't store just the numeric portion of >> > the barcode (if it's the T+space causing the problem) and configure >> > your scanners to strip off the "T "? Of course you'd have to consult >> > the documentation for your scanners to know if that was possible. >> > We've done something similar in the past. >> > >> > -- Owen >> > > -- > Michael Hafen > Systems Analyst and Programmer > Washington County School District > Utah, USA > > for Koha checkout > http://koha-dev.washk12.org > or > git://koha-dev.washk12.org/koha > > ------------------------------ > > Message: 3 > Date: Sat, 28 Mar 2009 13:57:13 +0000 (UTC) > From: Darrell Ulm <darrellulm(a)smfpl.org> > Subject: Re: [Koha] Video camera at Kohacon > To: koha(a)lists.katipo.co.nz > Message-ID: <loom.20090328T135242-426(a)post.gmane.org> > Content-Type: text/plain; charset=us-ascii > > Chris Cormack <chris@...> writes: >> If there is anyone who owns a digital video camera and is coming to >> Kohacon. If they could bring their camera along that would be >> fantastic. >> We are getting lots of requests for video of the sessions from people >> who can't make it. > > I think many would like to see video of KohaCon sessions. > > The upload to YouTube is easy. > > Hope video is produced since I cannot attend this year. It would be a fantastic > promotional tool to have video available for anyone interested. > > If someone just shoots video I am willing to do the uploading and some simple > editing in my spare time. > > Thank you! :) > > > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 41, Issue 80 > ************************************ >

2 1

Fine report is not generated.
by Harjeet Singh 01 Apr '09

01 Apr '09

We are using Koha 3.0 version. we want to generate a report of fines. Please help me for this. -- View this message in context: http://www.nabble.com/Fine-report-is-not-generated.-tp22735801p22735801.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Re: [Koha] apache configuration and login problem
by Carmel Young 01 Apr '09

01 Apr '09

Hi, there. Still having problems trying to reset the databaseuser password. We have authentication denied because of too many failed attempts. We tried your suggestion: Try checking /etc/koha/koha-conf.xml. Find following section. We got stuck here: Access denied/ .... <config> <db_scheme>mysql</db_scheme> <database>koha</database> <hostname>localhost</hostname> <port>3306</port> <user>kohaadmin</user> <pass>kohaadmin</pass> > .... On 27/03/2009, Abhishek Amberkar [अभिषेक] <abhishek.amberkar(a)gmail.com> wrote: > On Thu, Mar 26, 2009 at 6:24 PM, Carmel Young > <carmely.cunima(a)googlemail.com> wrote: >> Using Koha 3.0.0 on Linux NOT WINDOWS! We have two problems. > > That's really good. :) > >> >> 1. Follow up to the login issue; >> >> Using Koha 3.0.0 on Linux. >> >> We had trouble with a failed file - you sent us some advice to use >> gedit, and we recovered this file. Unfortunately, another problem has >> arisen - cannot log into "kohadbuser" because of too many >> authentication failures - the exact message reads "Access denied for >> 127.0.0.1. The host has been blocked because of too many >> authentication failures." > > Try checking /etc/koha/koha-conf.xml. Find following section. > .... > <config> > <db_scheme>mysql</db_scheme> > <database>koha</database> > <hostname>localhost</hostname> > <port>3306</port> > <user>kohaadmin</user> > <pass>kohaadmin</pass> > .... > In your case database, user, pass may be different. So using that > information try to logging in MySQL from command line > > $ mysql -u kohaadmin -pkohadmin -h localhost > > Note : there is no space between "-p" and "kohaadmin" > If you are not able to get mysql prompt, "mysql>", then there's the > problem with login information. > > Then you may try login as a root user to mysql > $ mysql -u root -p<root_user_password> > > You should get mysql prompt "mysql>". Now try adding user for koha. > 1) First create database for koha, if not created already > mysql> CREATE DATABASE <databasename>; > > 2) Now add user who will use newly created koha database > mysql> GRANT ALL ON <databasename>.* FOR '<username>'@'<hostname>' > IDENTIFIED BY '<password>'; > > Replace <databasename>, <username>, <password> with your choice. > Replace <hostname> with localhost, since your mysql and koha > installation resides on same system. Please note that username, > hostname and password are in single quotes. > > 3) mysql> FLUSH PRIVILEGES; > 4) mysql> QUIT; > > Now, remember that, fields in "GRANT ALL" command should match to > /etc/koha/kona-conf.xml file fields, then only you will get proper > connectivity. > > >> >> The advice you sent us was for a Windows platform, but we are using Debian >> Etch. > > Debian Rocks!!! > >> >> 2. We want to configure the apache IP address, but we can't get to >> sites-available. When we type in "cd/etc/apache2/sites-available", it >> tells us there is no directory >> >> I hope this is not too many problems for you to solve... > > As Joe rightly pointed there's space after "cd" command. > > But let's check if you have apache installed or not. From command line try > > $ aptitude search apache | grep ^i > $ ls /etc/apache2 > > Post the output of both commands and /etc/koha/koha-conf.xml file's > database connectivity section to this list. > > > -- > With Regards > Abhishek Amberkar > > Learn to appreciate a beauty within... >

2 1

Search By Corporate Name
by Rovin 01 Apr '09

01 Apr '09

Hello, When i search the database for a book, and i select search by corporate name and i put the corporate name, it doesn't find anything. However, when i search by corporate name by phrase, it works. WHY? Regards Rovin -- View this message in context: http://www.nabble.com/Search-By-Corporate-Name-tp22791973p22791973.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Fwd: re:koha and zebra
by arun kumar 01 Apr '09

01 Apr '09

hi friends . i am arun kumar ,now i am installing koha3 on ubuntu8.10 ,i have choosen *zebra* option ,and i created my library and order and received the books ,but if i made a search in opac it shows that result not found . try to rebuild the index root@ubuntu-laptop:~#* export PERL5LIB=/usr/share/koha/lib* root@ubuntu-laptop:~# export KOHA_CONF=/etc/koha/koha-conf.xml root@ubuntu-laptop:~#*/usr/share/koha-3.00.00/misc/migration_tools/rebuild_zebra.pl -a * it shows the result as Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/zebradb/biblios Zebra authorities directory = /var/lib/koha/zebradb/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 ==================== REINDEXING zebra ==================== skipping biblios ==================== CLEANING ==================== root@ubuntu-laptop:~#*/usr/share/koha-3.00.00/misc/migration_tools/rebuild_zebra.pl -b * Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/zebradb/biblios Zebra authorities directory = /var/lib/koha/zebradb/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 1 Records exported: 1 ==================== REINDEXING zebra ==================== 10:36:24-01/04 zebraidx(7149) [log] zebra_start /etc/koha/zebradb/zebra-biblios.cfg 1.3.50 10:36:24-01/04 zebraidx(7149) [debug][log] zebra_register_open rw = 1 useshadow=1 p=0x9369268,n=,rp=(none) 10:36:24-01/04 zebraidx(7149) [log] enabling cache spec=/var/lib/koha/zebradb/biblios/shadow:4G 10:36:24-01/04 zebraidx(7149) [log] cache_fname = /var/lib/koha/zebradb/biblios/shadow/cache 10:36:24-01/04 zebraidx(7149) [log] profilePath=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en cwd=/root 10:36:24-01/04 zebraidx(7149) [log] dir /tmp/ccVUlA8ixY/biblio 10:36:24-01/04 zebraidx(7149) [log] add grs.marcxml.record /tmp/ccVUlA8ixY/biblio/exported_records 0 10:36:24-01/04 zebraidx(7149) [log] zebra_end_trans 10:36:24-01/04 zebraidx(7149) [log] sorting section 1 10:36:24-01/04 zebraidx(7149) [log] Iterations . . . 458 10:36:24-01/04 zebraidx(7149) [log] Distinct words . 195 10:36:24-01/04 zebraidx(7149) [log] Updates. . . . . 0 10:36:24-01/04 zebraidx(7149) [log] Deletions. . . . 0 10:36:24-01/04 zebraidx(7149) [log] Insertions . . . 195 10:36:24-01/04 zebraidx(7149) [debug][log] zebra_register_close p=0x9369268 10:36:24-01/04 zebraidx(7149) [log] Records: 1 i/u/d 1/0/0 10:36:24-01/04 zebraidx(7149) [log] user/system: 2/0 10:36:24-01/04 zebraidx(7149) [debug][log] zebra_stop 10:36:24-01/04 zebraidx(7149) [log] zebraidx times: 0.20 0.02 0.00 10:36:24-01/04 zebraidx(7150) [log] zebra_start /etc/koha/zebradb/zebra-biblios.cfg 1.3.50 10:36:24-01/04 zebraidx(7150) [log] enabling cache spec=/var/lib/koha/zebradb/biblios/shadow:4G 10:36:24-01/04 zebraidx(7150) [log] cache_fname = /var/lib/koha/zebradb/biblios/shadow/cache 10:36:24-01/04 zebraidx(7150) [log] commit start 10:36:24-01/04 zebraidx(7150) [debug][log] zebra_stop ==================== CLEANING ==================== *root@ubuntu-laptop:~# /usr/share/koha-3.00.00/misc/migration_tools/rebuild_zebra.pl -z Must specify -b or -a to reindex bibs or authorities Please do '/usr/share/koha-3.00.00/misc/migration_tools/rebuild_zebra.pl --help' to see usage.* AFTER THIS I MADE A SEARCH FOR BOOKS IN MY LIBRARY , BUT STILL IT SHOWS RESULT NOT FOUND what shall i do further ,please help me friends -- WITH BEST WISHES ARUNKUMAR.P

4 3

Error(s) in your MARC configuration
by Sheldon T. 01 Apr '09

01 Apr '09

Hello, I am from the University of Guyana and I am currently testing Koha v3.0 (installed on linux OS). There are five frameworks and whenever the MARC Bibliographic Framework Test is run, it shows an error. I want to know if there is anyway that I can detect which framework has the error. Here is the screen shot of the error observed: http://www.nabble.com/file/p22808373/koha_error.jpg Regards, Sheldon -- View this message in context: http://www.nabble.com/Error%28s%29-in-your-MARC-configuration-tp22808373p22… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 2

Switch over from Newgenlib to koha????
by Navin Soni 01 Apr '09

01 Apr '09

Dear Professionals, Goog Mrng.. We are from INMAS, DRDO, Delhi. Presently we are using newgenlib (OSS), we had tried a lot to give AMC to Newgenlib developers (M/s Verus Solutions) at normal rates but they did not responded positive. We library people are not expertise in JAVA and supporting softwares of Newgenlib therefore now it is not possible us to continue work without technical support. As this software constantly requires technical support which we are not able to find out who may take AMC of this Newgenlib software. Now may I request on this forum who can guide us how to overcome this problem of AMC. In alternative, we are planning to either switch over to KOHA and migrate our records into KOHA 2.2.9 ver. or wait for any agency who can undertake the AMC of Newgenlib. I request all my fellow professionals on this forum to guide me in this regard. Waiting for help and guidance. -- ================================= Navin Kumar Soni INMAS, DRDO, Min of Defence, Brig SK Mazumdar Marg Delhi-110054. Ph: 01123985466, 09868459805 http://www.drdo.org/labs/inmas/index.html Email: navinsoni22(a)gmail.com, navin(a)inmas.drdo.in ===================================

1 0

Error in the framework
by Sheldon T. 31 Mar '09

31 Mar '09

There are three frameworks and, an error is generated and cannot be found. That I know because the MARC Bibliographic Framework Test showed that there is one error and it didn't say where is the error. I want to know if there is anyway that i can detect where the error is. thank you in advance -- View this message in context: http://www.nabble.com/Error-in-the-framework-tp22805231p22805231.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

install koha on debian
by MATALDA CHARLES 31 Mar '09

31 Mar '09

Hi I'm runing koha 3.00.01 on debian 5.0 , whatever i have a problem messages" # Sudo dpkg --set-selections,install-misc/debian pakages .... no such file or directory # Make install pl .....no such file or directory >and how to execute the code checkout after install koha ?? Matalda(a)fr.net _________________________________________________________________ See all the ways you can stay connected to friends and family http://www.microsoft.com/windows/windowslive/default.aspx

2 1

Search error
by mohan pradhan 31 Mar '09

31 Mar '09

I am using KOHA 2.2.9. When searched through quick search and any word, then the search results are displayed. But when searched with title, author, subject search option then the search are not displayed. Let me know to solve this problem. Regards, Sincerely yours, Dr. Mohan Raj Pradhan Member-Secretary HealthNet Nepal

1 0