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] | o 510.594.3660 5212 Broadway | Oakland, CA | 94618 :(){ :|: & };: On Fri, Sep 20, 2019 at 9:43 AM Tami Wilkerson <[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]> / 503.736.3581 > > > > _______________________________________________ > Koha mailing list http://koha-community.org > [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
