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 <[email protected]> >To: Olugbenga Adara <[email protected]> >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 <[email protected]> >>> To: Olugbenga Adara <[email protected]> >>> Cc: "[email protected]" <[email protected]> >>> 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 <[email protected]>: >>>> >>>> >>>> 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 >>>> [email protected] >>>> http://lists.katipo.co.nz/mailman/listinfo/koha >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> [email protected] >>> http://lists.katipo.co.nz/mailman/listinfo/koha >>> >>> >>> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> 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----- > > > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
