[Koha] export patrons with additional attributes

[Joy Nelson]

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