From bcf40fe9721eec418bf415334aeec50a67d64914 Mon Sep 17 00:00:00 2001 From: David Roberts Date: Sat, 9 May 2020 16:07:03 +0000 Subject: [PATCH] Bug 22470: Missing the table name on misc/migration_tools/switch_marc21_series_info.pl This patch adds the table name to the SQL update statements. To test: 1) Apply the patch 2) Run the script. Check that there are no errors, and that the script behaves as expected. Signed-off-by: Andreas Roussos Created a test record with values in field 440. Applied the patch, ran the script with the -c -f flags and observed that the values were moved to field 490. Also, the relevant Koha to MARC mappings were changed accordingly. Signed-off-by: Katrin Fischer Signed-off-by: Jonathan Druart (cherry picked from commit 051b0b8d2fb3dc3593147e5ac80bc394dcf48e58) Signed-off-by: Lucas Gass (cherry picked from commit 0ee5a38798a170e2e996ee330b3f2101a9ae59be) Signed-off-by: Aleisha Amohia --- misc/migration_tools/switch_marc21_series_info.pl | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) diff --git a/misc/migration_tools/switch_marc21_series_info.pl b/misc/migration_tools/switch_marc21_series_info.pl index 0bad3f2a54..925be0c8b3 100755 --- a/misc/migration_tools/switch_marc21_series_info.pl +++ b/misc/migration_tools/switch_marc21_series_info.pl @@ -231,22 +231,26 @@ if ( $update_frameworks ) { # set new mappings for koha fields $dbh->do( -"UPDATE marc_subfield_structure SET kohafield='seriestitle' +"UPDATE marc_subfield_structure SET kohafield='biblio.seriestitle' WHERE tagfield='490' AND tagsubfield='a'" ); $dbh->do( -"UPDATE marc_subfield_structure SET kohafield='volume' +"UPDATE marc_subfield_structure SET kohafield='biblioitems.volume' WHERE tagfield='490' AND tagsubfield='v'" ); # empty old koha fields $dbh->do( "UPDATE marc_subfield_structure SET kohafield='' - WHERE kohafield='seriestitle' AND tagfield='440' AND tagsubfield='a'" + WHERE kohafield='biblio.seriestitle' AND tagfield='440' AND tagsubfield='a'" ); $dbh->do( "UPDATE marc_subfield_structure SET kohafield='' - WHERE kohafield='volume' AND tagfield='440' AND tagsubfield='v'" + WHERE kohafield='biblioitems.volume' AND tagfield='440' AND tagsubfield='v'" + ); + $dbh->do( +"UPDATE marc_subfield_structure SET kohafield='' + WHERE kohafield='biblioitems.number' AND tagfield='440' AND tagsubfield='n'" ); } -- 2.39.5