- Koha - lists.katipo.co.nz

Re: [Koha] Koha instance with over 86 000 item records is been slow
by Paul 22 Oct '13

22 Oct '13

At 08:43 PM 10/22/2013 +0200, amutsikiwa(a)uzlib.uz.ac.zw wrote: >Hi >I have a Koha instance with over 86 000 item records and is reported to >getting somewhat slower especially in the circulation function. It is >running on a server with 2.7 GHz processor and 2G RAM and running on >Ubuntu. Is there a way of optimizing Mysql database? CAUTION: backup your mysql db Have you ever tried cleanup_database.pl ? (it can be found in /usr/share/koha/bin/cronjobs/) We regularly use (manually, not as a cron) --sessions, --zebraqueue, --mail, --logs and --import. We use quite a short time span (often as low as one day) and immediately do a complete re-index of zebra (biblios and authorities.) The savings are quite impressive; however I would point out that we are a "reference" not a "lending" library so have no experience whether patron records would be affected. We have never used --merged nor --searchhistory. Usage: [-h|--help] [--sessions] [--sessdays DAYS] [-v|--verbose] [--zebraqueue DAYS] [-m|--mail] [--merged] [--import DAYS] [--logs DAYS] [--searchhistory DAYS] -h --help prints this help message, and exits, ignoring all other options --sessions purge the sessions table. If you use this while users are logged into Koha, they will have to reconnect. --sessdays DAYS purge only sessions older than DAYS days. -v --verbose will cause the script to give you a bit more information about the run. --zebraqueue DAYS purge completed zebraqueue entries older than DAYS days. Defaults to 30 days if no days specified. -m --mail DAYS purge items from the mail queue that are older than DAYS days. Defaults to 30 days if no days specified. --merged purged completed entries from need_merge_authorities. --import DAYS purge records from import tables older than DAYS days. Defaults to 60 days if no days specified. --logs DAYS purge entries from action_logs older than DAYS days. Defaults to 180 days if no days specified. --searchhistory DAYS purge entries from search_history older than DAYS days. Defaults to 30 days if no days specified Good luck - Paul

1 0

Fwd: Managing fines in a consortial environment
by Cab Vinton 22 Oct '13

22 Oct '13

Oof. We're part of a 3-library Koha consortium and technically each library is supposed to only deal with fines pertaining to its own items. But the Fines detail page is less than helpful when it comes to figuring out to which library fines are owed. (Staff have to look at each item individually.) Do other Koha consortia have best practices for dealing with fines when dealing with multiple libraries (vs. branches of the same library system)? What improvements would you suggest? It seems like this would be an area where consensus would be a good thing to have before submitting bug reports, feature requests, etc. FWIW, the only related bug I've found is this one -- http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9975 Thanks, Cab Vinton, Director Plaistow Public Library Plaistow, NH & Southern NH Library Cooperative

3 2

Re: [Koha] Koha Escaping HTML characters
by Stefano Bargioni 22 Oct '13

22 Oct '13

Hi, Sheldon: I suggest you to use something like text1 -- text2 -- text3 in your data, and convert strings ' -- ' into '<br/>' or '<p>' while displaying a 500 field in opac pages. You can do it using Javascript (jQuery) statements, something like this: var t = $('.contentblock').html(); t = t.replace(/ -- /g,'<p>'); $('.contentblock').html(t); This works in pages like "http://.../cgi-bin/koha/opac-detail.pl?biblionumber=NNN", where 5xx tags are contained in html tags with class "contentblock". See http://wiki.koha-community.org/wiki/JQuery_Library for adding jQuery code to your Koha. HTH. Stefano > Hi All, > > Our aim is to enter formatted data into the notes field [500 a] such as > */<div style=""> information </div>/*. The aim is to give the > reader an easier experience whilst viewing our results page. However, Koha > is escaping all of the HTML characters that such as < and >. What can I do > to prevent koha from overriding those characters. > > Regards, > Sheldon

1 0

importing sql or csv
by Daniel 22 Oct '13

22 Oct '13

Hi, If i have a database stored as a .sql or .csv file, is it possible to convert them to marc format then import them? or is there another way around it? Thanks

2 1

custom page content not displayed
by Daniel 22 Oct '13

22 Oct '13

Hi, I am having trouble displaying custom page content in koha 3.12. I have followed detailed instructions (local use, new preference, etc) but when i test the new page, it instead displays only the header i had specified for the opac main page, not page content i entered. All help is appreciated. Thanks

1 0

Items not checked out report
by Amber Amland 22 Oct '13

22 Oct '13

I've been asked for a list of the top items not checked out from one of my library branches. When I try to run the report, it says NULL instead of giving me the titles although it does say there are items that haven't been checked out. Has anyone else had the same problem and solved it? We're using Koha version 3.06.00.000 on Linux 2.6.31.5-0.1, and I usually use the Google Chrome browser on my Windows computer to access it. Thank you very much! Amber

1 0

Re: [Koha] Account report
by Tony Morton 22 Oct '13

22 Oct '13

Hi all of you who are more koha report savvy, I use this report to send out our overdue account letters but would like to add in the earliest account date to enable me to send out monthly letters. Please help me. Accounts with more than Total number of rows matching the (unlimited) query is 162. SELECT p.cardnumber, p.surname, p.firstname, p.address, p.address2, p.city, p.state, p.phone, p.branchcode AS 'patron branch', p.debarred , p.debarredcomment, p.dateexpiry, format(sum(a.amountoutstanding),2) AS 'amount owed' FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) GROUP BY a.borrowernumber HAVING sum(a.amountoutstanding) > Tony Morton | Senior Librarian Waimate District Library Waimate District Council | 125 Queen Street | PO Box 122 | Waimate 7960 | New Zealand *: +64 3 689 0000 | DDI: +64 3 689 0071 | Ê: +64 3 689 8075 | Mobile: +64 0210740867 *: tony(a)waimatedc.govt.nz<mailto:tony@waimatedc.govt.nz> | ý www.waimatedc.govt.nz<http://www.waimatedc.govt.nz/> ______________________________________________________________________________ This email has been scrubbed for your protection by SMX. For more information visit http://smxemail.com ______________________________________________________________________________

1 0

Koha Escaping HTML characters
by sheldon_tappin 21 Oct '13

21 Oct '13

Hi All, Our aim is to enter formatted data into the notes field [500 a] such as */<div style=""> information </div>/*. The aim is to give the reader an easier experience whilst viewing our results page. However, Koha is escaping all of the HTML characters that such as < and >. What can I do to prevent koha from overriding those characters. Regards, Sheldon -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Escaping-HTML-characters-tp5775106.h… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Looking for some report help
by Nicole Engard 21 Oct '13

21 Oct '13

Hi all, I have this request for a report: "Can you develop a report that would provide: all the holds for <<a chosen owning library's>> titles (also showing the item barcodes) on which <<the same chosen library's>> patrons have holds but which titles are “in transit" to another library?" The hold is placed on the biblio level most of the time and and transfer on the item level - so this report will not be comprehensive because it will only find item specific holds. SELECT b.title, b.author, i.itemcallnumber, i.barcode, t.tobranch, COUNT(h.biblionumber) AS 'holds' FROM reserves h LEFT JOIN borrowers p using (borrowernumber) LEFT JOIN branchtransfers t USING (itemnumber) LEFT JOIN items i ON (t.itemnumber=i.itemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE i.homebranch = <<Item's branch|branches>> and p.branchcode=i.homebranch and p.branchcode != t.tobranch GROUP BY h.biblionumber HAVING COUNT(h.biblionumber) > 0 ORDER BY b.title ASC Is there a way to make it more comprehensive that I'm missing? Thanks Nicole

1 0

Fwd: Managing fines in a consortial environment
by Kivilahti Olli-Antti 21 Oct '13

21 Oct '13

Hello Mr. Vinton, and greetings from Finland! We are facing a similar issue and were planning to solve it with SQL reports. Each library just receives payments regardless of the origin of items. We can see which libraries received and how much money from the accountlines database table. You can target the item, the staff member who received the payment and the borrower. This should provide ample data to distribute the collected fines annually or bi-annually based on the SQL reports. I would also note that we are not yet in production and cannot verify this 100%. Olli-Antti Kivilahti Open library 2014 Joensuu Regional Library --Powered by Linuxmint On 21.10.2013 02:00, koha-request(a)lists.katipo.co.nz wrote: > From: Cab Vinton<bibliwho(a)gmail.com> > To: Koha list<koha(a)lists.katipo.co.nz> > Subject: [Koha] Fwd: Managing fines in a consortial environment > Message-ID: > <CABW43UTLOX-F9mYUPe_C_J-RV=-vH400JNy5A=qWHa065C624Q(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Oof. > > We're part of a 3-library Koha consortium and technically each library > is supposed to only deal with fines pertaining to its own items. > > But the Fines detail page is less than helpful when it comes to > figuring out to which library fines are owed. (Staff have to look at > each item individually.) > > Do other Koha consortia have best practices for dealing with fines > when dealing with multiple libraries (vs. branches of the same library > system)? What improvements would you suggest? > > It seems like this would be an area where consensus would be a good > thing to have before submitting bug reports, feature requests, etc. > > FWIW, the only related bug I've found is this one -- > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9975 > > Thanks, > > Cab Vinton, Director > Plaistow Public Library > Plaistow, NH > & Southern NH Library Cooperative

1 0