How can one batch delete null barcoded item records?
We are using Koha 3.2 on Ubuntu. Our Assistant Librarian generated multiple item records (100) with null barcode number with same title. We have failed to delete as "delete this record in Edit is not doing anything". And worse still the Tools > Batch Item Deletion cannot work with null barcode. How cann we delete these records with are sequentially number as item #3315 to #3414? Any SQL solution or whatever that can do? Raphael
How cann we delete these records with are sequentially number as item #3315 to #3414? Any SQL solution or whatever that can do?
The batch item deletion tool can import a file of item numbers. Under "use a file," check "item number file" and upload a plain text file listing each item number on a separate line. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
Owen Thanks a lot. It worked, I actually missed out those two options of Barcode file and Items file in Tools> Batch Item Deletion . Raphael On 2/1/12, Owen Leonard <oleonard@myacpl.org> wrote:
How cann we delete these records with are sequentially number as item #3315 to #3414? Any SQL solution or whatever that can do?
The batch item deletion tool can import a file of item numbers. Under "use a file," check "item number file" and upload a plain text file listing each item number on a separate line.
-- Owen
-- Web Developer Athens County Public Libraries http://www.myacpl.org
participants (2)
-
Owen Leonard -
Raphael Muonga