[Koha-bugs] [Bug 32487] Cronjob to delete records with no items

2023-01-09 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487

Aleisha Amohia  changed:

   What|Removed |Added

 Status|ASSIGNED|RESOLVED
 Resolution|--- |FIXED

--- Comment #4 from Aleisha Amohia  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 32487] Cronjob to delete records with no items

2022-12-18 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487

Aleisha Amohia  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|koha-b...@lists.koha-commun |alei...@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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 32487] Cronjob to delete records with no items

2022-12-18 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487

Emmi Takkinen  changed:

   What|Removed |Added

 CC||emmi.takki...@koha-suomi.fi

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 32487] Cronjob to delete records with no items

2022-12-19 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487

Andrew Fuerste-Henry  changed:

   What|Removed |Added

 CC||andre...@dubcolib.org

--- Comment #1 from Andrew Fuerste-Henry  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 32487] Cronjob to delete records with no items

2022-12-19 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487

--- Comment #2 from Katrin Fischer  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 32487] Cronjob to delete records with no items

2022-12-19 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32487

David Cook  changed:

   What|Removed |Added

 CC||dc...@prosentient.com.au

--- Comment #3 from David Cook  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/