Thank you very much! ----- Original Message ----- From: Joy Nelson To: Erlanda Simonyan Cc: Koha Sent: Thursday, March 28, 2019 3:21 PM Subject: Re: [Koha] export patrons with additional attributes
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 p LEFT 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 <[email protected]> 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 [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha -- Joy Nelson President, Koha Division ByWater Solutions Support and Consulting for Open Source Software Phone/Fax (888)900-8944 What is Koha? No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2265 / Virus Database: 4365/15297 - Release Date: 07/04/18 Internal Virus Database is out of date. _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
