[Bug 32487] New: Cronjob to delete records with no items
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487 Bug ID: 32487 Summary: Cronjob to delete records with no items Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs@lists.koha-community.org Reporter: aleisha@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org CC: robin@catalyst.net.nz We've been requested to develop a cronjob to clear out bibliographic records with no items. This could be useful if there's a duplicate record where items are being attached, so the other record is empty and not being used in Koha, just crowding search results. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487 Aleisha Amohia <aleisha@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED Assignee|koha-bugs@lists.koha-commun |aleisha@catalyst.net.nz |ity.org | Change sponsored?|--- |Sponsored -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487 Emmi Takkinen <emmi.takkinen@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |emmi.takkinen@koha-suomi.fi -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487 Andrew Fuerste-Henry <andrewfh@dubcolib.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |andrewfh@dubcolib.org --- Comment #1 from Andrew Fuerste-Henry <andrewfh@dubcolib.org> --- It'd be great if this included some way to exclude some itemless bibs, for libraries that include bibs for ebooks without attached item records. Maybe an option to exclude certain biblio-itemtypes from the deletion? Or to exclude bibs with something in the 856? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- There are actually quite a lot of cases that come to mind, where a record has no items but is still wanted/needed: * Set type records for multi-volumes * Series type records for traced series * Records where the item is linked using EasyAnalytics * Analytical records using 773 standard linking * Serials where the library has subscriptions and issues, but doesn't create items * Acquisition records where the library doesn't attach items or new standing order records * Electronic resources - 856 might not be best, as it could also be some other type of content enrichment like a scanned TOC. Maybe 007, Pos. 0? https://www.loc.gov/marc/bibliographic/bd007.html Maybe an option: add a --WHERE SQL condition option to the existing batchdeletebiblios.pl. This way it would allow libraries to easily specifiy "has no items", without going into the rabbit hole of discussing all the above cases. Keeping it simple. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #3 from David Cook <dcook@prosentient.com.au> --- Locally we handle this scenario using a custom report page where librarians can review bib records with no items attached. They'll often exclude electronic resources by item type. It's a more manual process than a cronjob, but it's less error prone I think. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487 Aleisha Amohia <aleisha@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution|--- |FIXED --- Comment #4 from Aleisha Amohia <aleisha@catalyst.net.nz> --- Thanks all for your discussion. I ended up using cronjobs/runreport.pl to run a report fetching the biblionumbers of biblios with no items, piping those results into a file, then giving that file to batchdeletebiblios.pl. I'll close this bug report now. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org