@@ -, +, @@ misc/migration_tools/switch_marc21_series_info.pl --- misc/migration_tools/switch_marc21_series_info.pl | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) --- a/misc/migration_tools/switch_marc21_series_info.pl +++ a/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'" ); } --