- Koha - lists.katipo.co.nz

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

Regarding KOHA reports
by ANJU SAINI 06 Nov '20

06 Nov '20

Hello everyone I just installed KOHA software . Anyone send me SQL for all reports . Any help would be very much appreciated!

2 2

Downgrade to 19 from 20
by Father Vlasie 06 Nov '20

06 Nov '20

Hello all, Is there an official guide for downgrading Koha to the previous version? I am having some serious trouble with my 20.05.05.000 install and I would like to go back to 19. Are there any database changes between these two versions? Thank you! FV

2 1

Birthday Wishes email to patron any option from koha?
by MAMCET Library 05 Nov '20

05 Nov '20

Dear all Nowadays clients send Birthday Wishes through SMS/email alerts from Banks or other organizations on their Birthday. So how can we make this possible to send birthday wishes from Koha?

3 2

Re: [Koha] Academic Repository
by L. Smith 05 Nov '20

05 Nov '20

Good morning, Need some help please . Or can someone please point me in the right direction please. I would like to start a repository for our staff thesis papers. How would I go about setting up a repository in Koha? Any guidance would be wonderful! Thank you so much. Best wishes, Lizelle Smith BA, AdvDipTour, DipLib, AALIA DCP Director of Library and Information Services Suite 18, 7 Aberdeen Street, Perth WA 6000 PO Box D178 Perth BC 6849 T: [ callto:+61 8 6222 4222 | +61 8 6222 4222 ] E: lsmith(a)sheridan.edu.au l W: [ http://www.sheridan.edu.au/ | www.sheridan.edu.au ] CRICOS No: 03391M. This email and any attachments may be confidential. If you are not the intended recipient, please inform the sender by reply email and delete all copies of this message .

2 1

Koha and Kanopy integration via SIP2
by Steve Nickerson 05 Nov '20

05 Nov '20

Does anyone have experience getting Koha "connected" to Kanopy via SIP2? If so, do you mind providing some tips and/or sharing the applicable portion(s) of your SIP config. file, please and thank you? I'm running the packaged version 19.11.06.000 on Ubuntu. Thanks! Steve

3 2

koha-US November 2020 Meetings & Events
by Jason Robb 04 Nov '20

04 Nov '20

koha-US online meetings and events are free and open to all. See our calendar for a full list of events with links: http://koha-us.org/calendar/ *Meetings* Board Meeting - Thursday, November 5th @ 10:00a PT / 1:00p ET / 6:00p UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1UmJbAJ9rVkMKvSdD825sOmLInDnNk43wsEqoW2v… General Meeting - To be determined *Special Interest Groups* Cataloging - Thursday, November 5th @ 8:00a PT / 11:00a ET / 4:00p UTC System Administration - Tuesday, November 10th @ 9:00a PT / 12:00p ET / 5:00p UTC User Services - Monday, November 16th @ 12:00p PT / 3:00p ET / 8:00p UTC Acquisitions - Tuesday, November 17th @ 9:00a PT / 12:00p ET / 5:00p UTC Web Development - Thursday, November 19th @ 10:00a PT / 1:00p ET / 6:00p UTC Books & Crafts - Wednesday, November 25th @ 5:00p PT / 8:00p ET / 1:00a UTC Special interest groups are open to all, and strive to encourage discussion on specific modules and areas of Koha. Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topics that interest you! Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

Koha and Hoopla integration via SIP2
by Steve Nickerson 04 Nov '20

04 Nov '20

Does anyone have experience getting Koha "connected" to Hoopla via SIP2? If so, do you mind providing some tips and/or sharing the applicable portion(s) of your SIP config. file, please and thank you? I'm running the packaged version 17.11.03.000 on Debian. Thanks! Steve

1 0

Roles for 21.05
by Renvoize, Martin 04 Nov '20

04 Nov '20

Hi All, Last call for submissions to take on a role for the 21.05 release cycle before the vote at this evenings general meeting. It came to our attention that the release maintainer roles were looking sparse in the community developers meeting this afternoon. Victor has graciously offered to take on the oldoldstable again, and Tomas will take on oldstable if we don't get any other candidates. It would be great to have some new members of the team, and the oldstable maintainer role would be a great role to take on (with the support of myself, Tomas and the rest of the development team). The role is well described here: https://wiki.koha-community.org/wiki/Project_roles#Release_maintainer and the processes are well documented on https://wiki.koha-community.org/wiki/Release_maintenance. Do please feel free to replace Tomas's name on the roles page or reply here if you're interested. https://wiki.koha-community.org/wiki/Roles_for_21.05 Hope you are all well, *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager Community Release Manager (19.11, 20.05) *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

1 0