[Koha] SQL query to enable all patrons messaging preferences

2017-03-01 Thread Vimal Kumar V.
Dear Jonthan, As per your instructions I run the script. All borrowers messaging preferences set to default messaging preferences of concerned Patron categories. Now its OK. Thank you Liz and Jonathan. Following commands applied. Load environment variables sudo su export

Re: [Koha] SQL query to enable all patrons messaging preferences

2017-03-01 Thread Jonathan Druart
Did you call it with --doit? See perl misc/maintenance/borrowers-force-messaging-defaults -h On Wed, 1 Mar 2017 at 07:03 Vimal Kumar V. wrote: > Dear Liz, > The script borrowers-force-messaging-defaults did not change the messaging > preferences of patrons already entered.

[Koha] SQL query to enable all patrons messaging preferences

2017-02-28 Thread Vimal Kumar V.
Dear Liz, The script borrowers-force-messaging-defaults did not change the messaging preferences of patrons already entered. But default messaging preferences of Patron category visible when we create a new patron. Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi

[Koha] SQL query to enable all patrons messaging preferences

2017-02-28 Thread Vimal Kumar V.
Hi Liz, Thank you for the solution. It's working. Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: http://www.vimalkumar.info Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://dspacegeek.blogspot.in

Re: [Koha] SQL query to enable all patrons messaging preferences

2017-02-28 Thread 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

[Koha] SQL query to enable all patrons messaging preferences

2017-02-28 Thread Vimal Kumar V.
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, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: