[Bug 9548] New: Store bibliographic information in aqorders table ?
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 Bug ID: 9548 Summary: Store bibliographic information in aqorders table ? Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: mathieu.saby@univ-rennes2.fr At present, in aqorders table, Koha stores the biblionumber of the record. If the record is suppressed (or merged I suppose) for some reason, the title, author, publisher, date of the ordered document could no more be retrieved. At the end of the year if you make a report for listing all the documents ordered that year, bibliographic information will be missing for some documents. So, would it be possible to store critical bibliographic information (title, author, publisher, date ?) in aqorders table? M. Saby Rennes 2 university -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nengard@gmail.com --- Comment #1 from Nicole C. Engard <nengard@gmail.com> --- I agree with this. I think the biblionumber should still be there for clicking and seeing the full record, but the basics should be in the orders table or linked to acq in some other way. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hm, I am not sure how this would work. If you delete a record, you can still query the biblionumber in the deleted* tables for your reports, so it's not lost. But if you merge 2 records - which information should be stored? I think some libraires might say that it's right that the old information is discarded at least for some use cases. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #3 from Nicole C. Engard <nengard@gmail.com> --- The problem I see is that the basket says 'deleted title' or something like that - so it's not querying the deleted tables to show the basket info. We need a way to keep the basket showing the info that was on the order even if it has been deleted. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I think the answer is to query the table then :) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #5 from mathieu saby <mathieu.saby@univ-rennes2.fr> --- Hello Katrin Yes, using deleted tables could be a good idea, for avoiding the "deleted record" line. But... it would not be perfect, in case the record used by the order is modified by the library after the reception of the item. Ex : You mispell a title, or you put a wrong isbn or title, and you correct it after reception. If you print again the basketgroup, the information will not be exactly the same as before your changes. It is a detail, but I think Koha should have a way to print an EXACT copy of an order made 6 month ago. This could be useful for improving our relations with our vendors, and with accounting services. Currently we have to store copies of pdf basketgroups in a directory, outside Koha. Mathieu -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- But what if you want to print a corrected copy? If you have made mistakes and want to resend a corrected order to your vendor? - I am just saying this is a bit complicated and storing the created order or logging the data might be the better approach. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Complicated in that it's not easy to tell what the expected behaviour is for everyone in every situation... hope I make sense. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #8 from mathieu saby <mathieu.saby@univ-rennes2.fr> --- If the prices of the order were wrong, and does not match the invoiced price, I think the accounting department will ask us for the invoice, not a corrected version of the order. If an "basket group" in Koha is to be understood as a "Purchase order" (http://en.wikipedia.org/wiki/Purchase_order), it is not supposed to be changed after it is send to the bookseller. Or maybe it could be changed only in very special occasion, and voluntarily. Mathieu -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #9 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Mathieu, I never said I don't see a need to store the information, but I still doubt that the aqorders table is the right place to do it. Changing the bibliographic data is only one part of it. You will also be able to move order lines in the future and you can undo every step in the ordering workflow and potentially modify data. So I think if we want to 'freeze' information we should think about a different technical solution. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #10 from mathieu saby <mathieu.saby@univ-rennes2.fr> --- OK My point of view : We should focus on taking into account the deleted tables could be easily done, and backported to 3.12/10/8. For the "freezing" of the basketgroups, it would be a more important enhancement, maybe only for new versions, and it deserves more thinking to find the right solution. Do you agree wuith that ? If so, we could keep this bug for the "freezing", and create a new bug for taking into account the deleted tables ? Mathieu -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #11 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Sounds good to me. Maybe change the bug title to reflect the general goal? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 mathieu saby <mathieu.saby@univ-rennes2.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Store bibliographic |Add a way to 'freeze' the |information in aqorders |content of a basket group |table ? | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #12 from mathieu saby <mathieu.saby@univ-rennes2.fr> --- done ;-) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 --- Comment #13 from mathieu saby <mathieu.saby@univ-rennes2.fr> --- I won't have time to create a new bug today for implementing the use of 'deleted*' tables (I'm struggling with inventory...). Do you have time to do that? Mathieu -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9548 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=10758 -- 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