Re-Hi Admire, you might want to take a look at the script 'borrowers-force-messaging-defaults.pl', which is designed to update individual patron messaging preferences in accordance to the messaging settings of each user group. 'EnhancedMessagingPreferences ' is required to be set to 'enabled'. Please find more details here: http://kohageek.blogspot.com/2017/03/borrowers-force-messaging-defaults.html https://perldoc.koha-community.org/misc/maintenance/borrowers-force-messagin... Hope it helps. Best Uwe ___________________________________________________________________ (MR.) Uwe Boettcher Director Library WHU – Otto Beisheim School of Management Campus Vallendar, Burgplatz 2, 56179 Vallendar, Germany Tel.: +49 261 6509-550 ; Fax: +49 261 6509-559 uwe.boettcher@whu.edu ; www.whu.edu ___________________________________________________________________ ________________________________________ Von: Koha <koha-bounces@lists.katipo.co.nz> im Auftrag von Mutsikiwa Admire <amutsikiwa@uzlib.uz.ac.zw> Gesendet: Dienstag, 27. November 2018 17:25 An: koha@lists.katipo.co.nz Betreff: [Koha] Global Updating of Patron messaging preferences Hi I have recently imported close to 15 000 patrons records. I am interested in a script or SQL query that would enable me to modify Patron Messaging Preferences. Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe <Tel:+263-4-303276> Tel:+263-4-303276 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp, 1880-1941, former director of the Bank of England _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha