Re: [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)

ephettepl...@cca.edu | o 510.594.3660

5212 Broadway | Oakland, CA | 94618

:(){ :|: & };:


On Fri, Sep 20, 2019 at 9:43 AM Tami Wilkerson 
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
> (formerly StreamNet Library)
> 700 NE Multnomah St. Suite 515
> Portland, OR 97232
> twilker...@critfc.org / 503.736.3581
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> 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

[Koha] Deleting items without barcodes

[Tami Wilkerson]

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 
(formerly StreamNet Library)
700 NE Multnomah St. Suite 515
Portland, OR 97232
twilker...@critfc.org / 503.736.3581



___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Get Listed Paid Support Request

[Owen Leonard]

> Website: http://metalanka.com

I'm not responsible for adding entries to the web site, but I wanted
to point out this information from
https://koha-community.org/support/paid-support/how-to-get-listed/,

"Companies must show their support of the Koha Community by adding a
visible link to the Koha community website at
https://www.koha-community.org to their Koha offering web page."

I don't see a link to the Koha web site on this page:
http://metalanka.com/access-control/library-management-system/

Also please note the correct spelling of Koha. Not "KOHA."

  -- Owen

-- 
Web Developer
Athens County Public Libraries
https://www.myacpl.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Expired Patron Records

[NJIE, Isatou (LEWISHAM AND GREENWICH NHS TRUST)]

Hi Eric,



Thank you very much for your advice and providing the link to the 
documentation.   Greatly appreciated!



Best wishes,


Isatou N'jie
Deputy Library Services Manager
Lewisham and Greenwich NHS Trust
Queen Elizabeth Hospital
Library Services
Stadium Road
SE18 4QH

Tel: 0208 836 6742  Email: isatou.n...@nhs.net

From: Eric Phetteplace 
Sent: 19 September 2019 09:37
To: NJIE, Isatou (LEWISHAM AND GREENWICH NHS TRUST)
Cc: Koha
Subject: Re: [Koha] Expired Patron Records

Hi Isatou,

Yes! There is. Koha staff side > Tools > "Batch patron deletion and 
anonymization". You didn't say what version you're on but here is the 18.11 
documentation for that: 
https://koha-community.org/manual/18.11/en/html/tools.html#batch-patron-deletion-anonymization

You can set criteria to delete the patrons so it sounds like simply using the 
"expiration date before..." option is sufficient for you. Or it may be easier 
to create a list of all the patrons then choose to delete everyone in the list. 
Whenever we do any batch patron operation, we try to use patron lists. If you 
have a report that pulls all the barcodes for the patrons, you can pretty 
easily paste the results to make a list of them all.

Best,

ERIC PHETTEPLACE Systems Librarian (he/him)

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 Thu, Sep 19, 2019 at 1:09 PM NJIE, Isatou (LEWISHAM AND GREENWICH NHS TRUST) 
mailto:isatou.n...@nhs.net>> wrote:
Dear All,

I'm new to using KOHA.  I need to do a global delete (batch delete) of expired 
patron (member) records.  Is there a simple method to doing this on koha?

Any advice would be gratefully received.

Kind regards,


Isatou N'jie
Deputy Library Services Manager
Lewisham and Greenwich NHS Trust
Queen Elizabeth Hospital
Library Services
Stadium Road
SE18 4QH

Tel: 0208 836 6742  Email: isatou.n...@nhs.net






This message may contain confidential information. If you are not the intended 
recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take 
any action in relation to its contents. To do so is strictly prohibited and may 
be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff 
in England and Scotland. NHSmail is approved for exchanging patient data and 
other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, 
https://portal.nhs.net/help/joiningnhsmail

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha




This message may contain confidential information. If you are not the intended 
recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take 
any action in relation to its contents. To do so is strictly prohibited and may 
be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff 
in England and Scotland. NHSmail is approved for exchanging patient data and 
other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, 
https://portal.nhs.net/help/joiningnhsmail

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Use of indicators in field 245

[Ere Maijala]

Hi,

Even if leadign article or other nonfiling characters can be handled
pretty well in modern search engines, it's worth noting that it's not so
straight-forward for sorting or any left-anchored searches. Like you
mentioned, we should always keep in mind that MARC records can be
exchanged between systems, and not all are created equal. In my
experience any deviation from standards comes back to bite you at the
latest when you switch systems.

Regards,
Ere

Eric Phetteplace kirjoitti 18.9.2019 klo 19.55:
> Hi Giacomo,
> 
> You're right that the second indicator, nonfiling characters, doesn't
> really seem to do anything. It's an archaic holdover and probably not
> needed with the complicated indexing mechanisms that are available to us
> now. It's pretty trivial for machines to skip leading stopwords like "the"
> etc. without instruction.
> 
> The first indicator is still meaningful, I believe. Having a main entry
> under one of the 1XX fields and then a title added entry is enabled by this
> indicator. So following this example documentation
> 
> I found:
> 
> 111 2# $a Federal Management Improvement Conference.
> 245 10 $a Proceedings of the Federal Management Improvement Conference.
> 
> The "title" of the serial is the name of the conference and the 245 is used
> as an added entry. I'm not a cataloger so the function of a title added
> entry isn't entirely clear to me but a lot  (about half) of our records
> have this indicator set to 1.
> 
> So our records still use both indicators, however we mainly copy catalog.
> It makes sense to keep using the fields especially when it's free like
> this. Just because they don't have a lot of importance in Koha doesn't mean
> another system won't care about them and it makes the data more consistent
> with other MARC repositories.
> 
> Best,
> 
> ERIC PHETTEPLACE Systems Librarian (he/him)
> 
> ephettepl...@cca.edu | o 510.594.3660
> 
> 5212 Broadway | Oakland, CA | 94618
> 
> :(){ :|: & };:
> 
> 
> On Wed, Sep 18, 2019 at 12:07 AM Giacomo Visini <
> giacomo.vis...@divaantwerp.be> wrote:
> 
>> Hi fellow Koha users,
>>
>> Just a quick question. Can someone shed a light on the use of the
>> indicators in field 245? Since our conversion to Koha we stopped using
>> them, but data from previous systems has these indicators filled in. Upon
>> inspection, in most cases the given value is even wrong somehow (0's are
>> 1's etc.). But it doesn't seem to affect indexation.
>>
>> So my question is, is there no need to fill in the indicators of field
>> 245? Do you guys use them? For what purpose?
>>
>> For the sake of exhaustivity: we are currently using version 18.11.06.000
>>
>> Thanks in advance for any replies.
>>
>> Kind regards,
>>
>> Giacomo Visini I Bibliotheekmedewerker
>> DIVA, Antwerp Home of Diamonds
>> Gildekamersstraat 9, B-2000 Antwerpen
>> T + 32 3 360 52 42
>> giacomo.vis...@divaantwerp.be
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> 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
> 

-- 
Ere Maijala
Kansalliskirjasto / The National Library of Finland
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha