[Koha] Deleting items without barcodes

[Eric Phetteplace]

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)

ephetteplace at cca.edu | o 510.594.3660

5212 Broadway | Oakland, CA | 94618

:(){ :|: & };:


On Fri, Sep 20, 2019 at 9:43 AM Tami Wilkerson <twilkerson at 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
> twilkerson at critfc.org<mailto:twilkerson at critfc.org> / 503.736.3581
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>