View | Details | Raw Unified | Return to bug 22470
Collapse All | Expand All

(-)a/misc/migration_tools/switch_marc21_series_info.pl (-5 / +8 lines)
Lines 231-252 if ( $update_frameworks ) { Link Here
231
231
232
    # set new mappings for koha fields
232
    # set new mappings for koha fields
233
    $dbh->do(
233
    $dbh->do(
234
"UPDATE marc_subfield_structure SET kohafield='seriestitle'
234
"UPDATE marc_subfield_structure SET kohafield='biblio.seriestitle'
235
  WHERE tagfield='490' AND tagsubfield='a'"
235
  WHERE tagfield='490' AND tagsubfield='a'"
236
    );
236
    );
237
    $dbh->do(
237
    $dbh->do(
238
"UPDATE marc_subfield_structure SET kohafield='volume'
238
"UPDATE marc_subfield_structure SET kohafield='biblioitems.volume'
239
  WHERE tagfield='490' AND tagsubfield='v'"
239
  WHERE tagfield='490' AND tagsubfield='v'"
240
    );
240
    );
241
241
242
    # empty old koha fields
242
    # empty old koha fields
243
    $dbh->do(
243
    $dbh->do(
244
"UPDATE marc_subfield_structure SET kohafield=''
244
"UPDATE marc_subfield_structure SET kohafield=''
245
  WHERE kohafield='seriestitle' AND tagfield='440' AND tagsubfield='a'"
245
  WHERE kohafield='biblio.seriestitle' AND tagfield='440' AND tagsubfield='a'"
246
        );
246
        );
247
    $dbh->do(
247
    $dbh->do(
248
"UPDATE marc_subfield_structure SET kohafield=''
248
"UPDATE marc_subfield_structure SET kohafield=''
249
  WHERE kohafield='volume' AND tagfield='440' AND tagsubfield='v'"
249
  WHERE kohafield='biblioitems.volume' AND tagfield='440' AND tagsubfield='v'"
250
        );
251
    $dbh->do(
252
"UPDATE marc_subfield_structure SET kohafield=''
253
  WHERE kohafield='biblioitems.number' AND tagfield='440' AND tagsubfield='n'"
250
        );
254
        );
251
}
255
}
252
256
253
- 

Return to bug 22470