[Koha] SQL query to enable all patrons messaging preferences

[Liz Rea]

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: OpenPGP digital signature
URL: <https://lists.katipo.co.nz/pipermail/koha/attachments/20170301/fef75076/attachment.sig>