Re: [Koha] Birthday Wishes email to patron any option from koha?

2020-11-06 Thread Alvaro Cornejo
Hi Small bug: # Get destination address (private email else professional) if ($email) { my $to = $email; <<-- REMOVE THE my } elsif ($emailpro) { my $to = $emailpro; <<-- REMOVE THE my } else {

Re: [Koha] Birthday Wishes email to patron any option from koha?

2020-11-05 Thread pandian
Dear Alvaro, Thanks very much. I will check and get back should i need any clarifications and help. Regards, Pandian Quoting Alvaro Cornejo : Hi Here is the report to setup as *public*: SELECT borrowers.surname, borrowers.firstname, borrowers.email, borrowers.emailpro, borrowers.sex,

Re: [Koha] Birthday Wishes email to patron any option from koha?

2020-11-05 Thread Alvaro Cornejo
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

Re: [Koha] Birthday Wishes email to patron any option from koha?

2020-11-05 Thread Alvaro Cornejo
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

Re: [Koha] Birthday Wishes email to patron any option from koha?

2020-11-04 Thread Owen Leonard
> 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)

[Koha] Birthday Wishes email to patron any option from koha?

2020-11-04 Thread MAMCET Library
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? ___ Koha mailing list http://koha-community.org