Re: [Koha] New patron restrictions data
If it's the old restrictions data (from before the library upgraded to 3.14) the data is located in the borrowers table, in the borrowers.debarred and borrowers.debarred comment fields. Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler, *Rethinking the Future* On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] New patron restrictions data
Yup, and 1 of the restrictions is stored there, but I have 2 restrictions on the patron record and the other isn't anywhere in the borrowers table that I can see. Nicole On Thu, Mar 20, 2014 at 9:49 AM, Heather Braum (NEKLS) hbr...@nekls.org wrote: If it's the old restrictions data (from before the library upgraded to 3.14) the data is located in the borrowers table, in the borrowers.debarred and borrowers.debarred comment fields. Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler, *Rethinking the Future* On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] New patron restrictions data
Hello Nicole, It is in the borrower_debarments table. Regards, Jonathan 2014-03-20 15:00 GMT+01:00 Nicole Engard neng...@gmail.com: Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] New patron restrictions data
Thank you Jonathan for correcting me. I completely misread Nicole's question as the data she had was in the borrower_debarments table and she was asking where was the other data was. :) I need much more coffee this morning! Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler, *Rethinking the Future* On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart jonathan.dru...@biblibre.com wrote: Hello Nicole, It is in the borrower_debarments table. Regards, Jonathan 2014-03-20 15:00 GMT+01:00 Nicole Engard neng...@gmail.com: Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] New patron restrictions data
Thank you all! Nicole On Thu, Mar 20, 2014 at 9:55 AM, Heather Braum (NEKLS) hbr...@nekls.org wrote: Thank you Jonathan for correcting me. I completely misread Nicole's question as the data she had was in the borrower_debarments table and she was asking where was the other data was. :) I need much more coffee this morning! Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler, *Rethinking the Future* On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart jonathan.dru...@biblibre.com wrote: Hello Nicole, It is in the borrower_debarments table. Regards, Jonathan 2014-03-20 15:00 GMT+01:00 Nicole Engard neng...@gmail.com: Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
