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 (< [email protected]>) 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha

