https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29816
Michaela Sieber <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from Michaela Sieber <[email protected]> --- https://koha.bywatersolutions.com/education/monday-minutes-emailing-customized-patron-notices 1.) REPORT create the report. Keep in mind, only columns in report are available for the sent notice All reports for this function need to include borrowernumber and an emailaddress Example Report: SELECT borrowernumber, email, firstname, surname, round (sum(amountoutstanding),2) as total_fines FROM borrowers LEFT JOIN accountlines using (borrowernumber) GROUP BY borrowernumber HAVING total_fines>50 2.) NOTICE / LETTER Go to Tools › Notices & slips. Click on + New notice dropdown. Select the module you want to add the notice to ( remember this information for the cronjob). Create a code for the notice (all caps and under 10 characters as a rule of thumb). You will also need this code for the cronjob. Add a name for the notice. Add a message subject. Add in your message body (we use the template toolkit syntax in the example in our video). Click save. Example from video: Dear [% firstname %] [% surname %]. You owe us $[% total_fines %]. Please pay up. Thank you so much!! 3.) CRONJOB Once you have created the notice and set up the report, it's time to set up the cronjob. You will want to include the 3 following items: The code of the notice (Tools - Notices and Slips) The module of the notice (Tools - Notices and Slips) The report number (Reports Module) Here is an example of the cronjob that will be run: misc/cronjobs/patron_emailer.pl --report 48 --notice BIGFINE --module circulation --from [email protected] --commit -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
