- Koha - lists.katipo.co.nz

Re: [Koha] Fwd: INTRANET and OPAC does not retrieve titles with "?" "!"
by Michael Kuhn 26 Jan '22

26 Jan '22

Hi Victor You wrote: > I also checked several koha demo bases https://koha-community.org/demo/ > They also have the same problem. Thanks for the confirmation! 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 Am 26.01.22 um 18:13 schrieb Victor Barroso Oliveira: > I also checked several koha demo bases https://koha-community.org/demo/ > They also have the same problem. > > > > Em ter., 25 de jan. de 2022 às 06:50, Michael Kuhn <mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch>> escreveu: > > Hi > > I just tested this behaviour under Debian 11, Zebra and Koha > 21.11.01. I > confirm that a search including ? does not find results. For example > the > following search > > ˆDie‰ drei ??? und der unsichtbare Passagier > > translates to > > .../cgi-bin/koha/opac-search.pl?idx=&q=Die+drei+%3F%3F%3F+und+der+unsichtbare+Passagier+&weight_search=1 > <http://opac-search.pl?idx=&q=Die+drei+%3F%3F%3F+und+der+unsichtbare+Passagi…> > > and will not find any results. If you leave out the ? characters, Zebra > will find the respective hits. > > 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 > <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch> > > > > Am 24.01.22 um 08:41 schrieb Katrin Fischer: > > > > -------- Forwarded Message -------- > > Subject: Re: [Koha] INTRANET and OPAC does not retrieve > titles with "?" > > "!" > > Date: Sun, 23 Jan 2022 16:39:42 -0300 > > From: Victor Barroso Oliveira <vbovictor(a)gmail.com > <mailto:vbovictor@gmail.com>> > > To: Katrin Fischer <katrin.fischer.83(a)web.de > <mailto:katrin.fischer.83@web.de>> > > > > > > > > I'm using zebra. > > When I search without the score, it recovers! > > > > Em dom., 23 de jan. de 2022 12:28, Katrin Fischer > > <katrin.fischer.83(a)web.de <mailto:katrin.fischer.83@web.de>> > escreveu: > > > > Hi Victor, > > > > are you using Elasticsearch or Zebra? > > > > Does the search work if you leave out the punctuation? > > > > Katrin > > > > On 21.01.22 19:04, Victor Barroso Oliveira wrote: > > > Hi, > > > On Ubuntu 18 and Koha 21.05.08 and above > > > INTRANET and OPAC does not retrieve titles with "?" "!" > > > is this a bug? > > > > > > ERRO KOHA.jpg > > > > > > > > <https://drive.google.com/file/d/1jepUpqPw0oGva-oFr6AT7n3vIZsFDCOE/view?usp=… > <https://drive.google.com/file/d/1jepUpqPw0oGva-oFr6AT7n3vIZsFDCOE/view?usp=…>> > > > > > > _______________________________________________ > > > > > > Koha mailing list http://koha-community.org > <http://koha-community.org> > > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > > > Unsubscribe: > https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > <http://koha-community.org> > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > <http://koha-community.org> > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> > > > _______________________________________________ > > Koha mailing list http://koha-community.org <http://koha-community.org> > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> >

1 0

OPAC Preference
by Carlo Dumontet 25 Jan '22

25 Jan '22

Can someone please point me in the right direction . OPAC search: More Options At the moment it contains the following subtypes: "Any Audience" ; "Any Content" ; "Any Format" ; "Additional Content Types". Is it possible to limit the search to only ONE subtype? In my case I only need "Any Format". Many thanks for your help Carlo Dumontet Dr Williams's Library

2 1

Fwd: Software error
by anabela semedo 24 Jan '22

24 Jan '22

Can someone help me please, I can't do that alone. Thanks you Ana Bela Semedo Obter o Outlook para Android<https://aka.ms/ghei36> ________________________________ From: anabela semedo Sent: Monday, January 24, 2022 2:47:54 PM To: koha-bugs(a)lists.koha-community.org <koha-bugs(a)lists.koha-community.org> Subject: Software error Hi everyone, i have this problem, can someone help me? Can’t acess the koha. Software error: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 108 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.

1 0

Re: [Koha] How to measure and improve Koha performance for our
by dcook＠prosentient.com.au 24 Jan '22

24 Jan '22

