- Koha - lists.katipo.co.nz

sql query
by Yatheesh lis 10 Nov '20

10 Nov '20

Hi I would like to add the following fields to sql query after OnlineURL koha 19.05 1. 8 - Collection code 2.c - Shelving location SELECT items.Barcode,biblio.Author,biblio.Title AS Titles,biblioitems.Pages,biblioitems.Editionstatement AS Edition,biblio.Copyrightdate AS Year,items.Price,biblioitems.publishercode AS Publisher,biblioitems.Place,biblio.unititle AS Subject,items.location AS Department,biblioitems.itemtype AS Department,items.itype AS Status,biblioitems.url AS OnlineURL,items.Dateaccessioned,biblioitems.ISBN,biblio.notes,biblio.Serial,items.Issues,items.Renewals FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) ORDER BY LPAD(items.barcode,40,' ') ASC please help me -- Y.Yatheesh Babu 8247838231

2 1

2. virtuelles Koha-D-A-CH-Anwendertreffen am 25.11.2020 [German]
by Fischer, Katrin 10 Nov '20

10 Nov '20

+++ This announcement addresses German-speaking Koha users as the user meeting will be held in German language +++ Liebe Koha-Anwender*Innen und Koha-Interessierte, wir laden herzlich zum zweiten virtuellen Koha-Anwendertreffen am 25.11.2020, 10:00 - 12:00 Uhr und 14:00 - 15:45 Uhr ein. Das Anwendertreffen wird mit Hilfe von GoToMeeting stattfinden: https://www.gotomeet.me/l-team2/koha-d-a-ch-anwendertreffen Sie können sich auch über ein Telefon einwählen: +49 892 0194 301 Zugangscode: 928-890-981 Der Konferenzraum ist vormittags ab 9:45 Uhr und nachmittags ab 13:45 Uhr offen. Die Veranstaltung beginnt um Punkt 10:00 Uhr bzw. 14:00 Uhr. Programm: Vormittag: 10:00 12:00 Uhr 1. Odyssee nach Koha (Maximilian Losinschek, Patrick Novak und Konrad Lanz, Steirische Landesbibliothek) 2. Datenmigration nach Koha (Lea Satzinger, Thüringer Universitäts- und Landesbibliothek) 3. Laden von Benutzerdaten in Koha (Uwe Böttcher, WHU Otto Beisheim School of Management) 4. Katalogisierung mit MARC21 (Ewa Gozd, Stadtbibliothek Heilbronn) 5. Neuerungen in Koha 20.11 (Katrin Fischer, Bibliotheksservice-Zentrum BW) Nachmittag: 14:00 15:45 Uhr 1. BibToGo Der digitale Bibliotheksausweis des Goethe-Instituts (Nico Sandfuchs, Goethe-Institut Jakarta) 2. App oder nicht App, ist das hier die Frage? (Ewa Gozd, Stadtbibliothek Heilbronn) 3. Koha-Einbindung in Apps von Drittanbietern (Uwe Böttcher, WHU Otto Beisheim School of Management) 4. Auf Safari: Suche mit Zebra (Katrin Fischer, Bibliotheksservice-Zentrum BW) Wir freuen uns auf eine rege Teilnahme und Beteiligung! Für das Organisationsteam (AG Koha D-A-CH , BSZ, ThULB) Katrin Fischer -- Katrin Fischer Bibliotheksservice-Zentrum Baden-Wuerttemberg (BSZ) 78457 Konstanz / Germany Phone: +49 7531 - 88 4934 E-Mail: katrin.fischer(a)bsz-bw.de http://bsz-bw.de

1 0

Re: [Koha] koha script wiki
by dcook＠prosentient.com.au 10 Nov '20

10 Nov '20

