Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts
I hope this question isn’t too obvious, but I can’t seem to find it: how does one “turn on the deleted flag on the account?” Thank you, Scott From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Tuesday, August 04, 2015 4:44 PM To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts There are other issues that can come up with reporting and aged circulations but those are more workflow issues than technical ones. All of this being a very long way of saying there are pros and cons with every choice. :) On Tue, Aug 4, 2015 at 3:54 PM, Jason Etheridge ja...@esilibrary.commailto:ja...@esilibrary.com wrote: Thank you for replying. One thing you mentioned has piqued my interest. It might be easier if I gave a scenario instead of trying to describe what I mean. Say, on January 2, 2016, I run a report on circulation for 2015 and then, a month later, delete many patrons some of whom had checked out materials in 2015. If I ran the same 2015 report again after the deletions, would the numbers be different because the patrons were purged? In other words, when a patron is deleted, do their countable circ transactions go with them? There is a trigger on the circulation table that will convert circulations being deleted into aged (essentially anonymous) circulations. Depending on how you write your report, you can get some statistics that way. -- Jason Etheridge | Community and Migration Manager | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.commailto:ja...@esilibrary.com | web: http://www.esilibrary.com -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewishttp://www.goodreads.com/author/show/1069006.C_S_Lewis
Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts
It's typically done on the database level not in the staff client. For example a library might say we don't have a reciprocal borrowing agreement with county X anymore can you delete all the addresses with Zip Codes Y, Z and Q? and we do it. On Wed, Aug 5, 2015 at 7:57 AM, Scott Thomas sc...@albright.org wrote: I hope this question isn’t too obvious, but I can’t seem to find it: how does one “turn on the deleted flag on the account?” Thank you, Scott *From:* Open-ils-general [mailto: open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan Hamby *Sent:* Tuesday, August 04, 2015 4:44 PM *To:* Evergreen Discussion Group open-ils-general@list.georgialibraries.org *Subject:* Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts There are other issues that can come up with reporting and aged circulations but those are more workflow issues than technical ones. All of this being a very long way of saying there are pros and cons with every choice. :) On Tue, Aug 4, 2015 at 3:54 PM, Jason Etheridge ja...@esilibrary.com wrote: Thank you for replying. One thing you mentioned has piqued my interest. It might be easier if I gave a scenario instead of trying to describe what I mean. Say, on January 2, 2016, I run a report on circulation for 2015 and then, a month later, delete many patrons some of whom had checked out materials in 2015. If I ran the same 2015 report again after the deletions, would the numbers be different because the patrons were purged? In other words, when a patron is deleted, do their countable circ transactions go with them? There is a trigger on the circulation table that will convert circulations being deleted into aged (essentially anonymous) circulations. Depending on how you write your report, you can get some statistics that way. -- Jason Etheridge | Community and Migration Manager | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.com | web: http://www.esilibrary.com -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis
Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts - AND books?
Funny thing about deleted copies is they come back! Just last week I was asked to undelete about 1 dozen copies that showed up in the returns. If you really delete them from the database, you can't do that. Just some food for thought. Jason -- Jason Stephenson Assistant Director for Technology Services Merrimack Valley Library Consortium 4 High ST, Suite 175 North Andover, MA 01845 Phone: 978-557-5891 Email: jstephen...@mvlc.org
Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts - AND books?
Oh yeah, they reappear like fleas. It's one reason I don't like obliterating, things that folks are sure they never want to see again one day suddenly are desirable the next. On Wed, Aug 5, 2015 at 10:00 AM, Jason Stephenson jstephen...@mvlc.org wrote: Funny thing about deleted copies is they come back! Just last week I was asked to undelete about 1 dozen copies that showed up in the returns. If you really delete them from the database, you can't do that. Just some food for thought. Jason -- Jason Stephenson Assistant Director for Technology Services Merrimack Valley Library Consortium 4 High ST, Suite 175 North Andover, MA 01845 Phone: 978-557-5891 Email: jstephen...@mvlc.org -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis
Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts - AND books?
All – I completely understand! This is a valuable option for those folks who need this. But there should ALSO be an option for completely and utterly obliterating the record – if you need to.We just REMOVED about 600 books from our collection (remember that we are an academic library) and we never want to see them again. We expect that they are weeded and gone. But no. They are still hanging around the system to clutter things up. And confuse things too. That is why we are experiencing so much problem with our items we are moving around into a new Children’s collection. We weeded, we merged, and now we are changing call numbers. But the “deleted” stuff keeps showing up when we THOUGHT we deleted it and never want to see it again. I’m NOT saying to remove the option to “hide” items in case you want to use them again or in the case where there are items attached or fines or such. BUT, it would be really great to also have the option to really and finally REMOVE items from the system. There are times when that is needed as well. Thanks! Jennifer -- Jennifer Walz, MLS - Head of ILS Ministrations Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Wednesday, August 05, 2015 10:10 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts - AND books? Oh yeah, they reappear like fleas. It's one reason I don't like obliterating, things that folks are sure they never want to see again one day suddenly are desirable the next. On Wed, Aug 5, 2015 at 10:00 AM, Jason Stephenson jstephen...@mvlc.orgmailto:jstephen...@mvlc.org wrote: Funny thing about deleted copies is they come back! Just last week I was asked to undelete about 1 dozen copies that showed up in the returns. If you really delete them from the database, you can't do that. Just some food for thought. Jason -- Jason Stephenson Assistant Director for Technology Services Merrimack Valley Library Consortium 4 High ST, Suite 175 North Andover, MA 01845 Phone: 978-557-5891tel:978-557-5891 Email: jstephen...@mvlc.orgmailto:jstephen...@mvlc.org -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewishttp://www.goodreads.com/author/show/1069006.C_S_Lewis
Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts - AND books?
Jennifer, Where, other than reports that lack a filter on Is deleted, are these items showing up? Thanks, -- Mike Rylander | President | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com On Wed, Aug 5, 2015 at 10:35 AM, Walz, Jennifer jlw...@asbury.edu wrote: All – I completely understand! This is a valuable option for those folks who need this. But there should ALSO be an option for completely and utterly obliterating the record – if you need to.We just REMOVED about 600 books from our collection (remember that we are an academic library) and we never want to see them again. We expect that they are weeded and gone. But no. They are still hanging around the system to clutter things up. And confuse things too. That is why we are experiencing so much problem with our items we are moving around into a new Children’s collection. We weeded, we merged, and now we are changing call numbers. But the “deleted” stuff keeps showing up when we THOUGHT we deleted it and never want to see it again. I’m NOT saying to remove the option to “hide” items in case you want to use them again or in the case where there are items attached or fines or such. BUT, it would be really great to also have the option to really and finally REMOVE items from the system. There are times when that is needed as well. Thanks! Jennifer -- Jennifer Walz, MLS - Head of ILS Ministrations Kinlaw Library - *Asbury University* One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu *From:* Open-ils-general [mailto: open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan Hamby *Sent:* Wednesday, August 05, 2015 10:10 AM *To:* Evergreen Discussion Group *Subject:* Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts - AND books? Oh yeah, they reappear like fleas. It's one reason I don't like obliterating, things that folks are sure they never want to see again one day suddenly are desirable the next. On Wed, Aug 5, 2015 at 10:00 AM, Jason Stephenson jstephen...@mvlc.org wrote: Funny thing about deleted copies is they come back! Just last week I was asked to undelete about 1 dozen copies that showed up in the returns. If you really delete them from the database, you can't do that. Just some food for thought. Jason -- Jason Stephenson Assistant Director for Technology Services Merrimack Valley Library Consortium 4 High ST, Suite 175 North Andover, MA 01845 Phone: 978-557-5891 Email: jstephen...@mvlc.org -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis
[OPEN-ILS-GENERAL] Non-Public Copy Notes
We have been doing some tests with Copy Notes. My assumption was that, if you did not mark the Public checkbox when creating a note, it would appear in catalog displays in the staff client, but not in the public catalog. Our tests revealed that non-public Copy Notes appear...well...nowhere except in Edit Item Attributes / Copy Notes. This, of course, renders them pretty much useless. Am I missing something? Scott Scott Thomas, MLS Head of Information Technologies and Technical Services Scranton Public Library Lackawanna County Library System 2006 N. Main Ave. Scranton, PA 18508 Ph: 570-207-2379 Fx: 570-348-3020 Email: sc...@albright.orgmailto:sc...@albright.org
Re: [OPEN-ILS-GENERAL] Non-Public Copy Notes
That's my understanding. Whenever I place a hold on a particular copy for some reason, I use private copy notes to jog my memory about what I need to do with that item, since it can be a few weeks before the hold is filled. That is to me useful since I know it is there to look for it. You can also generate reports that contain them, so they could be used for projects. On the whole, though, I agree with you, they are not particularly useful, since other staff will never see them unless they specifically seek them out, and it is very tedious to access them. I've always thought it would be very helpful if there was an option for copy notes in the column picker. I could use it for checking my public copy notes without viewing every item in the OPAC, and it would make private copy notes much more readily visible to staff. On Wed, Aug 5, 2015 at 2:46 PM, Scott Thomas sc...@albright.org wrote: We have been doing some tests with Copy Notes. My assumption was that, if you did not mark the “Public” checkbox when creating a note, it would appear in catalog displays in the staff client, but not in the public catalog. Our tests revealed that non-public Copy Notes appear…well…nowhere except in Edit Item Attributes / Copy Notes. This, of course, renders them pretty much useless. Am I missing something? Scott Scott Thomas, MLS Head of Information Technologies and Technical Services Scranton Public Library Lackawanna County Library System 2006 N. Main Ave. Scranton, PA 18508 Ph: 570-207-2379 Fx: 570-348-3020 Email: sc...@albright.org -- Sarah Childs Technical Services Department Head Hussey-Mayfield Memorial Public Library 250 North Fifth Street Zionsville, IN 46077 317-873-3149 x13330 sar...@zionsvillelibrary.org