[Bug 38133] New: Create a touch_all_authorities.pl script
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38133 Bug ID: 38133 Summary: Create a touch_all_authorities.pl script Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: caroline.cyr-la-rose@inlibro.com QA Contact: testopia@bugs.koha-community.org Bug 30047 added a new column to the auth_header table, but for existing systems, there is no way to populate this new column when upgrading. It was suggested to create a touch_all_authorities.pl script. -- 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=38133 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30047 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30047 [Bug 30047] Add a field to auth_header to record main heading as text string -- 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=38133 Phil Ringnalda <phil@chetcolibrary.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |phil@chetcolibrary.org -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38133 Bernard <bernard.scaife@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bernard.scaife@ptfs-europe. | |com --- Comment #1 from Bernard <bernard.scaife@ptfs-europe.com> --- Created attachment 175394 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=175394&action=edit touch_all_authorities script Might be useful to add to maintenance tools. -- 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=38133 Michelle Spinney <mspinney@clamsnet.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mspinney@clamsnet.org -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38133 Fridolin Somers <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fridolin.somers@biblibre.co | |m --- Comment #2 from Fridolin Somers <fridolin.somers@biblibre.com> --- +1 -- 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=38133 --- Comment #3 from Fridolin Somers <fridolin.somers@biblibre.com> --- Or maybe reuse "touch_all_biblios.pl" as "touch_all_records.pl" with option "--record-type" like in misc/export_records.pl -- 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=38133 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38133 Janusz Kaczmarek <januszop@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Small patch Status|NEW |Needs Signoff -- 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=38133 --- Comment #4 from Janusz Kaczmarek <januszop@gmail.com> --- Created attachment 196093 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196093&action=edit Bug 38133: Generalize touch_all_biblios.pl into touch_all_records.pl A script is needed that touches all authority records. This can be achieved by generalizing the touch_all_biblios.pl script: touch_all_records.pl. -- 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=38133 Janusz Kaczmarek <januszop@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |januszop@gmail.com Attachment #175394|0 |1 is obsolete| | -- 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=38133 Janusz Kaczmarek <januszop@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Create a |Generalize |touch_all_authorities.pl |touch_all_biblios.pl into |script |touch_all_records.pl -- 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=38133 --- Comment #5 from David Cook <dcook@prosentient.com.au> --- Hmm there are other types of records than bib and auth records though so it makes the name less descriptive I think? -- 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=38133 --- Comment #6 from Janusz Kaczmarek <januszop@gmail.com> --- (In reply to David Cook from comment #5)
Hmm there are other types of records than bib and auth records though so it makes the name less descriptive I think?
Thanks for commenting. I followed Fridolin's suggestion. What would be yours in this case? touch_records.pl would be fine? -- 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=38133 --- Comment #7 from David Cook <dcook@prosentient.com.au> --- (In reply to Janusz Kaczmarek from comment #6)
(In reply to David Cook from comment #5)
Hmm there are other types of records than bib and auth records though so it makes the name less descriptive I think?
Thanks for commenting. I followed Fridolin's suggestion. What would be yours in this case? touch_records.pl would be fine?
What do you think about "touch_all_marc_records.pl"? It's quite specific which would be both a pro and a con for the future... I mean... touch_all_records.pl might be fine. Maybe touch_all_items.pl should be merged in at a later date as another record type. That could make sense. Yeah maybe stick with "touch_all_records.pl" -- 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=38133 --- Comment #8 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- After discussion, Janusz and I thought that maybe touch_all_whatever maybe was not the right way to solve the issue I raised in the description which is to populate the auth_header.heading column for existing authorities. Maybe a batchRebuildAuthTables.pl might be more the way to go? I'm not against this new touch_all_records script, and it works, but what bothers me a little bit is that it changes the modified date in the db and the 005 of the authority. I would not be comfortable to do this on upgrade in my clients' instances... -- 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=38133 --- Comment #9 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- For alternative, see bug 42211 -- 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=38133 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=42211 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org