I am concerned about adding backend scripts to the wiki. There's no reliable way to ensure those scripts would be correct, and it would be trivial for someone to inject malicious code into the scripts and have unsuspecting users run things which could damage/compromise their backend systems by copy/pasting and executing. I fear that people would see it on the wiki and take that as an endorsement of those scripts. David Cook Software Engineer Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Online: 02 8005 0595 -----Original Message----- Date: Sun, 8 Nov 2020 08:15:40 +0000 From: "Renvoize, Martin" <martin.renvoize(a)ptfs-europe.com> To: rogan.hamby(a)gmail.com Cc: Koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] koha script wiki Message-ID: <CAB7SL8B7tGQDss1zMJXXSZRubp9bJAGUtVBac7KAKcMsmmbnVA(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" By all means feel free to add a page to the wiki... I do wonder, however, why don't you submit useful scripts to the project via bugzilla instead..? That way they would benefit from the many eyes of our signoff and quality assurance process, get documented as part of the standard documentation processes and be more accessible to end users? Just some thoughts,

3 2

Sitemap
by Victor Barroso Oliveira 09 Nov '20

09 Nov '20

Good Morning, In which koha folder should I insert the sitemap.xml? I inserted in the folder / usr / share / koha / opac / htdocs more when I type https: //meusite/sitemap.xml the sitemap.xml code is not displayed What is the correct procedure? Thank you, Victor

3 2

ElasticSearch Fails in Reindexing
by Charles Kelley 08 Nov '20

08 Nov '20

Hello, all! I manage a small library. Most of the collection is in CJK languages, and I have been recataloging the collection from scratch. Because of a myriad of problems in searching non-Roman writing systems, we installed ElasticSearch. Finally, we could search the CJK-language catalogued records! Mind you, this extended to Russian, Greek, and other writing systems, so we were pleased. Then something happened and the indexing failed in the authority indexes. Mind you, we can search by author in the regular catalog but cannot search in the authority records. I have reindexed the zebra indexes and I have submitted the following commands in order to reindex the ElasticSearch indexes. #sudo koha-rebuild-zebra -f -v libr #sudo koha-elasticsearch --rebuild -d -v libr #sudo koha-elasticsearch --rebuild -v libr Both commands end up in failure, the routine stops (aborts or ends, I don't know), and the indexes are lost. The actual error is Something went wrong rebuilding indexes for libr I see quite a few error messages, to wit: Use of uninitialized value $sub6 in pattern match (m//) at /usr/share/koha/lib/Koha/SearchEngine/Elasticsearch.pm line 592. Right before the routine ends and returns us to the OS prompt, we see additional error messages, to wit: Use of uninitialized $tag in hash element at /usr/share/perl5/MARC/Record.pm line 202. Use of uninitialized $tag in regexp compilation at /usr/share/perl5/MARC/Record.pm line 206. Use of uninitialized $tag in hash element at /usr/share/perl5/MARC/Record.pm line 207. Can't call method "tag" on an undefined value at /usr/share/koha/lib/C4/Heading.pm line 71 That's when Something went wrong rebuilding indexes for libr happens. Can anyone tell us what's gone wrong and, more to the point, how to repair it? Koha 20.05 Debian Stretch 9.13 Many thanks. -- 気を付けて。 /ki wo tukete/ = Take care. -- 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.

1 0

koha script wiki
by Alvaro Cornejo 08 Nov '20

08 Nov '20

Hi Would it be possible to create a koha wiki for sharing scripts? Koha has reports, css and js wikis for sharing them with the community. I guess a way to share scripts might be an enhancement to koha ressources. Sometimes, writing scripts is a fast, cheap and reliable way to solve very specific issues. So sharing these resources might help the koha community. Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire

4 4

Error wihile import MARC record
by Sami M. Rasheed 07 Nov '20

07 Nov '20

Dears, I have this error when I import MARC report, I use koha version 20I use ubuntu OS 20.04My file contains 19000 records Software error: Can't call method "results" on an undefined value at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 363. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Please help me ..Thanks

1 0

Re: [Koha] OPAC 404 errors after upgrading to 20.05
by Father Vlasie 06 Nov '20

06 Nov '20