Hi Mike, Great to see another Australian library using Koha! Regarding performance, I'd say the answer is "it depends". It looks like you're running Debian Buster (based on your Apache response), so I'm guessing you used the Debian packages to install Koha? I thought that new instances created this way used Plack out of the box, but I think I might be mistaken... If you enable Plack/Starman, page loads and search times will be faster, because the application code is run in persistent processes that use pre-loading and caching of code. However, that comes at a cost. In practice, I find each Plack/Starman process reserves about 200-500MB RAM over its lifetime (default 50 requests before it's recycled if I recall correctly), and the default Koha configuration uses 2 Plack/Starman processes. Depending on expected usage, you may want more/fewer Plack/Starman processes. (Note that those processes are shared across the Staff Interface and the OPAC.) Overall, enabling Plack is the best way to improve Koha performance. At some point in the future, we hope to get rid of CGI support for Koha, but that's a long story. (Note that static assets like Javascript, CSS, images, etc are still served by Apache when Plack/Starman is enabled as Apache is much more efficient at serving those files.) (Another thing to note is startup for Plack/Starman processes are CPU resource heavy as a lot of work goes into setting up and verifying the REST API.) I think Memcached might technically be optional, but you'll want to keep it for performance. Without it, performance would certainly degrade. Overall, I'd say the more CPUs the better, especially if you're running your database on the same server. In terms of metrics, you can use third-party log analyzers (for the Apache logs) and web analytics (eg Google Analytics) to get an overview of how the application is performing overall. For more targeted analysis, I tend to just use the Developer Tools in the browser. For instance, I see your OPAC is taking about 4 seconds to serve the homepage. I tried one of the instances I manage (on a high specced server using Plack) and it took 333ms. There are other tools you can use for profiling the application, but that's a something you might want to explore with the "koha-devel" list instead. More reading: https://lists.katipo.co.nz/public/koha/2020-December/055598.html I haven't used Linode so I can't really comment on its features, but other platforms like AWS make it very easy to switch between different CPU and RAM sizes. I'd say your first step is to enable Plack (on your test instance), and just manually compare similar web requests (like loading the home page, performing the same catalogue search). You should already have the RAM to handle it. I could see you getting into strife only having 1 CPU, as that 1 CPU would have a lot of work to do, but that's where the log analysis / web analytics can help you see real life usage. I hope that helps. Feel free to send more questions. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 -----Original Message----- Date: Fri, 14 Jan 2022 16:04:11 +1100 From: Mike Lake <mikel(a)speleonics.com.au> To: Koha <koha(a)lists.katipo.co.nz> Subject: [Koha] How to measure and improve Koha performance for our instance? Message-ID: <daad1c0c667cacb91cb604a2e7797a9c(a)speleonics.com.au> Content-Type: text/plain; charset=US-ASCII; format=flowed Hi all We have a production library setup at https://opac.caves.org.au and its now ready for users to use. We also have a test instance that can be used for testing. I'm wanting to know the options for measuring and improving the performance - just basic load and search time that users perceive. Currently we are running on a Linode instance with 1 CPU and 2 GB RAM. Yes it's a small library :-) Looking at Linode Longview it shows we have not hit more than 7% CPU usage and it usually sits at 1% CPU and 670 MB mem when idle. During a query cpu goes to 100% for a short period and mem to ~ 1 GB. I see in htop that several memcache threads are running. That's now installed automatically with Koha? The wiki seems to suggest that its optional. And there is plack mentioned in the wiki. Should we be running plack? I can double our Linode instance to 2 CPUs and 4 GB RAM but that's possibly an irreversible change (and double the $) so wish to leave that until I know it would make a significant difference. And how could I quantify that performance increase? Thanks -- Mike

3 3

Re: [Koha] CJK Coding and dollar1
by Charles Kelley 24 Jan '22

24 Jan '22

