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 twilker...@critfc.org<mailto:twilker...@critfc.org> / 503.736.3581 From: Eric Phetteplace <ephettepl...@cca.edu> Sent: Friday, September 20, 2019 9:55 AM To: Tami Wilkerson <twilker...@critfc.org> Cc: koha@lists.katipo.co.nz 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) ephettepl...@cca.edu<mailto:ephettepl...@cca.edu> | 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 <twilker...@critfc.org<mailto:twilker...@critfc.org>> 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 twilker...@critfc.org<mailto:twilker...@critfc.org><mailto:twilker...@critfc.org<mailto:twilker...@critfc.org>> / 503.736.3581 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