Hello again! It seems the problem is with the URL generated by the search results: /cgi-bin/koha/opac-detail.pl?biblionumber=&query_desc=kw%2Cwrdl%3A%20Kang You can see there is no biblionumber specified! I am not sure how to troubleshoot this... FV > On 4 Nov 2020, at 9:09 am, Father Vlasie <fv(a)spots.school> wrote: > > Hello Alvaro, > > Thank you very much for your reply. > > This 404 page I am seeing is coming from Koha: https://library.spots.school/cgi-bin/koha/errors/404.pl > > Nothing is showing in the Apache logs. ( I have checked both access and error logs. ) > > Any other ideas? > > Thank you, > > FV > >> On 3 Nov 2020, at 9:10 pm, Alvaro Cornejo <cornejo.alvaro(a)gmail.com> wrote: >> >> Hi >> >> 404 means the requested page is not available or can not be found. Either because the page does not exist or the user running apache does not have the right permissions. >> >> Can you check apache access log? there shall be the exact url you are trying to hit and gives you a more detailed idea of where the issue is. >> >> you can run the following comand to find the related lines: >> >> # sudo more /var/log/apache2/access.log |grep 404 >> >> Hope this helps. >> >> Regards, >> >> Alvaro >> |----------------------------------------------------------------------------------------| >> Stay safe / Cuídate/ Reste sécurisé >> 7 Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. >> q Recycle always / Recicla siempre / Recyclez toujours >> P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire >> >> >> Le mar. 3 nov. 2020 à 22:24, Father Vlasie <fv(a)spots.school> a écrit : >> Hello everyone, >> >> After upgrading to version 20.05.05 from 19 I am getting 404 errors ("Sorry, the requested page is not available Error 404 This message can have the following reason(s):...") when clicking on titles in search results in the OPAC. The OPAC error log is showing a lot of uninitialised values: >> >> [Tue Nov 03 17:21:14.194405 2020] [cgi:error] [pid 5557] [client 192.168.2.30:54618] AH01215: [Tue Nov 3 17:21:14 2020] opac-search.pl: Use of uninitialized value $query in pattern match (m//) at /usr/share/koha/lib/C4/Search.pm line 1330.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl >> [Tue Nov 03 17:21:14.194635 2020] [cgi:error] [pid 5557] [client 192.168.2.30:54618] AH01215: [Tue Nov 3 17:21:14 2020] opac-search.pl: Use of uninitialized value $_ in substitution (s///) at /usr/share/koha/lib/C4/Search.pm line 1603.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl >> [Tue Nov 03 17:21:14.194821 2020] [cgi:error] [pid 5557] [client 192.168.2.30:54618] AH01215: [Tue Nov 3 17:21:14 2020] opac-search.pl: Use of uninitialized value in subroutine entry at /usr/share/perl5/URI/Escape.pm line 184.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl >> [Tue Nov 03 17:21:14.195109 2020] [cgi:error] [pid 5557] [client 192.168.2.30:54618] AH01215: [Tue Nov 3 17:21:14 2020] opac-search.pl: WARNING: query problem with ZOOM error 10014 "CCL parsing error" (addinfo: "Search word expected") from diag-set 'ZOOM' at /usr/share/koha/lib/C4/Search.pm line 355.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl >> [Tue Nov 03 17:21:14.245662 2020] [cgi:error] [pid 5557] [client 192.168.2.30:54618] AH01215: [Tue Nov 3 17:21:14 2020] opac-search.pl: Use of uninitialized value $times in subtraction (-) at /usr/share/koha/lib/C4/Search.pm line 1757.: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl >> [Tue Nov 03 19:02:41.708306 2020] [cgi:error] [pid 1483] [client 192.168.2.30:56692] AH01215: [Tue Nov 3 19:02:41 2020] opac-main.pl: Argument "" isn't numeric in numeric gt (>) at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/includes/html_helpers.inc line 23.: /usr/share/koha/opac/cgi-bin/opac/opac-main.pl, referer: https://library.spots.school/cgi-bin/koha/errors/404.pl >> >> >> I have rebooted the server so all of the services have been restarted. Following the instructions here I rebuilt the Zebra index: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Upgrade_Inst… >> >> My uname shows: Linux owl 4.9.0-14-amd64 #1 SMP Debian 4.9.240-2 (2020-10-30) x86_64 GNU/Linux >> >> Any help would be very much appreciated! >> >> FV >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >

