[Koha] Bulk patron password updates

Tomas Cohen Arazi tomascohen at gmail.com
Tue Jun 18 02:29:57 NZST 2019


You can use the /usr/share/koha/bin/admin/set_password.pl script to make
your own batch script.

It needs you to know the patron id (borrowernumber) and can set whatever
you pass it with the --password parameter:

  $ koha-shell instance
k$ /usr/share/koha/bin/admin/set_password.pl --patron_id 234 --password
Apassw0rD!

if you don't pass the --password switch it will generate a random one.

Regards

El lun., 17 jun. 2019 a las 11:12, Dixson Rodriges (<
dixson at focuzinfotech.com>) escribió:

> Hi,
>
>
> Is are any mysql query for updating the common password for all
> patrons.
>
> I tried with following mysql query. but didn't worked out. I think it
> should be in encrypted format.
>
>  update borrowers set password='test123' where cardnumber='1001';
>
>
> Regards,
> Dixson
> --
>
>
>
>
>
>
>
> Best Regards,
>
>
>
> Dixson Rodrigues
>
> Manager - Support & Service
>
> FocuzInfotech
>
> (A Division of focuz Innovation Pvt Ltd)
>
> Ph: +91 484 2535390 Mob:09249500540
>
> Save Paper - Do you really need to print this e-mail?
>
>
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F


More information about the Koha mailing list