Hello, Katrin et al! In our latest exchange, on 20 Jan. 2022 at 8:01 [JST], I received this from you: can you explain a little more what you are trying to do? What is the > dollar syntax to be used for? > In response to my question on 20 Jan. 2022 at 5:48 [JST], to wit: Is the coding for CJK characters represented by “[dollar]1” or > “{dollar}1”? I can’t find documentationone way or the other, but I know it’s one of them > in Koha. > At least half of my library's collection consists of works in a non-Roman writing system. According to the MARC tag coding standards at both the Library of Congress and OCLC, non-Roman fields are supposed to be paired with Roman-transcribed fields. Here are two examples, one in Russian and the other in Japanese. 245 1 0 $6 880-45 $a Politika, ekonomika, pravo : $b russko-angliiskii slovar' : 40 000 slov i slovosochetanii = Politics, economics, law : Russian-English dictionary / $c S. I. Svetlanin. 880 1 0 $6 245-45/(N $a Политика, экономика, право : $b русско-английский словарь : 40 000 слов и словосочетаний = Politics, economics, law : Russian-English dictionary / $c С. И. Светланин. 245 1 0 $6 880-45$aNitchu sensou :$b senmetsusen kara shomosen e / $c Kobayashi Hideo. 880 1 0 $6 245-45/[dollar]1 $a 日中戦争：$b 殲滅戦から消耗戦へ / $c 小林秀夫. The MARC 880 standard specifies a $6 in the following format. $6 [linking tag]-[occurrence number]/[script identification code]/[field orientation code] The script identification code for the Cyrillic alphabet is "(N", but for CJK, it's "$1". Koha seems not to like "$1" in $6 because the dollar sign indicates a beginning of the next subfield. I read or heard that instead of "$1", "[dollar]1" is used, and that is what I use. I now see in our catalog some records with "{dollar}1". So, we have records with both "[dollar]1" but others with "{dollar}1". Now I'm confused. So, which one is it, "[dollar]1" or "{dollar}1"? I ask before I do a mass-update (through MarcEdit) and fix the wrong set, I'd like to know. I ask here because I have not been able to find documentation on either the Koha Community website or elsewhere online. So thanks to everyone for tis help. P.S. Sorry for the extra spaces about the subfields. It helps me with reading. P.P.S. The [field orientation code] seems not to be required but the [script identification code] is. -- よろしくお願いします。 -- 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

General question on borrower_debarments
by Bruns, Anke 23 Jan '22

23 Jan '22

Dear Koha list, we just stumbled upon the borrower_debarments sql table and are wondering how exactly this works and what can be done with it. However, we find no documentation either in the manual or "out there" on the internet. Do you know of any information on the debarment feature? I see that there are 4 debarment types (SUSPENSION', 'OVERDUES', 'MANUAL', 'DISCHARGE) which seem to be hardcoded in the db. MANUAL is of course the type of debarments set manually by library staff in the patron record. - But how can I find out the functioning of the other types - what exactly triggers debarments with type SUSPENSION', 'OVERDUES' or 'DISCHARGE? - What other actions are triggered or influenced by such a debarment other than the patron not being allowed to loan? - Can I configure this, and can I add more debarment types and determine how they function? Thanks for any enlightening hints, and best regards, Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns(a)gwdg.de --------------------------------------- Achtung! Neue Kontaktdaten! Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg(a)gwdg.de Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Norbert Lossau Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 --------------------------------------- Zertifiziert nach ISO 9001 ---------------------------------------

2 1

INTRANET and OPAC does not retrieve titles with "?" "!"
by Victor Barroso Oliveira 23 Jan '22

23 Jan '22

Hi, On Ubuntu 18 and Koha 21.05.08 and above INTRANET and OPAC does not retrieve titles with "?" "!" is this a bug? ERRO KOHA.jpg <https://drive.google.com/file/d/1jepUpqPw0oGva-oFr6AT7n3vIZsFDCOE/view?usp=…>

2 1

Recalls possible in KOHA
by Lisa Peel 20 Jan '22

20 Jan '22

Hello everyone Apologies, I know this has been asked several times but I was wondering if any development work has been done on this – we could really do with the functionality to be able to not only put a hold on a checked out item but to also automatically decrease the loan period and for a message/email to be sent to the current borrower to request the early return of the item. Does anyone know if this is possible? Thanks Lisa Ms Lisa Peel Head of Learning Resources, SEG Services Swiss Education Group Mobile: +41 (0)79 228 0151<tel://+41(0)792280151> Avenue des Alpes 62 CH-1820 Montreux, Switzerland www.swisseducation.com<https://www.swisseducation.com/en/> Facebook<https://www.facebook.com/swisseducationgroup> | Instagram<https://www.instagram.com/swisseducationgroup/> | Linkedin<https://www.linkedin.com/company/seg-swiss-education-group> Family, Friends and Partners Program<http://www.swisseducation.com/refer> In line with Swiss government advice, we have put in place a number of precautionary measures to mitigate Covid-19 risks to our schools. The health and safety of our students, staff and visitors remain our top priority. For more information click here<https://www.swisseducation.com/en/page/covid-19-faq-4568>

3 3

CJK Coding and dollar1
by Charles Kelley 20 Jan '22

20 Jan '22

Hi, all! Is the coding for CJK characters represented by “[dollar]1” or “{dollar}1”? I can’t find documentation one way or the other, but I know it’s one of them in Koha. Many thanks. Hope all are well and all is well. 気を付けて。 — 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 [USA cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com cmkelleymls(a)gmail.com www.linkedin.com/in/cmkelleymls Meeting Your Information Needs. Virtually.

2 1

The Terrific Every-Other-Thursday Training Video - Season 2 Episode 8 - jQuery & CSS: Tweaking the Reports Environment
by BRANNON, CHRISTOPHER 20 Jan '22

20 Jan '22

It just keeps getting better. Three tweaks in one video! Three tweaks to tame your reporting environment. Three tweaks to make your life better. (Well, at least to make your workflow better.) This week's video shows how to adjust your home Reports icon to go straight to your saved reports, how to clean up reports printing, and how to improve the tabs loading. We could add more, but we don't want to overwhelm you with so much good stuff. https://youtu.be/e7FTN1hAhKA Christopher Brannon

1 0