Hi Vimal, There is a script provided in Koha to do this, on the packages it will be at /usr/share/koha/bin/maintenance/borrowers-force-messaging-defaults
To use it, set the defaults for each category within the Patron categories editor in the Koha administration, then use this script to apply those defaults to all borrowers. Be aware that if you have borrowers that have personally set these settings already, using the tool to force defaults will override their preferences. This can lead to angry borrowers. I hope this helps, Cheers, Liz Rea Catalyst IT On 01/03/17 08:28, Vimal Kumar V. wrote: > Dear Friends, > I would like to enable all SMS and Email messaging preferences (Check-in, > check-out etc) of all patrons. > > Kindly help me to create an SQL query to do the process. > Regards, -- -- Liz Rea Catalyst.Net Limited Level 6, Catalyst House, 150 Willis Street, Wellington. P.O Box 11053, Manners Street, Wellington 6142 GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha