- Koha - lists.katipo.co.nz

Re: [Koha] Koha Not calculating and charging overdue fines
by muirunyeri 28 Aug '19

28 Aug '19

Hi, While Koha is now calculating fines, its only possible to see the fine after item checkin. Its only showing a user as having overdue items but no amount of fine accrued before checkin. What can be done to show on the screen the amount accrued even while the item is still checked out? Best Regards Sent from my Samsung Galaxy smartphone.-------- Original message --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 16/08/2019 14:12 (GMT+03:00) To: Alvaro Cornejo <cornejo.alvaro(a)gmail.com>, koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi, Thanks Alvaro. The code worked and now overdue is calculating Best regards Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Alvaro Cornejo <cornejo.alvaro(a)gmail.com> Date: 15/08/2019 16:42 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com> Cc: Carlos Lopez <clopez(a)dml.vic.edu.au>, koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi Muirunyeri You can access mysql and run a command like: UPDATE `items` SET `homebranch` = `YourHomeBranchID' [WHERE homebranch is NULL];As you will be editing your database directly, you should backup your system before. Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le jeu. 15 août 2019 à 01:54, muirunyeri <muirunyeri(a)gmail.com> a écrit : Hi Carlos, I ran the report which returns a single column with item numbers. It indeed confirms all items are without home branch. However, no batch editing option. Any assistance to solve this is highly appreciated. Thanks Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Carlos Lopez <clopez(a)dml.vic.edu.au> Date: 15/08/2019 02:02 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com>, koha(a)lists.katipo.co.nz Subject: RE: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines Hi Muirunyeri If the homebranch field is empty, you could run a report from this query: SELECT itemnumber FROM items WHERE homebranch is NULL You should even get a little "Batch modify" button at the top of your results. With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | library.dmlibrary.org.au -----Original Message----- From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of muirunyeri Sent: Thursday, 15 August 2019 5:56 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines Sent from my Samsung Galaxy smartphone.-------- Original message --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 14/08/2019 22:54 (GMT+03:00) To: katrin.fischer.83(a)web.de Subject: Re: Re: [Koha] Koha Not calculating and charging overdue fines Hi, I have around 44,000 items that were imported from excel. The homebranch field is blank and this might be the cause if the non-calculating overdue fines. How can i edit items to fill this field (batch)? The homebranch field is not available on the items form. If its hidden, how can I unhide it? You could also give me an SQL code if it'll get the Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 06/08/2019 19:14 (GMT+03:00) To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi all, I think what Caroline described would work well for a dev (git) or standard (tarball) installation, while things with the packages work a little differently like Michael describes. So it might depend on your installation type on what you should do. For package installations the fines.pl should be scheduled by default to run daily. Have you checked everything else that might prevent fines from calculating? - finesmode systempreference? - Holidays in the calendar? - Circulation rules correct? For example sometimes it's easy to miss that rules for 'all libraries' might have been overwritten by branch specific ones. Hope this helps, Katrin On 06.08.19 17:07, Michael Kuhn wrote: > Hi > > >> I think this' where my solution lies however the cron -l command > >> replies no cron command for my user account. I have 2 accounts > >> showing i.e. the admin account and the koha_instance account. > >> > >> I hope i was supposed to run it thru the main account coz thats where > >> I log in. > >> > >> Or what might I be doing wrong? I believe the cron list should have > >> something. Please advise. > > I'm not sure if this is of any help, but in the Koha 19.05 standard > the script "fines.pl" is executed in file > "/etc/cron.daily/koha-common" as follows: > > koha-foreach --chdir --enabled /usr/share/koha/bin/cronjobs/fines.pl > > Thus not in any user controlled crontab. Also the path is not > "misc/cronjobs/fines.pl". > > Best wishes: Michael _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- Click here to report this message as spam: https://console.mailguard.com.au/ras/1WjDFG6Rrm/6w1jxU3YIDrNJIQQ56V7oe/0.4 _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Koha upgrade from 3.20.00.000 (2015) to any latest and stable version
by Sultan Qaboos Cultural Center Library 27 Aug '19

27 Aug '19

Hello, Our library is planning to upgrade Koha from the version 3.20.00.000 to any Koha latest and stable version. - What Koha version do you recommend us ? - Could you please give us a complete tutorial, system requirements, and the things we have to do (backup ?, etc,) before starting the upgrade ? - Is it possible to upgrade directly from 3.20 (2015) to the latest version ? or we have to upgrade to lower versions before? Given that almost all Koha modules are up-to-date. Best regards, Walid -- *Sultan Qaboos Cultural Center Library* 1100 16th St, NW Washington, DC 20036 library(a)sqcc.org 202-677-3967, x104

4 4

Looking for a Systems Librarian
by Matías Millassón 27 Aug '19

27 Aug '19

Hi! We are currently looking for a Systems Librarian in the Buenos Aires, Argentina, area. this is to implement and configure Koha in our Library, already installed but not yet in production. Job proposal is in spanish, because the job will be in spanish too :) Muchas gracias! ----- Mensaje reenviado ----- De: "Ana Sanllorenti" <asanllorenti(a)bl.fcen.uba.ar> Nuestro biblioinformático actualmente a cargo del proceso de migración de Isis a Koha, se va en octubre a trabajar a un organismo internacional en Europa. Buscamos un biblioinformático para cubrir las siguientes _funciones:_ * Implementación y configuración del Sistema Integrado de Gestión Bibliotecaria Koha (actualmente en proceso). Implementación de Política de préstamos, configuración de frameworks, configuración de visualización de registros, etc. * Administración de bases de metadatos bibliográficos y vinculados con la gestión de la información documental * Administración de los procesos de importación y exportación de datos de la Biblioteca. El proceso de migración de las bases ISIS en formato Bibun (bibliográficas y de existencias) está en sus últimas fases. Sin embargo, sería recomendable estar en condiciones de chequear y eventualmente modificar esa migración. * Soporte técnico de las aplicaciones y las bases de datos de los procesos y servicios bibliotecarios La persona que buscamos deberá interactuar con todos los sectores involucrados (Sistemas, Préstamo, Catalogación, Referencia, Hemeroteca, Biblioteca Digital) Las actividades se desarrollan con soporte de personal del área informática de la Biblioteca (estudiantes de la Licenciatura en Ciencias de la Computación de la Facultad) _Requisitos para cubrir el cargo:_ * Bibliotecario o estudiante avanzado de bibliotecología con especialidad y experiencia en aplicación de tecnología en las bibliotecas ó informático con conocimiento / experiencia de las necesidades bibliotecarias: actividades de una biblioteca, formato MARC, reglas de catalogación, sistemas de préstamo, etc. * Conocimiento/experiencia en administración de KOHA, * Conocimientos de formato MARC21 para importación/exportación de datos documentales _Serán bienvenidas personas que tengan:_ * Manejo de Sistemas Operativos Linux y Windows. Scripting BASH (idealmente, poder hacer scripting; preferentemente poder interpretarlos) * Manejo de HTML, XML, CSS y PHP * SQL * Conocimientos de bases ISIS * Greenstone, particularmente manejo de metadata.xml Lo que ofrecemos es un contrato por un año equiparado a una categoría 5 del escalafón no docente de las universidades nacionales. Implica cobertura previsional, obra social, aguinaldo, vacaciones. Es a partir del 1 de octubre de 2019. Al cabo de un año sabremos si nuestro actual biblioinfomático se reintegra o no, y se abren entonces posibilidades de un concurso para personal de planta. Los interesades, por favor, contactarse con Ana Sanllorenti asanllorenti(a)bl.fcen.uba.ar

1 0

Problem uploading patrons
by Elaine Bradtke 27 Aug '19

27 Aug '19

We're running 3.18.04. One (and only one) of my colleagues is unable to upload patron files. It's very curious, she has all the permissions, and I and another colleague have uploaded the same file without a problem. I have even logged into her account and uploaded the file successfully. But whenever she tries she gets a long string of error messages that boil down to Koha not parsing the header row. I've asked her to clear her browser (Firefox) history and cookies (there's an 8 hour time difference so I won't know if this works til tomorrow) Other than that I don't know why she can't do it and we can. Any ideas what might be causing the problem? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

9 14

Multiple problems in MARC download and import
by Elaine Bradtke 27 Aug '19

27 Aug '19

We're using Koha 19.05.02 I have a txt file of biblio numbers that need to all have the contents of one field changed. 477 numbers (no dupes, I checked). I then went through the process of exporting these records. When I open the file in MarcEdit, it says I have 225 records. I don't know what happened to the other 252. I decided to go through the rest of the process, just to see if it worked as expected (this is why we have a test site). I edited the file, saved it as mrc and tried to import it to Koha. Where I got a very large error message saying nothing imported SOFTWARE ERROR, contact your webmaster. Unfortunately, the tech half of the team is away at the moment. . . so any help would be appreciated. I'm especially curious as to why I uploaded a list of 477 biblio numbers but I got only 225 records in return. I'm now going to experiment with batch editing within Koha. . . wish me luck! Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

4 6

SC Status before sip2 login
by Karam Qubsi 26 Aug '19

26 Aug '19

Hello Koha Community, I'm working with a selfcheck machine that is sending the sc status request (99) before the login request (93) . and that is causing koha sip server to close the connection. >From official documentation of SIP * , it look like that this status message can be sent before initialising SIP login, so I'm not sure if there is an option to allow this request or even allow login without username/password as we are going to secure the connection using ssh anyway. Any ideas or tips would be highly appreciated, Thank you very much Karam . * http://multimedia.3m.com/mws/media/355361O/sip2-protocol.pdf (page 6 ) : > SC Status > The SC status message sends SC status to the ACS. It requires an ACS > Status Response message reply from the ACS. This message will be the first > message sent by the SC to the ACS once a connection has been established > (exception: the Login Message may be sent first to login to an ACS server > program). The ACS will respond with a message that establishes some of the > rules to be followed by the SC and establishes some parameters needed for > further communication. -- *Karam Qubsi*

1 0

KOHA AND ERP INTEGRATION.
by Raymond Okumu 23 Aug '19

23 Aug '19

Dear Team, We would like to integrated Koha with a microsoft EPR to enable patrons created in students management system to automatically be registered in Koha and fines charged in koha to be automatically sent to finance management system for billing purposes. Anyone who has ever done this? How can we do it? Your help will be highly appreciated. Regards, Raymond.

2 1

Koha/Zebra record lengths
by Paul A 23 Aug '19

23 Aug '19

We've lost a record (opac and staff) biblio + 422 items. It's there in all its glory in MySQL, but Zebra won't show it. The Koha wiki mentions: "Record length of 101459 is larger than the MARC spec allows (99999 bytes) -- This will show up if you are trying to index a record that has a large number of items (common with serials, for example), or just has a lot of text in the record itself. /.../ Koha can do the indexing by using the MARCXML format rather than ISO 2709, and this gets around the problem. If you add '-x' to the reindex_zebra.pl command when indexing biblios, it will do this" We always have used '-x' for biblios (did it again a couple of minutes ago.) No joy I can (I hope!) just delete the last item (or two or three) from MySQL and reindex, but before I go there, does anyone have previous experience with this problem? Many thanks --Paul

4 5

Error when adding new authorities record
by ksorbo 22 Aug '19

22 Aug '19

Using Koha 17.11, Ubuntu 16 I am getting an error when I attempt to add a new authorities record: 1. On the biblio cataloging page, click the button next to 650 a tag to add a topical subject tracing 2. Pops up search for authority, nothing found 3. Click create authority 4. On authorities record, fixed length 001 003 005 008, autopopulate 5. Enter new term in 450 a - Click save. 6. It asks if this is a duplicate (the term shown in the duplicate message is completely different than the one being added) 7. Click No Save as New Authority Error: *Can't call method "subfields" on an undefined value at /usr/share/koha/intranet/cgi-bin/authorities/blinddetail-biblio-search.pl line 86.* Am I getting this error because I am failing to enter something I should be entering in the new authorities record? -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 2

Relevance in Results Display
by Jerome Trinidad 20 Aug '19

20 Aug '19

Hi Koha Community, Is it just in our Koha or is something really off with Relevance Sorting of Koha? In the attached images, the search keywords in the default search are "triumph of moro" and common logic would say that the material with the title "Triumph of Moro diplomacy..." should be the number 1 result but instead it ranked only 3rd in both staff and opac interface with the first 2 results not containing any of the keywords in their title or author. Is there anyway I or we can improve this? We're using: - Koha 17.05.03 - Zebra 2.0.59 - Staff/OPAC SortField: Relevance - Staff/OPAC SortOrder: Ascending and/or Descending (makes no difference in our case?) Thank you and hope to hear from the community. Regards, Jerome Attachment: Image 1: https://i.imgur.com/PDS1bhB.png Image 2: https://i.imgur.com/MZXBOcr.png

2 2