[Bug 26868] New: biblio and biblio_metadata tables timestamp do not update when moving an item
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26868 Bug ID: 26868 Summary: biblio and biblio_metadata tables timestamp do not update when moving an item Change sponsored?: --- Product: Koha Version: 19.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: addie@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org If you move an item from one biblio record to another, neither of the biblio nor biblio_metadata tables timestamps' are updated. Only the timestamp on the item that moves is updated. It would incredibly useful if at least the timestamp on the biblio record the item is moving away from updates. This would be super helpful for making sure records in Aspen Discovery are being updated properly. You can test this by going to a bib record and adding an item. If you then look at the timestamp in the biblio or biblio_metadata tables for the original bib record and new bib record, they will not be altered -- 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=26868 AspenCat Team <aspencatteam@clicweb.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |aspencatteam@clicweb.org --- Comment #1 from AspenCat Team <aspencatteam@clicweb.org> --- This would be very useful to our libraries. Without this working, there isn't a good way to track moving one item from a record to another record. - Bob Bennhoff -- 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=26868 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I can understand the use case, but I feel like it would be giving wrong information somehow to update the timestamp on the record level without an actual change to the record. For example it would create extra updates over our API to the union catalog, where we don't transfer items, but only record changes. That probably would not be that many, but it might be worth seeing if we can figure out a different way to make the 'remove' of items known. How does Aspen Discovery get the record information from Koha, OAI-PMH? How does it deal with deleted items? -- 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=26868 Mark Noble <mark@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mark@bywatersolutions.com --- Comment #3 from Mark Noble <mark@bywatersolutions.com> --- Aspen Discovery is using an ODBC connection to the database to determine what records and items have changed by looking at the biblio timestamp, biblio_metadata timestamp, items timestamp. To determine which bibs and items have been deleted it looks at deleteditems and deletedbiblio. When an item has been moved to another bib, we can detect that it is changed, but we only know the new bib number, not the old bib number. So there is not an easy way to determine that the old bib record also needs to be updated to not include the item. Because items are part of the bib record, we feel it is appropriate to update the timestamp for the old bib record when the item is moved. If that turns out to not be appropriate, we would suggest creating another timestamp for when items within the biblio are created, or deleted so we can detect changes to the contents of the record. -- 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=26868 Arthur Suzuki <arthur.suzuki@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |arthur.suzuki@biblibre.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26868 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I think there is work underway to log biblio record merges, maybe we could also create a specific log entry for moving items? -- 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=26868 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|19.11 |master -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org