Hello, We have a large number of items that have no barcodes attached and would like to remove them. I was considering just getting rid of them from mysql but I am concerned that this might have some problems elsewhere. Is there any utility we can use to remove these items and then, when they are gone, remove any bibs that are now item-less? Thanks Barry ________________________________ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted. For this reason, where the communication is by email, Interleaf Technology does not accept any responsibility for any breach of confidence which may arise through the use of this medium. This footnote also confirms that this email message has been swept for the presence of known computer viruses.
We also have the same problem with many items that have no holdings. I'm not sure what we are doing wrong in our data entry, but we have the same issue and we want to work on this problem too. Janet Deavor ----- Original Message ----- From: "Barry Cannon" <bar@interleaf.ie> To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Sent: Tuesday, August 17, 2010 4:04:21 AM Subject: [Koha] Removing items with no barcodes Hello, We have a large number of items that have no barcodes attached and would like to remove them. I was considering just getting rid of them from mysql but I am concerned that this might have some problems elsewhere. Is there any utility we can use to remove these items and then, when they are gone, remove any bibs that are now item-less? Thanks Barry This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted. For this reason, where the communication is by email, Interleaf Technology does not accept any responsibility for any breach of confidence which may arise through the use of this medium. This footnote also confirms that this email message has been swept for the presence of known computer viruses. _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi, In our library, when we delete the last Item attached to a Bib Record, the Bib Record is automatically deleted. To enable this functionality in Koha, our library had spend a lot of time writing some scripts and a new module for Koha. Now, when we want to delete items from Koha, instead of just clicking delete next to their Item Record, we search for the Bib Record in the catalogue and then in the record click on the barcode in the catalogue record and change the Item Status of the Item to Withdrawn. Then, in the module we wrote for Koha, called 'Item Deletion'. We open this module, and then just scan the barcodes of the items we have just marked as Withdrawn in the catalogue record, and the module will delete the Item Record and if it is the only Item attached to the Bib Record, it will also delete that Bib Record in particular. I, personally would love to contribute this module to the Koha community, but unfortunately, because of the many various components and configurations with this module, it would take a lot of time, which I unfortunately don't have to be able to do such a task. Sorry! I hope this is of some help in any way, shape, or form. Best WishesJoel Joel HarbottleLibrary TechnicianLibrary Services (Tasmania)Email: Joel.Harbottle@hotmail.com.au Date: Wed, 18 Aug 2010 11:56:18 +0000 From: deavorj@comcast.net To: koha@lists.katipo.co.nz Subject: Re: [Koha] Removing items with no barcodes We also have the same problem with many items that have no holdings. I'm not sure what we are doing wrong in our data entry, but we have the same issue and we want to work on this problem too. Janet Deavor ----- Original Message ----- From: "Barry Cannon" <bar@interleaf.ie> To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Sent: Tuesday, August 17, 2010 4:04:21 AM Subject: [Koha] Removing items with no barcodes Hello, We have a large number of items that have no barcodes attached and would like to remove them. I was considering just getting rid of them from mysql but I am concerned that this might have some problems elsewhere. Is there any utility we can use to remove these items and then, when they are gone, remove any bibs that are now item-less? Thanks Barry This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted. For this reason, where the communication is by email, Interleaf Technology does not accept any responsibility for any breach of confidence which may arise through the use of this medium. This footnote also confirms that this email message has been swept for the presence of known computer viruses. _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Joel Harbottle wrote:
In our library, when we delete the last Item attached to a Bib Record, the Bib Record is automatically deleted.
That sounds like a different problem to deleting all items with no barcodes and then any biblios with no items left.
To enable this functionality in Koha, our library had spend a lot of time writing some scripts and a new module for Koha. [...]
Why was it done that way? It seems like something could be added to C4::Items::DelItem($biblionumber, $itemnumber) that deletes the Biblio for $biblionumber if $itemnumber was the last item and the librarian wants to auto-delete empty bibs. So it's only a small patch to Koha's internals and add some user interface to it. In general, I think libraries like to know that they had a book once, even if the last item has gone, but I could be wrong. It also saves them recataloguing it if they order a new copy. Hope that helps, -- MJ Ray (slef) Webmaster and developer for hire at | software www.software.coop http://mjr.towers.org.uk | .... co IMO only: see http://mjr.towers.org.uk/email.html | .... op
Janet Deavor wrote:
We also have the same problem with many items that have no holdings. I'm not sure what we are doing wrong in our data entry, but we have the same issue and we want to work on this problem too.
As long as nothing's different in your version to mine, I think just getting rid of them from mysql will work, as long you remove all of them and do a full reindex afterwards, but searching and using the perl function C4::Biblio::DelBiblio($dbh,$biblionumber) would be safer. I don't remember any utility for this, but perhaps there is one. Hope that helps, -- MJ Ray (slef) Webmaster and developer for hire at | software www.software.coop http://mjr.towers.org.uk | .... co IMO only: see http://mjr.towers.org.uk/email.html | .... op
participants (4)
-
Barry Cannon -
deavorj＠comcast.net -
Joel Harbottle -
MJ Ray