Why does Koha allow one to delete an item record that is in use!? It should be simple enough to check it's status before permitting the record to be deleted. It does that with patron records, why not item records? Betsy Kelly Becker Medical Library Washington University in St Louis Message: 5 Date: Fri, 1 Apr 2011 15:14:18 +1300 From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Problem circulation records To: Sharon Jackson <sjackson@ashs.school.nz> Cc: koha@lists.katipo.co.nz Message-ID: <AANLkTimKoqOjUy=d0W2nWyQ6JUfACUTEDROanNuO=pLB@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 2011/4/1 Sharon Jackson <sjackson@ashs.school.nz>:
Hi, Can anyone help me please? ? I have a problem with some of my circulation records. The patron checkout session shows that an item is checked out to a patron but there are no item details, just a due date, which I can't get rid of. The (non-existent)? item can't be checked in.? Can anyone suggest how to remove these?
Hi Sharon I have seen this happen before when an item has been deleted, while it was still on issue. I don't know of a way in Koha to get these off the record. The easiest way is to do it in the database. Chris The materials in this message are private and may contain Protected Healthcare Information or other information of a sensitive nature. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this email in error, please immediately notify the sender via telephone or return mail.
Why does Koha allow one to delete an item record that is in use!?
It doesn't. You can't delete an item which is checked out if you try to do it from the Koha interface. Koha will warn you that the item is checked out. However, it's always possible someone could do deletions directly in the database. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
Actually, Checked out items can be deleted from the drop down box that says "Delete All Items". We had to stop using it for that reason. We used it for deleting our Interlibrary Loan temp records. You should use "Edit Items" on the same function and then delete from the table that appears. It checks for Checked out status. -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard Sent: Friday, April 01, 2011 3:57 PM To: Kelly, Betsy Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Problem circulation records
Why does Koha allow one to delete an item record that is in use!?
It doesn't. You can't delete an item which is checked out if you try to do it from the Koha interface. Koha will warn you that the item is checked out. However, it's always possible someone could do deletions directly in the database. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3544 - Release Date: 04/01/11 02:36:00
Interesting, this just proves how important it is for users to get involved and file bugs ;) If bugs for both of these had been filed they would be fixed now, but dont despair, there is still time. If they get filed, Ill make it my mission to get the fixes included in the 3.4.0 release, and if you do it fast, you might hit the 3.2.7 release. So my challenge to you and Nora is to file the bugs and my challenge to the developers is to fix them before the 8th. Chris On 2 Apr 2011 09:54, "Hal Bright" <HBright@farmingtonlibraries.org> wrote:
Actually, Checked out items can be deleted from the drop down box that says "Delete All Items". We had to stop using it for that reason. We used it for deleting our Interlibrary Loan temp records. You should use "Edit Items" on the same function and then delete from the table that appears. It checks for Checked out status.
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto: koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard Sent: Friday, April 01, 2011 3:57 PM To: Kelly, Betsy Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Problem circulation records
Why does Koha allow one to delete an item record that is in use!?
It doesn't. You can't delete an item which is checked out if you try to do it from the Koha interface. Koha will warn you that the item is checked out. However, it's always possible someone could do deletions directly in the database.
-- Owen
-- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3544 - Release Date: 04/01/11 02:36:00 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I just tested this in (something very close to) current master. The issue you describe here is no longer an issue in koha. Which version are you running? One caveat to that statement, as bug 3597 states, it still doesn't check for transit or waiting status for reserves. This screencap confirms that on issue items are not deleted, but that waiting and transit status items are deleted: http://screencast.com/t/Lh5vwCxetec I've updated the original bug to reflect this discovery. Thanks for bringing it up so that we could double check it! Liz Rea NEKLS On Apr 1, 2011, at 3:55 PM, Hal Bright wrote:
Actually, Checked out items can be deleted from the drop down box that says "Delete All Items". We had to stop using it for that reason. We used it for deleting our Interlibrary Loan temp records. You should use "Edit Items" on the same function and then delete from the table that appears. It checks for Checked out status.
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard Sent: Friday, April 01, 2011 3:57 PM To: Kelly, Betsy Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Problem circulation records
Why does Koha allow one to delete an item record that is in use!?
It doesn't. You can't delete an item which is checked out if you try to do it from the Koha interface. Koha will warn you that the item is checked out. However, it's always possible someone could do deletions directly in the database.
-- Owen
-- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3544 - Release Date: 04/01/11 02:36:00 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On 2 April 2011 10:22, Liz Rea <lrea@nekls.org> wrote:
I just tested this in (something very close to) current master. The issue you describe here is no longer an issue in koha. Which version are you running?
Ahh I see farmington libraries are running 3.01.00.145, which is from about the 22nd of July 2010, so a pretty old version now. I would recommend an upgrade at some point in the future, you will get over 500 changes, some bug fixes and some new features. One of the fixes is a fix to the bulk delete Chris
My installation of Koha does not allow me to delete item records in use. I've got smart barcodes still on the sheets that I've got checked out to ONSHEET and I get an error message when I try to delete them. Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commisson http://www.fishlib.org Koha 3.0 (thinking of upgrading soon)
Betsy, Which version of Koha are you using? Liz Rea NEKLS On Apr 1, 2011, at 2:27 PM, Kelly, Betsy wrote:
Why does Koha allow one to delete an item record that is in use!? It should be simple enough to check it's status before permitting the record to be deleted. It does that with patron records, why not item records?
Betsy Kelly Becker Medical Library Washington University in St Louis
Message: 5 Date: Fri, 1 Apr 2011 15:14:18 +1300 From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Problem circulation records To: Sharon Jackson <sjackson@ashs.school.nz> Cc: koha@lists.katipo.co.nz Message-ID: <AANLkTimKoqOjUy=d0W2nWyQ6JUfACUTEDROanNuO=pLB@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
2011/4/1 Sharon Jackson <sjackson@ashs.school.nz>:
Hi, Can anyone help me please? ? I have a problem with some of my circulation records. The patron checkout session shows that an item is checked out to a patron but there are no item details, just a due date, which I can't get rid of. The (non-existent)? item can't be checked in.? Can anyone suggest how to remove these?
Hi Sharon
I have seen this happen before when an item has been deleted, while it was still on issue. I don't know of a way in Koha to get these off the record. The easiest way is to do it in the database.
Chris
The materials in this message are private and may contain Protected Healthcare Information or other information of a sensitive nature. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this email in error, please immediately notify the sender via telephone or return mail. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Betsy, We've found out (the hard way) that if you reverse an imported batch of records using the batch import tool and some of those items are checked out, Koha will delete the item records anyway leaving you with blank check out information as you have described in your message. So don't reverse an imported batch of records using the batch import tool if there's any chance some of the items from that imported file could be checked out. Take care, Nora ________________________ Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 413-665-9898 x123 800-282-7755 Email: nblake@masslibsystem.org AIM: noraatmls -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Kelly, Betsy Sent: Friday, April 01, 2011 3:28 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Problem circulation records Why does Koha allow one to delete an item record that is in use!? It should be simple enough to check it's status before permitting the record to be deleted. It does that with patron records, why not item records? Betsy Kelly Becker Medical Library Washington University in St Louis Message: 5 Date: Fri, 1 Apr 2011 15:14:18 +1300 From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Problem circulation records To: Sharon Jackson <sjackson@ashs.school.nz> Cc: koha@lists.katipo.co.nz Message-ID: <AANLkTimKoqOjUy=d0W2nWyQ6JUfACUTEDROanNuO=pLB@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 2011/4/1 Sharon Jackson <sjackson@ashs.school.nz>:
Hi, Can anyone help me please? ? I have a problem with some of my circulation records. The patron checkout session shows that an item is checked out to a patron but there are no item details, just a due date, which I can't get rid of. The (non-existent)? item can't be checked in.? Can anyone suggest how to remove these?
Hi Sharon I have seen this happen before when an item has been deleted, while it was still on issue. I don't know of a way in Koha to get these off the record. The easiest way is to do it in the database. Chris The materials in this message are private and may contain Protected Healthcare Information or other information of a sensitive nature. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this email in error, please immediately notify the sender via telephone or return mail. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Whoa, that's a pretty big bug and I don't see anything like it in bugzilla. Since you know more about it would you mind filing one for that at bugs.koha-community.org? Liz Rea NEKLS On Apr 1, 2011, at 3:38 PM, Nora Blake wrote:
Hi Betsy,
We've found out (the hard way) that if you reverse an imported batch of records using the batch import tool and some of those items are checked out, Koha will delete the item records anyway leaving you with blank check out information as you have described in your message.
So don't reverse an imported batch of records using the batch import tool if there's any chance some of the items from that imported file could be checked out.
Take care,
Nora ________________________
Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 413-665-9898 x123 800-282-7755 Email: nblake@masslibsystem.org AIM: noraatmls
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Kelly, Betsy Sent: Friday, April 01, 2011 3:28 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Problem circulation records
Why does Koha allow one to delete an item record that is in use!? It should be simple enough to check it's status before permitting the record to be deleted. It does that with patron records, why not item records?
Betsy Kelly Becker Medical Library Washington University in St Louis
Message: 5 Date: Fri, 1 Apr 2011 15:14:18 +1300 From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Problem circulation records To: Sharon Jackson <sjackson@ashs.school.nz> Cc: koha@lists.katipo.co.nz Message-ID: <AANLkTimKoqOjUy=d0W2nWyQ6JUfACUTEDROanNuO=pLB@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
2011/4/1 Sharon Jackson <sjackson@ashs.school.nz>:
Hi, Can anyone help me please? ? I have a problem with some of my circulation records. The patron checkout session shows that an item is checked out to a patron but there are no item details, just a due date, which I can't get rid of. The (non-existent)? item can't be checked in.? Can anyone suggest how to remove these?
Hi Sharon
I have seen this happen before when an item has been deleted, while it was still on issue. I don't know of a way in Koha to get these off the record. The easiest way is to do it in the database.
Chris
The materials in this message are private and may contain Protected Healthcare Information or other information of a sensitive nature. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this email in error, please immediately notify the sender via telephone or return mail. _______________________________________________ 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
Hi Folks, I need to clarify that this happened to us when we first started using Koha in 2008 and 2009. I can't say whether this problem still happens because we don't revert files using the record import tool anymore. We got burned back then and have never had interest in seeing if the problem persists. Perhaps someone with a nice safe test system could try reverting an imported batch where they know some items are checked out and see what happens? Thanks, Nora ________________________ Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 413-665-9898 x123 800-282-7755 Email: nblake@masslibsystem.org AIM: noraatmls -----Original Message----- From: Liz Rea [mailto:lrea@nekls.org] Sent: Friday, April 01, 2011 4:39 PM To: Nora Blake Cc: 'Kelly, Betsy'; koha@lists.katipo.co.nz Subject: Re: [Koha] Problem circulation records Whoa, that's a pretty big bug and I don't see anything like it in bugzilla. Since you know more about it would you mind filing one for that at bugs.koha-community.org? Liz Rea NEKLS On Apr 1, 2011, at 3:38 PM, Nora Blake wrote:
Hi Betsy,
We've found out (the hard way) that if you reverse an imported batch of records using the batch import tool and some of those items are checked out, Koha will delete the item records anyway leaving you with blank check out information as you have described in your message.
So don't reverse an imported batch of records using the batch import tool if there's any chance some of the items from that imported file could be checked out.
Take care,
Nora ________________________
Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 413-665-9898 x123 800-282-7755 Email: nblake@masslibsystem.org AIM: noraatmls
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Kelly, Betsy Sent: Friday, April 01, 2011 3:28 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Problem circulation records
Why does Koha allow one to delete an item record that is in use!? It should be simple enough to check it's status before permitting the record to be deleted. It does that with patron records, why not item records?
Betsy Kelly Becker Medical Library Washington University in St Louis
Message: 5 Date: Fri, 1 Apr 2011 15:14:18 +1300 From: Chris Cormack <chris@bigballofwax.co.nz> Subject: Re: [Koha] Problem circulation records To: Sharon Jackson <sjackson@ashs.school.nz> Cc: koha@lists.katipo.co.nz Message-ID: <AANLkTimKoqOjUy=d0W2nWyQ6JUfACUTEDROanNuO=pLB@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
2011/4/1 Sharon Jackson <sjackson@ashs.school.nz>:
Hi, Can anyone help me please? ? I have a problem with some of my circulation records. The patron checkout session shows that an item is checked out to a patron but there are no item details, just a due date, which I can't get rid of. The (non-existent)? item can't be checked in.? Can anyone suggest how to remove these?
Hi Sharon
I have seen this happen before when an item has been deleted, while it was still on issue. I don't know of a way in Koha to get these off the record. The easiest way is to do it in the database.
Chris
The materials in this message are private and may contain Protected Healthcare Information or other information of a sensitive nature. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this email in error, please immediately notify the sender via telephone or return mail. _______________________________________________ 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
participants (7)
-
Chris Cormack -
Hal Bright -
Kelly, Betsy -
Lenora Oftedahl -
Liz Rea -
Nora Blake -
Owen Leonard