Erlanda, You will have to reset patrons passwords after moving the patrons from a different system to Koha. (or even from Koha to Koha) The passwords are encrypted in Koha and not exportable. You can import patrons with plain text passwords into Koha and they are encrypted when saved in the database. To export patrons with additional attributes, this SQL on the reports wiki will get you started. SELECT p.surname, p.firstname, p.cardnumber, a.code, a.attribute FROM borrowers pLEFT JOIN borrower_attributes a USING (borrowernumber)GROUP BY a.attribute ORDER BY p.surname, p.firstname ASC -joy On Thu, Mar 28, 2019 at 6:56 AM Erlanda Simonyan < erlanda_simonyan@flib.sci.am> wrote:
Hello,
Can anyone help to export patrons with additional attributes which we added on Patrons page
and always after importing patrons' from one server to another we have to update their passwords.
Thanks, Erlanda _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Joy Nelson President, Koha Division ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>