[Bug 27443] New: Add an item loop mechanism to the patron emailer
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 Bug ID: 27443 Summary: Add an item loop mechanism to the patron emailer Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org It'd be great if the patron emailer provided an easy way to replicate something like the <item></item> section of an overdue notice of the <<items.content>> section of DUE notice. Perhaps we teach the emailer that if the report contains a column of comma-separated itemnumers named "items_content", we could iterate through something like the existing items.content functionality for every itemnumber included? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bwsdonna@gmail.com, | |kelly@bywatersolutions.com, | |nick@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Afaik the patron emailer is a plugin (even if I'd like it to be a feature in Koha :) ). So we probably should close that here? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Summary|Add an item loop mechanism |Add an item loop mechanism |to the patron emailer |to patron_emailer.pl cron Resolution|INVALID |--- --- Comment #2 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- I meant the cron: https://github.com/Koha-Community/Koha/blob/master/misc/cronjobs/patron_emai... The cron is essentially just a commandline version of the plugin. If we teach the cron to do cool things, we should also hassle Nick into teaching the same things to the plugin :) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Could we also hassle him to move the GUI for it into core? :) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 --- Comment #4 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- We can try! ¯\_(ツ)_/¯ https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27452 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEW --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Looking at some of the examples on the Bywater Blog it seemed like listing items was possible with TT syntax (but it seems posts might no longer be available?) What should we do with this bug? WONTFIX? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 Ray Delahunty <r.delahunty@arts.ac.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |r.delahunty@arts.ac.uk -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 --- Comment #6 from Ray Delahunty <r.delahunty@arts.ac.uk> --- We are using the Koha patron emailer (introduced in 19.05) rather than the Bywater plugin for our leavers (chasing them before they leave for items on loan to be returned) and have been trying to use template toolkit inside the notice so it can send different wordings to different patron groups (like we have it doing for MEMBERSHIP_EXPIRY, for example), but the testing has failed. Had it worked, our plan was to try the [% FOREACH checkout IN checkouts %] loop from the AUTO_RENEWAL_DGST to improve the horrid word-wrapped list of items on loan, pulled from the report. Our support company said: "the patron emailer doesn't yet support HTML, and I highly doubt that it would support template toolkit either". Might the answer be to improve the patron emailer so it accepts TT (and also html)? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kyle@bywatersolutions.com --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Ray Delahunty from comment #6)
word-wrapped list of items on loan, pulled from the report. Our support company said: "the patron emailer doesn't yet support HTML, and I highly doubt that it would support template toolkit either". Might the answer be to improve the patron emailer so it accepts TT (and also html)?
It seems strange that the cron should be so different from the in-built functionality? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 --- Comment #8 from Ray Delahunty <r.delahunty@arts.ac.uk> --- Apologies- on 22.11 I have notices being sent by the patron_emailer.pl script working perfectly with html, and the fields pulled in from the report must use TT notation so html and at least some TT is supported. All I can assume from earlier failures (ages back) must be down to specific objects/ variables that either aren’t fully supported (or more likely!) I had syntax errors in my TT code. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 --- Comment #9 from Ray Delahunty <r.delahunty@arts.ac.uk> --- While we wait for the patron emailer to have something like an <item></item> feature addded, so titles on a loan list (for example) will appear on separate lines, we are using a SEPARATOR with a GROUP CONCAT to improve the the horrid word-wrapped list in our leavers emails. We feed the list to a notice using the loans field: (SELECT GROUP_CONCAT( ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code>="a"]') SEPARATOR '<br/>') FROM [...] AS 'loans' Works OK. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org