5 6

Patron with checked out items with no information
by clint.deckard 06 Nov '20

06 Nov '20

I have a patron that has a number of checked out items, three of which are blank/have no details ie. when viewing overdue items there are no details for three of the items. When listing checked out items for this patron it just sits trying to load them. I can't find any similar problem in bugs or the web. How can I correct the problem? This was originally a 3.20 version and migrated to 17.11 on Debian using MySQL. There are no problems listed in 'System Information' on the 'About Koha' page. Appreciate the help, Clint.

2 5

Re: [Koha] Birthday Wishes email to patron any option from koha?
by Alvaro Cornejo 06 Nov '20

06 Nov '20

Hi Here is the report to setup as *public*: SELECT borrowers.surname, borrowers.firstname, borrowers.email, borrowers.emailpro, borrowers.sex, borrowers.lang FROM borrowers WHERE DATE_FORMAT(borrowers.dateofbirth, '%m-%d') = DATE_FORMAT(CURDATE(), '%m-%d') LIMIT 50 You can add other fields to the report so you can do additional verifications/vaidations like the patron is active, has had activity in the last x months/years, etc. Be careful with the order of the fields since this will have an impact on the script. We set LIMIT to 50 just to avoid the public report "hard record limit" of 10 records per query. You can set it to anything you think is reasonable. The script is what is between ============ lines: The script uses sendmail to send plain text emails. You can modify it to use any of the perl email libraries and use html format instead. koha_birthdays.pl ================= #!/usr/bin/perl # Library includes use strict; use warnings; use LWP::UserAgent; use HTTP::Request; use JSON; print "\nEjecutando koha_birthday\n"; #My Global Variables my $hello = ""; my $subject = ""; my $body = ""; my $message = ""; my $to = ""; my $from = ""; my $result = ""; my $i = 0; # Capture report data: # Fields from report: surname firstname email emailpro sex lang # Prepare connection, call url and insert data (json format) to arrary my $ua = new LWP::UserAgent; $ua->agent("Perl API Client/1.0"); my $url = "https://YOURSITE/cgi-bin/koha/svc/report?id=XX"; # REPLACE YOUR SITE WITH YOUR OPAC BASE URL and XX WITH THE NUMBER OF THE REPORT YOU CREATE ABOVE my $request = HTTP::Request->new("GET" => $url); my $response = $ua->request($request); my $json_obj = JSON->new->utf8->decode($response->content); my $row_num = scalar(@{$json_obj}); #Scroll/split each registry and send the email foreach my $row (@{$json_obj}) { if ($i < $row_num) { my $surname = @{$row}[0]; my $firstname = @{$row}[1]; my $email = @{$row}[2]; my $emailpro = @{$row}[3]; my $sex = @{$row}[4]; my $lang = @{$row}[5]; # Get destination address (private email else professional) if ($email) { my $to = $email; } elsif ($emailpro) { my $to = $emailpro; } else { next; } # Assemble the patron salutation string for each language. Our default is es-ES if ($lang eq "default" || $lang eq "es-ES") { if ($sex eq "M") { $hello = "Estimado Sr. $surname,\n" } elsif ($sex eq "F") { $hello = "Estimada Sra. $surname,\n" } else { $hello = "Estimado(a) $firstname $surname,\n" } } elsif ($lang eq "en") { if ($sex eq "M") { $hello = "Dear Mr. $surname,\n" } elsif ($sex eq "F") { $hello = "Dear Mrs. $surname,\n" } else { $hello = "Dear $firstname $surname,\n" } } # Define email subject & body if ($lang eq "default" || $lang eq "es-ES") { $subject = "Feliz cumpleaños le desea el CELACP!"; $body = "\n"; $body .= "El CELACP se complace en hacerle llegar sus mejores deseos en esta fecha tan importante para Ud.\n\n"; $body .= "Sinceramente esperamos tenga un muy feliz día y esperamos contar con su presencia en nuestro local\n"; $body .= "o a través de nuestra plataforma virtual en https://biblioteca.celacp.org\n\n"; $body .= "Atentamente,\n\n"; $body .= "Centro de Estudios Latinoaméricanos Antonio Cornejo Polar - CELACP -\n"; } elsif ($lang eq "en") { $subject = "Happy birthday from the CELACP!"; $body = "\n"; $body .= "The CELACP is pleased to send you its best wishes on this important date for you.\n\n"; $body .= "We sincerely hope you have a very happy day and we look forward to seeing you at our library\n"; $body .= "or through our virtual platform at https://biblioteca.celacp.org\n\n"; $body .= "Sincerely,\n\n"; $body .= "Center for Latinamerican Estudies Antonio Cornejo Polar - CELACP -\n"; } # Final message assembly #$to = 'dummy(a)gmail.com'; #Dummy address for testing purposes. If uncommented, overrides the destination address and all emails will be sent to this address. $from = 'source_emaiil(a)mydomain.com'; $message = $hello; $message .= $body; # Create mail "session" open(MAIL, "|/usr/sbin/sendmail -t"); # Email Header print MAIL "To: $to\n"; print MAIL "From: $from\n"; print MAIL "Subject: $subject\n\n"; # Email Body print MAIL $message; # Send email & confirm $result = close(MAIL); if($result) { print "Se envió mensaje a $to\n";} else { print "Falló el envío del mensaje a $to!\n";} $i++; } # END IF } # END FOREACH print "Se enviaron $i mensajes de cumpleaños\n"; 1; ========================= To run from the command line: # perl /PATHTOSCRIPT/koha_birthdays.pl To run on a cron job add /usr/bin/perl /PATHTOSCRIPT/koha_birthdays.pl to, for example /etc/cron.daily/koha-common or if you are to use crontab you can add: 0 7 * * * USER /usr/bin/perl /PATHTOSCRIPT/koha_birthdays.pl This will run the script every day at 7:00 am and will use user USER privileges to run it. Hope this helps. Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le jeu. 5 nov. 2020 à 18:42, <pandian(a)imsc.res.in> a écrit : > Dear Alvaro, > > Thanks, yes can you please share the script codes so that we can use it. > > Regards > > Pandian > > Quoting Alvaro Cornejo <cornejo.alvaro(a)gmail.com>: > > > Hi > > > > We have created a public report in koha that provides us the info we need > > to send the emails and created a script that parses the output of that > > report and sends the email. We finally run this script with a cronjob. > > > > I can share the report and script if you think it will help you. > > > > Regards > > > > Alvaro > > > |----------------------------------------------------------------------------------------| > > Stay safe / Cuídate/ Reste sécurisé > > *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à > > mesure. > > *q *Recycle always / Recicla siempre / Recyclez toujours > > P Print only if absolutely necessary / Imprime solo si es necesario / > > Imprimez seulement si nécessaire > > > > > > Le mer. 4 nov. 2020 à 12:56, Owen Leonard <oleonard(a)myacpl.org> a écrit > : > > > >> > So how can we make this possible to send birthday wishes from Koha? > >> > >> Currently it is not possible. There is an open bug for this, but so > >> far no one has taken it on: > >> > >> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22086 > >> > >> Owen > >> > >> -- > >> Web Developer > >> Athens County Public Libraries > >> (740) 737-6006 > >> https://www.myacpl.org > >> _______________________________________________ > >> > >> Koha mailing list http://koha-community.org > >> Koha(a)lists.katipo.co.nz > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > >> > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > >

2 2