[Koha] export patrons with additional attributes

[Erlanda Simonyan]

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 <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
  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.