Hi Liz, This is good to know, and would be easier for people to run than going to the MySQL cli, which also worked. Olugbenga Adara Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara
________________________________ From: Liz Rea <liz@catalyst.net.nz> To: Olugbenga Adara <gbengaadara@yahoo.com> Sent: Thursday, August 29, 2013 6:12:39 PM Subject: Re: [Koha] Enhanced messages
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi Olugbenga,
There is also a script which, once you have set your messaging defaults, will go through all borrowers and set the messaging preferences to the defaults for every borrower.
It's in misc/maintenance/borrowers-force-messaging-defaults
Hope this helps, Liz On 30/08/13 01:58, Olugbenga Adara wrote:
Hello Jonathan,
Thanks. I will try your suggestion.
Regards
Olugbenga Adara
Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara
________________________________ From: Jonathan Druart <jonathan.druart@biblibre.com> To: Olugbenga Adara <gbengaadara@yahoo.com> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Sent: Thursday, August 29, 2013 3:35:42 AM Subject: Re: [Koha] Enhanced messages
Hello Olugbenga,
You have to switch on the EnhancedMessagingPreferences for theses messages to be sent.
If you want to enable options for all patrons, you must do that in the cli of your dbms.
For example, for Item checkout and Item check-in:
insert into borrower_message_preferences(borrowernumber,message_attribute_id) select borrowernumber, 5 from borrowers; insert ignore into borrower_message_transport_preferences(borrower_message_preference_id, message_transport_type) select borrower_message_preference_id, 'email' from borrower_message_preferences where message_attribute_id = 5;
insert into borrower_message_preferences(borrowernumber,message_attribute_id) select borrowernumber, 6 from borrowers; insert ignore into borrower_message_transport_preferences(borrower_message_preference_id, message_transport_type) select borrower_message_preference_id, 'email' from borrower_message_preferences where message_attribute_id = 6;
The 5 and 6 values correspond to the message_attribute_id in the message_attributes table (select * from message_attributes;)
Regards, Jonathan
2013/8/28 Olugbenga Adara <gbengaadara@yahoo.com>:
Hello all,
Is it possible to have all Koha patrons get messages like checkin,
checkout etc without setting the
EnhancedMessagingPreferences to Allow? I had assumed that this was not necessary but Koha was not sending messages until I turned this on and enabled it for the patron.
If the EnhancedMessagingPreferences must be set, is there any way to auto enable the messaging options for all patrons who are already on the system as a default?
I am running 3.12.3 on Debian 7
Thanks
Olugbenga Adara
Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQEcBAEBAgAGBQJSH8dWAAoJELbCpJ03Jji3DFQH/2qCaZT4v07lJbwYdHkmAGfv D9IfU2zsNCELm+SJe1AfWbSSlqhkXCGzQZzqbgNl7YT33+4EWBQZShfHQk9nWjw8 1ObTXezOKY7W8eRDm0G4YOdFyabAH5f+y+jSMIadfy6cPgQQ+CYaK6Plmv0c/R+R GPPlZxYRtNrHpoO4OWwGFirxx1Oh66H4aAezGWA6XI4C7xNzm6+xzLXvgKTuJjYN F4UYWLJJaSNCiQegClI1RBsPUICKOWPFMx43NJxnyipqXx3XOH5NV7bZWQ4QlTEm dsLbotZBUDArYV48CCizpdHdssYxKLf/zVJO0EW6Gf+M3RfoJenoQgCyxbTidrM= =rM74 -----END PGP SIGNATURE-----