[Koha] Deleting items without barcodes

[Tami Wilkerson]

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
twilkerson at critfc.org<mailto:twilkerson at critfc.org> / 503.736.3581

From: Eric Phetteplace <ephetteplace at cca.edu>
Sent: Friday, September 20, 2019 9:55 AM
To: Tami Wilkerson <twilkerson at critfc.org>
Cc: koha at 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)

ephetteplace at cca.edu<mailto:ephetteplace at 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 <twilkerson at critfc.org<mailto: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><mailto: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<mailto:Koha at lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha