Perfect, thanks! Tami
Tami Wilkerson, MLIS Library Program Lead/Librarian Columbia River Inter-Tribal Fish Commission Columbia Basin Fish & Wildlife Library<https://www.streamnetlibrary.org/> (formerly StreamNet Library) 700 NE Multnomah St. Suite 515 Portland, OR 97232 [email protected]<mailto:[email protected]> / 503.736.3581 From: Eric Phetteplace <[email protected]> Sent: Friday, September 20, 2019 9:55 AM To: Tami Wilkerson <[email protected]> Cc: [email protected] Subject: Re: [Koha] Deleting items without barcodes Hi Tami, You can get them with a report. If it's true that you only want to delete items without barcodes, then this report should do it: SELECT itemnumber FROM items WHERE barcode = '' OR barcode IS NULL That pulls items with no barcode field or (usually equivalent) an empty barcode field. You can then download a CSV file of the results, copy all the itemnumbers, and paste them into the bulk delete tool. You seem to know that you want to do this but I would caution; there can be legitimate reasons for items not to have barcodes, e.g. for electronic resources, but if you know that that isn't the case for you just ignore me. Best, ERIC PHETTEPLACE Systems Librarian (he/him) [email protected]<mailto:[email protected]> | o 510.594.3660 [https://www.cca.edu/sites/default/files/images/cca-logotype-394.png] 5212 Broadway | Oakland, CA | 94618 :(){ :|: & };: On Fri, Sep 20, 2019 at 9:43 AM Tami Wilkerson <[email protected]<mailto:[email protected]>> wrote: Hello, I have a list of items that I would like to batch delete but the items do not have barcodes. There is an option to batch delete using an item number file but I do not know how to extract the item numbers from Koha to make the file. Can anyone help? Thanks, Tami Tami Wilkerson, MLIS Library Program Lead/Librarian Columbia River Inter-Tribal Fish Commission Columbia Basin Fish & Wildlife Library<https://www.streamnetlibrary.org/> (formerly StreamNet Library) 700 NE Multnomah St. Suite 515 Portland, OR 97232 [email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>> / 503.736.3581 _______________________________________________ Koha mailing list http://koha-community.org [email protected]<mailto:[email protected]> https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
