Hello, I'm trying to refine my matching rules for importing staged records, and I'm having trouble setting up the right combination of match points to get matching in the way that I want. This is for loading ebook records, so if there is a matching print record I want to keep it *and* add the ebook record, but if there is a matching ebook record, I want to be able to either replace it or ignore the record so I don't have many duplicate ebook records from different vendors. Have any others found a solution for this? I want these types of scenarios to match: - Incoming 020a matches existing 020a - One of several incoming 020a match with existing 020a - Incoming 020a matches with one of several existing 020a - Incoming 020z match with existing 020z - Incoming 020z match with one of several existing 020z - One of several incoming 020z match with existing 020z - Incoming 020z match with existing 020z + text - Incoming 020z + text match with existing 020z And these types of scenarios to NOT match: - Incoming 020a match with existing 020z - Incoming 020z match with existing 020a Basically, if the ISBN and subfield of any 020 are the same, I want the system to find a match, regardless of how many other 020 fields are in the incoming/existing records. If the contents of 020 are the same but the SUBFIELDS ARE NOT (a vs. z), I don't want the system to find a match. I've tried all the combinations of record matching rules and match points I can think of, and I'm not able to get a rule combo that will even get close to what I'm hoping for (I would understand if the system can't handle matching on the numbers of the ISBN only, and ignoring extra text like "paperback.") Has anyone found a solution for loading ebook records from multiple vendors? I'd love to hear your workarounds, solutions, etc! I'm really feeling stuck here, and not wanting to add many duplicate ebook records to our catalog. -- Joelle Hannert Library Technical Services Coordinator Northwestern Michigan College (231) 995-1684 Work days: M, W, Th, F
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.njie@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
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-dele... 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) ephetteplace@cca.edu | o 510.594.3660 5212 Broadway | Oakland, CA | 94618 :(){ :|: & };: On Thu, Sep 19, 2019 at 1:09 PM NJIE, Isatou (LEWISHAM AND GREENWICH NHS TRUST) <isatou.njie@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.njie@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
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.njie@nhs.net<mailto:isatou.njie@nhs.net> ________________________________ From: Eric Phetteplace <ephetteplace@cca.edu> 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-dele... 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) ephetteplace@cca.edu<mailto:ephetteplace@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) <isatou.njie@nhs.net<mailto:isatou.njie@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.njie@nhs.net<mailto:isatou.njie@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<mailto: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
participants (3)
-
Eric Phetteplace -
Joelle Hannert -
NJIE, Isatou (LEWISHAM AND GREENWICH NHS TRUST)