- Koha - lists.katipo.co.nz

Deleting patrons
by Cab Vinton 31 Mar '11

31 Mar '11

Are there any issues related to deleting patrons that one should be aware of? I'm thinking particular of the "usual" circulation and & statistical reports that libraries run for annual reports, etc. Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH

1 0

Re: [Koha] bulk import of authorised values?
by Paul 31 Mar '11

31 Mar '11

At 10:41 PM 3/30/2011 -0400, Chris Nighswonger wrote: >[snip] Before I start adding more "Authorized values" to a near-production >Koha >db, > > >I'll let others answer the other questions, however, I trust that before >you add, subtract, do-any-sort-of-foo to your near-production DB, you make >a quick backup of it using mysqldump.... Then you can try all sorts of >things w/out worry. > >Better yet, setup a cron job to run a dump at regular intervals so you can >"roll back" if need be. Thanks Chris - all covered. Formal total backup (rdiff) every 01.00 a.m., partial set for every hour, dump manually as required ... Paul Tired old sys-admin

1 0

Purchase Suggestions
by Madhura Deodhar IES Library 31 Mar '11

31 Mar '11

Dear Koha USers, I could make purchase suggestions as the message displays: Software error: Can't use an undefined value as a HASH reference at /usr/share/koha/intranet/cgi-bin/suggestion/suggestion.pl line 175. For help, please send mail to the webmaster (webmaster@madhura-desktop), giving this error message and the time and date of the error. What should i do? *Regards,* ** *Madhura M.Deodhar* *Librarian *IES Management College and Research Centre VMD Lotlikar Vidya Sankul Opp.Lilavati Hospital, Bandra Reclamation Bandra (West) Mumbai - 50 61378327(direct) 9869385665/9167004647 http://iesmglib.blogspot.com *P **Please consider the environment before printing this e-mail.* * *

1 0

Log Viewer for Fines
by Akin Adigun (Akinomatics) 31 Mar '11

31 Mar '11

Hello, Can anyone help me, My koha is not displaying the patron that Cancel, writeoff or pay a fine. Anyone with an SQL statement to retrieve a cleint patron that Cancel, writeoff or pay a fine. thanks

1 0

Re: [Koha] bulk import of authorised values?
by Paul 31 Mar '11

31 Mar '11

At 12:38 PM 11/26/2010 -0500, Jared Camins-Esakov wrote: >Is there a way to do a bulk import of "authorized values"? Â I have not been >able to find KOHA user interface support for this. > >INSERT INTO authorised_values (category, authorised_value, lib) VALUES >('LOC', 'MILITARY', 'Military'), ('LOC', 'ANOTHER', 'Another location...'); Before I start adding more "Authorized values" to a near-production Koha db, a couple of questions: a) The suggestion is ('LOC', 'ANOTHER', 'Another location...'), but should this not be ('LOC', 'ANOTHER', 'ANOTHER', 'Another location...') i.e a third data field, in order to populate the OPAC display? b) The default sort order for Auth values appears to be alphabetical, despite the indexing in SQL. Does anyone know of a way to retain the bulk import order / SQL indexing? (e.g most common to least common.) c) If these are made "Mandatory" in a specific framework mapping from now on, I assume that previous non-compliant entries will not be wiped out. Am I correct? d) Staff (who, with some of our volunteers, gave the system a test-drive yesterday) really want to use this as a "drop down choice" menu, and have come up with a lengthy list that will cover most cases. The manual says that if it's "Mandatory" you cannot leave a blank line to type in the occasional exception. Is there a way around this? Can it even be edited "outside" auth values after data entry. Assuming I'm correct in b) above, can they even be edited manually - say in a different framework that does not define them as "Mandatory"? For background, this is for book condition, as in "vg/vg", "fair/none" or "fine half calf". But there will be the occasional "vellum" or "slipcased" - and the list of common combinations is already approaching the hundred mark. Thanks, Paul Tired old sys-admin

2 1

Text on issue reciepts
by Sue McMillan 30 Mar '11

30 Mar '11

Good morning, STDC libraries print receipts for items issued. The font size is very small and we would like to change to larger print. I can't see in the admin where to change it so am thinking it is a style sheet somewhere on the server. Can anyone point me in the right direction? Regards Susan McMillan Acquisitions and Systems Librarian South Taranaki District Libraries 06 278 0555 or freecall 0800 111 323 ext 8706 ,sue.mcmillan(a)stdc.govt.nz http//:www.southtaranaki.com This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorised and may be illegal. Please note that this communication does not designate an information system for the purposes of the Electronic Transactions Act 2002. <p><b>CAN'T OPEN ATTACHMENTS?</b></p> The Council has upgraded to Microsoft office 2007 suite. This may mean you cannot open attachments if you have older versions of office. <a href="http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE…"> Click here to access Microsoft Office 2007's compatibility website.<a/>

3 3

overdues with fines
by Nicole Engard 30 Mar '11

30 Mar '11

I've asked before - but got no answer. Anyone know what this report is for? Overdues with Fines? It's a blank section in the manual: http://koha-community.org/documentation/3-4-manual-en/?ch=x8286#overduesfin… Nicole

1 0

'Translating' images
by Stefano Bargioni 30 Mar '11

30 Mar '11

In some cases, images need to be changed depending on the language. An example: the cart has a cart icon, of course, but the Italian translation uses 'scaffale', and the Spanish translation uses 'bolsa', that are not carts. So the icon needs to be 'translated' accordingly. Here is a proposal to do this (case it-IT). Add an icon named scaffale.png into the opac-tmpl/prog/images directory and the following code to the opacuserjs syspref: $(document).ready(function() { var lang = readCookie('KohaOpacLanguage'); if (lang=='it-IT') { $('#cartmenulink img').attr('src','/opac-tmpl/prog/images/scaffale.png'); $('a.addtocart').css('background-image','url(/opac-tmpl/prog/images/scaffale.png)'); } }); Cart icons will be changed on page load. Bye. Stefano

1 0

new versions
by Shelley & Kurt Kemperman 30 Mar '11

30 Mar '11

Trying these questions again... We currently have version 3.0.0 and want to update to 3.2.6 this week. We are having the IT consultant that originally installed Koha this winter do this. Any potential glitches or problems that I should be aware of? Will I have to reset anything in the new version? Hoping the transition goes smoothly. Also, would it be better to wait for version 3.4 in April? How different will this one be? We don't have full-time or even regular IT help - have to hire/pay for each service, so we want to use our money wisely. Thanks, Shelley

2 2

build_browser_and_cloud cronjob
by Abdulsalam Yousef 30 Mar '11

30 Mar '11

Hi all, i was trying to import authority records from marc records that already loaded in my database which will make a catalog for example of my authors when browsing by subject in opac then selecting the type as person_name by this command ./bin/cronjobs/build_browser_and_cloud.pl -f -b 100a -t 100 -c i'm sure that i used this before and it gets the desired results but now it doesn't get when using this command only it fills the tags table not the auth_header one. we are using koha 3.2.4 and another updated one to 3.2.5 thanks alot

1 0