[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 PERL5LIB="/usr/share/koha/lib"
export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"

Run borrowers-force-messaging-defaults script

cd /usr/share/koha/bin/maintenance
perl borrowers-force-messaging-defaults --doit

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
http://moovandan.blogspot.in  
---
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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.
> 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 University
> Kottayam, Kerala
> Web: http://www.vimalkumar.info
> Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://dspacegeek.blogspot.in
> http://moovandan.blogspot.in  
> ---
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[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 University
Kottayam, Kerala
Web: http://www.vimalkumar.info
Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
http://dspacegeek.blogspot.in
http://moovandan.blogspot.in  
---
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[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
http://moovandan.blogspot.in  
---
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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 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




signature.asc
Description: OpenPGP digital signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[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: http://www.vimalkumar.info
Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
http://dspacegeek.blogspot.in
http://moovandan.blogspot.in  
---
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha