[Koha] Enhanced messages

[Olugbenga Adara]

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 at catalyst.net.nz>
>To: Olugbenga Adara <gbengaadara at 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 at biblibre.com>
>>> To: Olugbenga Adara <gbengaadara at yahoo.com>
>>> Cc: "koha at lists.katipo.co.nz" <koha at 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 at 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 at lists.katipo.co.nz
>>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>>
>>>
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at 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-----
>
>
>
>