- Koha - lists.katipo.co.nz

Time to translate: string freeze to prepare Koha 22.05.00 has begun
by Fridolin SOMERS 13 May '22

13 May '22

Hi everyone 🤗 Koha 22.05 is now in string freeze until the first release around the 25th 🚀 Time to translate 🌎🌍🌏 https://translate.koha-community.org/projects/22.05/ Best regards 🌊 -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0

Report help needed
by Elaine Bradtke 12 May '22

12 May '22

Forwarding this to the list. Joel's suggestion fixed the problems. Elaine VWML <https://vwml.org> ---------- Forwarded message --------- From: Coehoorn, Joel <jcoehoorn(a)york.edu> Date: Tue, May 10, 2022 at 11:20 AM Subject: Re: [Koha] Report help needed To: Elaine Bradtke <eb(a)efdss.org> It could just be my email client, but I see line endings in the wrong place. It works on my system (in that at least I see data) if I don't change any code other than fixing formatting and line endings: SELECT authid, datecreated, authtypecode, concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), -- PERSO_NAME ExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), -- CORPO_NAME ExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), -- MEETI_NAME ExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), -- UNIF_TITLE ExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), -- CHRON_TERM ExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), -- TOPIC_TERM ExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), -- GEOGR_NAME ExtractValue(`marcxml`,'//datafield[@tag="155"]/*') -- GENRE/FORM ) main_heading FROM `auth_header` WHERE datecreated BETWEEN <<(from yyyy-mm-dd)>> AND <<(to yyyy-mm-dd)>> ORDER BY datecreated, authtypecode, main_heading Note that MySql is picky about double-dash (--) comments, and requires whitespace after the comment characters. Joel Coehoorn Director of Information Technology York College of Nebraska On Tue, May 10, 2022 at 12:42 PM Elaine Bradtke <eb(a)efdss.org> wrote: > I imported the following report from Mana, but it doesn't work as is. I > tried changing `marcxml` to `metadata` but it still didn't work. The error > message (You have an error in your SQL syntax; check the manual that > corresponds to your MariaDB server version for the right syntax to use near > '' at line 1) isn't specific enough for my limited abilities. I'd be > grateful for your help. > > Here's the original: > SELECT authid, datecreated, authtypecode, > concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), -- > PERSO_NAMEExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), -- > CORPO_NAMEExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), -- > MEETI_NAMEExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), -- > UNIF_TITLEExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), -- > CHRON_TERMExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), -- > TOPIC_TERMExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), -- > GEOGR_NAMEExtractValue(`marcxml`,'//datafield[@tag="155"]/*') -- > GENRE/FORM) main_headingFROM `auth_header`WHERE datecreated BETWEEN <<(from > yyyy-mm-dd)>> AND <<(to yyyy-mm-dd)>>ORDER BY datecreated, authtypecode, > main_heading > > Elaine Bradtke > VWML <https://www.vwml.org> > English Folk Dance and Song Society <https://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 > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

New Terrific Every Other Thursday Video
by George Williams 12 May '22

12 May '22

Greetings fellow Koha users, It's another every other Thursday so there's a new koha-US training video at: https://youtu.be/2Rt8csZoF0A This week we're talking about improving the circulation rules interface. This is part 1 of an update from a talk that I did at the koha-US conference in 2017. George

1 0

Europeana Data MOdel
by Hugo Agud Andreu 12 May '22

12 May '22

Good morning Europeana is an european repository that has a big influence in local repositories, as koha is oai-pmh enabled, but is not ESE or EDM metadata compliance, and I am pretty sure it should be something interesing for at least european koha users. We have few idea about EDM or ESE Metadata, and i I wish to ask if anybody has experience on Europeana Data Model, in order to study the feasibility of adding this new metadata model into koha thanks a lot in advance Hugo Agud - Orex Digital www.orex.es<http://www.orex.es> - Linkedin<https://www.linkedin.com/company/orex-digital/> Innovando para ayudar a las bibliotecas a alcanzar el siguiente nivel <https://orex.es/productos/orex-analytics/> Director Passeig Comte Vilardaga, 118 3-3 08980 -Sant Feliu de Llobregat - Tel: 933 856 138 hagud(a)orex.es<mailto:hagud@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 y sus archivos adjuntos van dirigidos exclusivamente a su destinatario, pudiendo contener información confidencial sometida a secreto profesional. No está permitida su reproducción o distribución sin la autorización expresa de Orex Digital, S.L. Si usted no es el destinatario final por favor elimínelo e infórmenos por esta vía. En cumplimiento de lo establecido en el Reglamento General de Protección de Datos (RGPD) (UE) 2016/679 y a la Ley Orgánica 3/2018, de 5 de diciembre, de Protección de Datos de Carácter Personal y Garantía de los Derechos Digitales (LOPD-GDD), le informamos que tratamos sus datos personales con la finalidad de responder a su solicitud de información, realizar la gestión administrativa derivada de nuestra relación comercial o contractual, así como enviarle comunicaciones comerciales sobre nuestros productos y servicios. La legitimación será en base a un interés legítimo, por ejecución de un contrato y/o por consentimiento, en algunos casos. Los datos proporcionados se conservarán mientras se mantenga la relación contractual o durante los años necesarios para cumplir con las obligaciones legales. Los datos no se cederán a terceros salvo en los casos en que exista una obligación legal o sea necesario para la ejecución de un contrato. No se tomarán decisiones automatizadas que puedan causar un efecto jurídico significativo, salvo que se haya recabado previamente el consentimiento. Asimismo, le informamos de la posibilidad de ejercer los siguientes derechos sobre sus datos personales: derecho de acceso, rectificación, supresión u olvido, limitación, oposición, portabilidad y a retirar el consentimiento prestado. Para ello podrá enviar un email a: info(a)orex.es, adjuntando copia de su DNI. Además, el interesado puede dirigirse a la Autoridad de Control en materia de Protección de Datos competente (AEPD, en España) para obtener información adicional o presentar una reclamación. Datos identificativos: Orex Digital, S.L., B64500945, Paseo Conde de Vilardaga 118, 3-3 - 08980 - Sant Feliu de Llobregat - BARCELONA, 933856138

2 2

Subject headings in two languages
by Michael Kuhn 11 May '22

11 May '22

Hi We are using Koha 19.05.02 on Debian GNU/Linux 9. In many ways Koha supports the use of multiple languages - this does not seem to be the case concerning authority records We would like to add subject headings in two languages (German and English) to our bibliographic records. Thus we'd like to ask for best practices how to manage subject headings in two languages: 1. How to create them, how to edit them, how to link the German subject heading to the English one and vice versa? 2. How to display subject headings in two languages in the OPAC? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 1

Advanced editor page keeps loading
by Michael Kuhn 11 May '22

11 May '22

Hi We are using Koha 18.11.03 with Debian GNU/Linux 9. When trying to edit a bibliographic record using the advanced editor sometimes only part of the page appears, saying "Loading, please wait.." - but loading never comes to an end. See the screenshot at http://adminkuhn.ch/download/AdvancedEditor.JPG - Though editing the record in the basic editor is working. It does not help reloading the page, or logging out and logging in again, also we couldn't find an obvious mistake in the bibliographic record. Does anyone know the solution to this problem? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

1 0

files added to users/borrowers
by Biblioteca FIUNER 10 May '22

10 May '22

Good afternoon. I finish my query about files added to users/borrowers. If the users photos/images are stored in the database in the users images table and the users files should be stored in the borrower files table, the query is how can one get a copy of both folders/ information. Thanks since now Lic. Brenda Ramirez Head of Depth "Dr. Eduardo A. Barbagelata" Library http://biblioteca-fing.uner.edu.ar/ (24/7 disponible) correo: biblioteca.ingenieria(a)uner.edu.ar Atención al público de lunes a viernes de 8 a 18 hs.

1 0

koha-US General Meeting reminder: Wednesday, May 11, 2022
by Jennifer Marlatt 10 May '22

10 May '22

The next koha-US general meeting is *tomorrow, *Wednesday, May 11th, 2022. When: 8:30a PT / 11:30a ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+March+Gen…> ) Where: https://us02web.zoom.us/j/648572897?pwd=TUpsRE1TYlFPWWxTWFl4TVovSTJ3Zz09 Agenda: https://docs.google.com/document/d/1R3cbx-XGVZohFzG7xz5H-eJy-Qdkzk3h8LElxQ7… If you have additional topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are always free and open to any and all. Jennifer Marlatt koha-US secretary secretary(a)koha-us.org

1 0

Report help needed
by Elaine Bradtke 10 May '22

10 May '22

I imported the following report from Mana, but it doesn't work as is. I tried changing `marcxml` to `metadata` but it still didn't work. The error message (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1) isn't specific enough for my limited abilities. I'd be grateful for your help. Here's the original: SELECT authid, datecreated, authtypecode, concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), -- PERSO_NAMEExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), -- CORPO_NAMEExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), -- MEETI_NAMEExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), -- UNIF_TITLEExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), -- CHRON_TERMExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), -- TOPIC_TERMExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), -- GEOGR_NAMEExtractValue(`marcxml`,'//datafield[@tag="155"]/*') -- GENRE/FORM) main_headingFROM `auth_header`WHERE datecreated BETWEEN <<(from yyyy-mm-dd)>> AND <<(to yyyy-mm-dd)>>ORDER BY datecreated, authtypecode, main_heading Elaine Bradtke VWML <https://www.vwml.org> English Folk Dance and Song Society <https://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

2 1

Re: [Koha] Koha Digest, Vol 199, Issue 4
by Charles Kelley 10 May '22

10 May '22

Good morning, all! No, not quite. The mistake is understandable. I struggled how to explain it myself and had to settle on this convolution. I used to be systems librarian for Innovative Interfaces' InnoPAC (III) and later Sierra ILS. III required that check-in boxes for serials be set up before the issues be checked in. Since this was a tedious task, III eventually amended the ILS to let us set up multiple check-in boxes (called extrapolation) in one sitting. Once the boxes were set up, we could check in multiple boxes in one sitting. I've been looking for an analogous operation in Koha, but I have been unable to see one. The multi-receive allows for checking in, marking late, etc. multiple check-in boxes in one sitting, but it does not for setting up the check-in boxes initially before the issues are checked in. Unless there is something I don't know. Does anyone have an idea? In my original exchange, on 6 May 2022 at 13:24 [JST], I wrote: Can a library set up more than one check-in box at a time? I am retroactively > creating the serials module to my library's serial subscriptions. Must I > enter the issues one at a time? Or can I enter a group of check-in boxes > based on the prediction? > In our latest exchange, on 6 May 2022 at 14:02 [JST], Owen Leonard wrote: I think what you're talking about is called "Multi receiving" in Koha. From > the details of your subscription you would go to "Receive," then > "Multi-receiving." > Many thanks. -- よろしくお願いします。 -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

2 2