[Bug 42211] New: Add a script to populate auth_header.heading column of existing authority records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 Bug ID: 42211 Summary: Add a script to populate auth_header.heading column of existing authority records Initiative type: --- Sponsorship --- status: 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 introduced a new column to the auth_header table, but for existing systems, there is no way to populate this new column when upgrading. -- 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=42211 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=38133 Depends on| |30047 CC| |januszop@gmail.com --- Comment #1 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- With bug 38133, we tried updating the touch_all_biblios script to include authorities, but it has caveats... 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=42211 Janusz Kaczmarek <januszop@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff Patch complexity|--- |Trivial patch Assignee|koha-bugs@lists.koha-commun |januszop@gmail.com |ity.org | -- 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=42211 --- Comment #2 from Janusz Kaczmarek <januszop@gmail.com> --- Created attachment 196462 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196462&action=edit Bug 42211: Add a script to populate auth_header.heading column of existing authority records Test plan: ========== 1. In current ktd installation auth_header.heading column should be empty; if it if not: UPDATE auth_header SET heading = NULL; 2. Make sure taht the column is empty. 3. Run the script: misc/batchRebuildAuthHeaderTable.pl -c 4. Verify that the column is populated now and that the 005 fields in authority records has not been modified. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 --- Comment #3 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- This now changes the modification time in the db (no choice, it's a timestamp), but avoids changing the 005 of the record. It works. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 Janusz Kaczmarek <januszop@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #196462|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 --- Comment #4 from Janusz Kaczmarek <januszop@gmail.com> --- Created attachment 196464 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196464&action=edit Bug 42211: Add a script to populate auth_header.heading column of existing authority records Test plan: ========== 1. In current ktd installation auth_header.heading column should be empty; if it if not: UPDATE auth_header SET heading = NULL; 2. Make sure that the heading column is empty. 3. Run the script: misc/batchRebuildAuthHeaderTable.pl -c 4. Verify that the column is populated now and that the 005 fields in authority records has not been modified. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 Janusz Kaczmarek <januszop@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #196464|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 --- Comment #5 from Janusz Kaczmarek <januszop@gmail.com> --- Created attachment 196467 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196467&action=edit Bug 42211: Add a script to populate auth_header.heading column of existing authority records Test plan: ========== 1. In current ktd installation auth_header.heading column should be empty; if it if not: UPDATE auth_header SET heading = NULL; 2. Make sure that the heading column is empty. 3. Run the script: misc/batchRebuildAuthHeaderTable.pl -c 4. Verify that the column is populated now and that the 005 fields in authority records has not been modified. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 Janusz Kaczmarek <januszop@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #196467|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 --- Comment #6 from Janusz Kaczmarek <januszop@gmail.com> --- Created attachment 196482 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196482&action=edit Bug 42211: Add a script to populate auth_header.heading column of existing authority records Test plan: ========== 1. In current ktd installation auth_header.heading column should be empty; if it if not: UPDATE auth_header SET heading = NULL; 2. Make sure that the heading column is empty. 3. Run the script: misc/batchRebuildAuthHeaderTable.pl -c 4. Verify that the column is populated now and that the 005 fields in authority records has not been modified. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #196482|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 --- Comment #7 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- Created attachment 196483 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196483&action=edit Bug 42211: Add a script to populate auth_header.heading column of existing authority records Test plan: ========== 1. In current ktd installation auth_header.heading column should be empty; if it if not: UPDATE auth_header SET heading = NULL; 2. Make sure that the heading column is empty. 3. Run the script: misc/batchRebuildAuthHeaderTable.pl -c 4. Verify that the column is populated now and that the 005 fields in authority records has not been modified. Signed-off-by: Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 --- Comment #8 from Janusz Kaczmarek <januszop@gmail.com> --- Created attachment 196529 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196529&action=edit Bug 42211: (follow-up) add option to keep modification_time unchanged It seems appropriate to leave modification_time unchanged when populating the heading column. This is the current default behavior. It can be changed by adding the --update-timestamp flag. The DBI interface is used to allow manipulation of the timestamp. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #196483|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #196529|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 --- Comment #9 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- Created attachment 196586 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196586&action=edit Bug 42211: Add a script to populate auth_header.heading column of existing authority records Test plan: ========== 1. In current ktd installation auth_header.heading column should be empty; if it if not: UPDATE auth_header SET heading = NULL; 2. Make sure that the heading column is empty. 3. Run the script: misc/batchRebuildAuthHeaderTable.pl -c 4. Verify that the column is populated now and that the 005 fields in authority records has not been modified. Signed-off-by: Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42211 --- Comment #10 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- Created attachment 196587 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=196587&action=edit Bug 42211: (follow-up) add option to keep modification_time unchanged It seems appropriate to leave modification_time unchanged when populating the heading column. This is the current default behavior. It can be changed by adding the --update-timestamp flag. The DBI interface is used to allow manipulation of the timestamp. Signed-off-by: Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org