- Koha - lists.katipo.co.nz

Statistics for inter-branch activity
by Cab Vinton 10 May '14

10 May '14

Hi, All -- We're part of a 3-library coop where patrons have reciprocal borrowing privileges at any of the 3 libraries. Ideally, I'd like to be able to generate summary statistics on how patrons from each library are using these privileges, based on patrons' home library, the owner of items checked out, & where the transaction physically took place. I expected the following report to do this for me: SELECT s.datetime, i.itemcallnumber, i.itype, i.ccode, i.barcode, b.categorycode, s.type, b.cardnumber, s.branch, b.branchcode, i.homebranch FROM statistics s LEFT JOIN items i on (i.itemnumber = s.itemnumber) LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowernumber) WHERE s.type in ('issue','renew','localuse') AND s.datetime BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> ORDER BY i.itype, i.ccode, i.cn_sort asc Unfortunately, for 17% of the transactions the home library of the patron is missing (b.branchcode). In our case, this amounts to some 33,000 transactions for 2013. The vast majority of these transactions (98%) are of type Local Use. (We have the RecordLocalUseOnReturn preference set to 'Record' for when items not checked out are checked in.) Can anyone explain what's going on here? Does it have something to do with how Transfers between branches are recorded by Koha? Thanks for any insight you can offer. Best, Cab Vinton, Director Plaistow Public Library Plaistow, NH

1 0

***UNCHECKED*** Importing Patron Loan History
by Arup Raychaudhury 10 May '14

10 May '14

Will there be any problem if I import transaction history through offline circulation process? I have around 500000 transactions. -- Arup Raychaudhury ------------------------------------------------- Indian Statistical Institute 203 BT Road Kolkata 700108 Phone:0-33-2575-2106

1 0

Zebra server fails to start
by Lenora Oftedahl 09 May '14

09 May '14

Our external server is running, but Koha returns 0 results for all searches. We've got the LCK files owned & grouped as Koha. We've rebuilt the index. zebra-daemon and zebraqueue-daemon refuse to start. None of the error logs show anything. Any hints? Help? Lenora A. Oftedahl StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission http://www.fishlib.org

4 3

***UNCHECKED*** Question on EnhancedMessagingPreferences
by Hugo Agud 09 May '14

09 May '14

Dear all If we're not wrong the item_due and advance_notice are limited to patrons preference, but both notices are also quite interesting to be defined by the library by default. we wish to ask you If anybody knows a workarround or is working in this kind of feature? We can create the preference in MySQL and configure it for every borrower, but it is not elegant Thanks you in advance! -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* Director Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

1 0

***UNCHECKED*** Item types whose location close earlier than the main Library
by amutsikiwa＠uzlib.uz.ac.zw 09 May '14

09 May '14

Hi I welcomed the introduction of the hours unit in the circulation and fine rules configuration. I have been using a commercial library system that enables reserve books to be borrowed for internal use for two hours from 09:00 to 15:00 Monday to Thursday, after which they are borrowed for overnight use, which means the books become due the following morning before 09:00. However, the Library closes at midnight. On Friday, reserve books are borrowed for weekend use from 10:00 and become due on Monday. I am now almost through with my migration to Koha. However, I do not know how I can configure my reserve books loan rules so that they behave as explained.. May be the introduction of opening time and closing time for item types so that in the calculation of due dates, as with the calendar tool, will not fall due when that particular item type (for example reserve books) is deemed to be "closed" for circulation, could be the solution going into the future. This could be a future functionality request. However, in the meantime, I will appreciate any pointers on how I can configure the reserve books loan rules so that they behave as explained. Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe Tel:+263-4-303276 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp, 1880-1941, former director of the Bank of England

1 0

***UNCHECKED*** Display of Suggestion Status Tabs Disappear with Status Change
by Arun Kumar 09 May '14

09 May '14

Hello Lately we have been working on KOHA modules and understand various functions offered in KOHA. we found a problem in Suggestion management of Acquisition Module In the Default View of Suggestion management of Acquisition Module all the Status Tabs like Pending, Accepted, Checked, Ordered, Rejected and their respected Suggestions are displayed The real problem lies here i.e. when we select a suggestion from any of these Status Tabs and change their Status and submit. Once this action is committed only the Tab to which the Status is changed appears and the rest of the tabs Disappear and the URL changes to the following *cgi-bin/koha/suggestion/suggestion.pl#[Previous <http://suggestion.pl/#[Previous> Suggestion Status]* once this* "#[Previous Suggestion Status]"* is removed from the URL it redirects to the Default View of Suggestion Management My Question is that How do we directly redirect to the Default View in Suggestion Management with a changed Suggestion Status With all Tabs not being Disappeared Please Help us. Any pointers will be appreciated Regards ARUNKUMAR National Institute of Oceanography Dona-Paula, Goa, India

1 0

മലയാളം സർച്ച് റിസൽട്ട്
by shejith ennazhiyil 07 May '14

07 May '14

കോഹയിൽ മലയാളം സർച്ച് ചെയ്താൽ, സർച്ച് റിസൽട്ടായി എല്ലാ മലയാളം പുസ്തകങ്ങളും ഡിസ്പ്ലെ ചെയ്യുകയാണ് ചെയ്യുന്നത് ഇത് എങ്ങിനെ പരിഹരിക്കാം കഴിയും

1 0

What user account to use when re-indexing Zebra
by Joel Ewy 07 May '14

07 May '14

It's unclear to me what user account I'm supposed to be using to rebuild the Zebra index. I have an Ubuntu user called 'koha' that was inherited from 10.04, and when I created a new instance, another user 'bcmckoha14' was created. Am I supposed to be running the Zebra index rebuild as one of those users? I can 'su' to these accounts, but when I try to rebuild the index, it prompts me for a sudo password and then complains that those user accounts are not sudoers (which of course they shouldn't be.) So just how exactly is this supposed to be accomplished? Any insight would be much appreciated. JCE

3 4

***UNCHECKED*** To search titles like: What is not Sacred?: African Spirituality
by Zeno Tajoli 07 May '14

07 May '14

Hi to all, in bugzilla i find this query: From ict.admin(a)jhia.ac.ke > Greetings, >I have tried searching 'What is not Sacred?: African Spirituality by Magesa, Laurenti' >and it doesnt appear on the catalog until I searched the same using the authour. > > I have tried the searching 'What is not Sacred African Spirituality' on other libraries catlogs > around and realized that the system only finds the same book once you omit the "not" and search > for "What is Sacred African Spirituality". > > Our library Catlog is http://catalog.jhia.ac.ke/ I also run the search at this other catalogs > > http://library.hekima.ac.ke/ > http://library.jkuat.ac.ke/ > http://41.89.26.5/ > > And they all retured the same burg. the answer is in the default assumed by Koha on search. The default search in Koha is a keyword search and NOT/not is a reserved word in this search. So you need to do a seach by phrase and be explicity on the string. To do so you need to write in the search box: ti,phr="What is not: Sacred African Spirituality" Bye Zeno Tajoli -- Dr. Zeno Tajoli Dipartimento Gestione delle Informazioni e della Conoscenza z.tajoli(a)cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate

1 0

printing of callslips
by Jenice S. Tate 06 May '14

06 May '14

Does anyone do item-level holds? If so, how does it work with printing callslips? -- Jenice S. Tate, Systems Administrator MS Department of Archives & History Archives & Records Services Division - Computer Support Phone: (601) 576-6821 Fax: (601) 576-6824 Email:jtate@mdah.state.ms.us

2 1